41879: Columbus, OH – IT – EDU – Technical Specialist 1/TS1

Re-post of ID# 41367. No candidate selected. DO NOT RE-SUBMIT candidates previously submitted to 41367. PLEASE SEE ATTACHED JOB DESCRIPTION (scroll down and download Word document) and review details below, as additional skills have been added.

Posting will close to submissions on Monday, 8/8 at 10amEST. Onsite interviews only.

EDU is looking for a candidate with excellent dimensional data modelling skills and VERY STRONG communication skills, we s/he will be working closely with the business user to gather requirements. The secondary skill needed is building SSAS CUBEs and SSRS Reports. Candidates should have PROVEN work experience and able to speak to that in the interview.

Description of Duties:
20% of Total Work Effort: Meet business users to understand and analyze their processes
25% of Total Work Effort: Analyze the data generated by the business process, define the granularity, source to target mapping of the data elements, and create Indexes and Aggregate tables for the data warehouse design and development
30% of Total Work Effort: Lead Data Modeling, System/Data Analysis, Design and Development for Data warehousing environments (the physical modelling using Erwin will be done by the database analyst from ODE). Build Logical Data models (Dimensional & Relational) using concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables. Our Data Warehouse system resides on an Oracle environment.
5% of Total Work Effort: Assist the ETL developer in populating the data from the transactional system to the data warehouse system. ODE uses Informatica for ETL
10% of Total Work Effort: Create CUBE using Microsoft Analysis Service -- Create dimensions, measures and measure groups. These cubes will source the data from the data warehouse system
10% of Total Work Effort: Create Microsoft SSRS/Train ODE .NET developers in SSRS report creation

Experience Requirements:
• 8-10 years' overall experience in IT
• 5-7 years in data warehouse design / maintenance.
• 3--5 years' experience in each position skill listed below:
• Meeting business users and analyze the requirements for the dimensional purpose.
• Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables. Modelling experience in an Oracle database environment is preferred.
• Must have experience in designing dimensional data models/facts from scratch.

Highly recommended but not required skills. 1-2 years' experience in each position skill listed below:
• Building CUBE using Microsoft Analysis Service.
• Building reports using Microsoft SSRS

Recommended but not required skills. 1-2 years' experience in each position skill listed below:
• Microsoft SSIS/Informatica for ETL
• PL/SQL and/or T-SQL
• MDX Queries

The selected resource will be fully integrated into a team of developers and will work directly with stakeholders representing program offices across the agency
Resource will be working on: EAS (Enterprise Application Service) is a .NET system that supports multiple business processes in ODE. The current system doesn’t have any dashboard and reporting capabilities. This project will address those shortcomings.
First phase of the project will create an OLAP (Data warehouse for the systems) database. This is where we expect the contractor to spend most of the time.
In the second phase, after the OLAP is designed, Microsoft Analysis Cubes will be built using the OLAP data.
In the last phase, the dashboard will source the data from the Microsoft Analysis Cubes and display the data using a 3rd party charting controls. The SSRS reports will source the data from same or similar MS Cubes. The reports will be available only for internal business users whereas the dashboard will be available to both internal and external audiences.

Comments are closed.