Job Title: Technical Specialist 1
NTE Rate: $85.00
Will close to submissions: Friday 7/27/2018 at 10:00am EST
Interview: First round phone. Second round onsite may be required.
Description of Duties (Primary & Secondary) – List the top 5 and their % of Total Time.
1. Meet business users to understand and analyze their processes – 20% of time.
2. Assist ODE in determining the appropriate Data Visualization tools (Power BI or Tableau) or Reporting tools (MS SSRS or Cognos Reports) - 10% of time.
3. Build Reports in Power BI or Tableau, SSRS or Cognos – 50% of time .
Optional Duties (Based on skills or resource availability)
4. Create CUBE using Microsoft Analysis Service -- Create dimensions, measures and measure groups. These cubes will source the data from the data warehouse system as defined in the Step 2. – 10% of time.
5. Assist/train ODE .NET developers in SSRS/Tableau/PowerBI/Cognos report creations – 10% of time.
Total 100%
Position Description – Position 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 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
Building reports using PowerBI
Building reports using Tableau
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
MS Azure experience
This person will work with ODE Fiscal office to create BI reports for them. Also, the candidate will work closely with the data manager and App Dev Director.
