Job Seekers, Please send resumes to resumes@hireitpeople.com
Complete Description:
*local candidates strongly preferred
VDH IS IN NEED OF A HIGHLY SKILLED ETL DEVELOPER/SYSTEMS ANALYST WITH A STRONG BACKGROUND IN SCALABLE, HIGH QUALITY, AND HIGH PERFORMANCE BUSINESS INTELLIGENCE (BI) DASHBOARDS AND RELATED APPLICATIONS BUILT USING ORACLE AND OTHER BI TECHNOLOGIES.
AS AN ETL DEVELOPER/ANALYST THIS CANDIDATE WILL BE PRIMARILY RESPONSIBLE FOR DEVELOPING ETLS TO PERFORM LOADING, SANITIZATION, AND DIMENSIONAL MODELING OF DATA FROM MULTIPLE SOURCES. THE DEVELOPER WILL ALSO CONTRIBUTE TO BUILDING THE BI DASHBOARD AND ASSOCIATED REPORTS, REQUIRING WRITING SOPHISTICATED QUERIES AND UTILIZING AN UNDERSTANDING OF DATA PRESENTATION FUNDAMENTALS.
WORKS AS PART OF THE VIRGINIA DEPARTMENT OF HEALTH, OFFICE OF INFORMATION MANAGEMENT (OIM) DATA WAREHOUSE TEAM TO PROVIDE DEVELOPMENT, SYSTEM ANALYSIS, TECHNICAL SUPPORT AND PEER TROUBLESHOOTING ASSISTANCE TO HELP IMPROVE VDH DECISION MAKING, OPTIMIZE PERFORMANCE, AND ACHIEVE REPORTING REQUIREMENTS. THIS CANDIDATE WILL WORK WITH A TEAM OF ANALYSTS, DEVELOPERS, MANAGERS, AND BUSINESS RESOURCES TO BUILD HIGHLY PERFORMING SYSTEMS.
CODE SAMPLES REQUIRED
SPECIFIC TASK(S):
• DEVELOPS ETL AND DIMENSIONAL MODELS TO PULL DATA FROM MULTIPLE SOURCES INTO DATA WAREHOUSE
• CRITICALLY EVALUATES INFORMATION GATHERED FROM MULTIPLE SOURCES AND RECONCILES POTENTIAL CONFLICTS.
• COMMUNICATE AND COLLABORATE WITH CUSTOMERS TO ANALYZE INFORMATION, BUSINESS PROBLEM AND AUTOMATION NEEDS.
• CREATE REPORTS USING THE TOOLS SPECIFIED
• ASSIST IN CREATING PRELIMINARY PROJECT PLAN, TEST PLAN AND TEST CASES.
Skills:
Skill |
Required / Desired |
Amount |
of Experience |
Dimensional modeling |
Required |
3 |
Years |
Business and System Analysis |
Required |
3 |
Years |
SQL development expertise using Oracle /SQL Server 2008 or higher |
Required |
4 |
Years |
Data Analysis using advanced techniques |
Required |
4 |
Years |
Experience with Extract, Transform, Load (ETL) systems |
Required |
4 |
Years |
Experience in at least one report deployment solution (i.e., Tableau, Cognos, LogiXML, Crystal Reports or Reporting Services) |
Desired |
2 |
Years |
Creating High Level Task Plan and Deliverables |
Desired |
3 |
Years |
Must possess excellent Oral and Verbal Communication |
Required |
10 |
Years |