Data Warehousing Analyst III - Local Preferred (Remote/Part time) Salem, OR - 12 Months

Data Warehousing Analyst III - Local Preferred (Remote/Part time) Salem, OR - 12 Months

28 Mar 2024
Oregon, Salem, 97301 Salem USA

Data Warehousing Analyst III - Local Preferred (Remote/Part time) Salem, OR - 12 Months

Vacancy expired!

Job Title: Data Warehousing Analyst III Local Preferred (Remote/Part time)
Location: Salem, OR
Duration: 12 Months

Note: Selected candidates need to be on board Onsite. They need to pick their on- boarding documents and equipment manually. No expenses will be paid for travelling
Job Description:
Full-time professional Information Technology Project Development work experience and/or Function/Business Process Analysis work experience. May require a degree in a related area and at least 6 years or equivalent experience in the field or in a related area. Substitutions: Accredited college training may substitute for the required work experience with a maximum substitution of four (4) years. (Fifteen (15) semester hours in Information Technology or a related area is required.) Accredited graduate training in the above area may substitute for the required work experience with a maximum substitution of two (2) years. Successfully completion of an Information Technology Certification program, may substitute for the required work experience with a maximum substitution of two (2) years. (Proof of certification must accompany application.) Two (2) years of work experience as a Database Analyst-Intermediate; Data Warehousing Programmer; Database Analyst-Associate may substitute for all of the required experience.
The purpose of this request is to procure professional services for Client State Project Delivery Branch (Technology and Data Unit). This engagement is to work with the Business Intelligence Data Warehouse program. The primary tasks the contractor will perform are as follows:
Able to analyze, design and build solutions using Microsoft SQL stack, including SSIS, SSRS, and SSAS.
Gather business automation, data integration and reporting requirements, document use cases, and analyze data and data sources to determine conceptual database and cube solution designs.
Able to analyze data using data modeling techniques and develop data models
Design, develop and implement ETL packages using SSIS
Perform tuning or other analytics to improve efficiency and performance of cube solutions
Design, develop, test and implement multidimensional and tabular OLAP cubes and relational databases. Write complex data queries using programming languages including MDX, SQL and DAX.
Create dashboard and reporting mock-ups and prototypes from conceptual design through testing and implementation. Develop and publish reports, dashboards, ad hoc reporting from conceptual design through delivery. Report and dashboard data sources could be any combination of Enterprise Data Warehouse sources (DW schemas, views, cubes, etc.) or non- Data Warehouse sources such as legacy Client information systems, Access databases, Excel files, flat files, etc.

Required/Desired Skills

Skill Matrix
Skill Matrix
Technology
Years of Experience
Overall IT Experience

Communication (1 - 10)

Data Analysis

Microsoft SQL Server

MS Power BI

PBIRS Power BI Reporting Server

SSAS Sql Server Analysis Services

Communication skills both verbal and written

Microsoft Office

Visual Studio

Related jobs

Job Details

  • ID
    JC11527103
  • State
  • City
  • Job type
    Contract
  • Salary
    $DOE
  • Hiring Company
    GSK Solutions Inc.
  • Date
    2021-03-28
  • Deadline
    2021-05-27
  • Category

Jocancy Online Job Portal by jobSearchi.