Job ID :
1641
Company :
Virginia Information Technology Agency
Location :
richmond, VA
Type :
Hire
Duration :
6 months
Status :
Active
Openings :
1
Posted :
6 years ago
Job Seekers, Please send resumes to resumes@hireitpeople.com

 

Complete Description:

**local candidates strongly preferred

 

VDH is for an experience ETL/BI developer/analyst to build a BI dashboard using logiXML as the reporting tool

 

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 MICROSOFT, ORACLE AND OTHER BI TECHNOLOGIES.  AS AN ETL DEVELOPER/ANALYST THIS CANDIDATE WILL BE RESPONSIBLE FOR DEVELOPING ETLS TO LOAD DATA FROM MULTIPLE SOURCES INTO THE DATA WAREHOUSE AND DOCUMENTING ALL THE REQUIREMENTS FOR BUILDING THE BI DASHBOARD AND ASSOCIATED REPORTS. 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.

THE CURRENT TECHNOLOGY INFRASTRUCTURE IS BASED ON   LOGIXML, COGNOS, SQL SERVER 2008, ORACLE 11G AND ASP .NET

SPECIFIC TASK(S):

•             ELICIT REQUIREMENTS FOR THE BI DASHBOARD.

•             CRITICALLY EVALUATES INFORMATION GATHERED FROM MULTIPLE SOURCES AND RECONCILES POTENTIAL CONFLICTS.

•             COMMUNICATE AND COLLABORATE WITH CUSTOMERS TO ANALYZE INFORMATION, BUSINESS PROBLEM AND AUTOMATION NEEDS.

•             DEVELOPS ETL AND DIMENSIONAL MODELS TO PULL DATA FROM MULTIPLE SOURCES INTO DATA WAREHOUSE

•             CREATE  REPORTS USING THE TOOLS SPECIFIED

•             ASSIST IN CREATING PRELIMINARY PROJECT PLAN, TEST PLAN AND TEST CASES.

 

Skills:

Experience with Extract, Transform, Load (ETL) systems using oracle SQL Loader and PL/SQL

Required 5 Years

 

Strong development skills in at least one report deployment solution (i.e., Cognos, LogiXML, Crystal Reports or Reporting Services

Required 2 Years

 

Strong SQL Experience

Required 5 Years

 

SQL SERVER/Oracle 10g or higher Experience

Required 5 Years

 

BI background

Required 2 Years

 

Business and System Analysis

Required 3 Years

 

Use cases, test plans

Required 2 Years

 

Experience creating high level task plans and deliverables

Desired 2 Years

 

Good Oral and written communication

Required 5 Years

 

Data Retrieval and Analysis using advanced PL/SQL techniques

Required 3 Years