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