Job ID :
6710
Company :
State of Iowa
Location :
IOWA CITY, IA
Type :
Contract
Duration :
6 Months+
Salary :
Open
Status :
Active
Openings :
1
Posted :
25 Mar 2015
Job Seekers, Please send resumes to resumes@hireitpeople.com
Short Description:

Partners with cross-disciplinary leadership to define complex functional and technical specifications to existing and new ETL processes working with SQL Server 2012 using SQL Server Management Studio tools against databases.

Complete Description:

•    Leads analysis and design of new ETL (Extract/Transform/Load programs) development across multiple clinical disciplines. 
•    Acts as a functional expert for analyzing SQL to generate efficient database code as to not negatively impact other database processes.  
•    Identifies best reporting solution by analyzing user reporting requirements and data retrieval complexity and quantity in the development of custom reporting content.  
•    Serves as the liaison for technical staff, users, vendors and key stakeholders across the entire organization to analyze, document, recommend and implementing reporting content in the applicable areas.



Required / Desired Skills
Skill
Required / Desired
Amount
of Experience
Application development experience as a lead programmer or technical expert in a complex computing environment
Required
5
Years
Experience with SQL Server Management Studio 2012, including SSIS.
Required
3
Years
Experience writing complex SQL queries and performance tuning
Required
 
 
Comprehensive understanding of relational database concepts
Required
 
 
Proven track record of researching, organizing, analyzing, and synthesizing data to support effective decision making.
Required
 
 
Excellent verbal and written communication skills.
Required
 
 
Experience with Business Objects XI3.1 or XI4.0 reporting tools (Universe Designer/Information Design Tool, WEBI, Crystal Reports).
Highly desired
 
 
Familiarity with Epic applications and Clarity database structure.
Highly desired