| Duties & Responsibilites : | Local candidates strongly preferred
CLIENT 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.
REQUIRED 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
INTERVIEW PROCESS:
In Process |
