Job ID :
6466
Company :
State of Iowa
Location :
DES MOINES, IA
Type :
Contract
Duration :
6 Months
Status :
Active
Openings :
1
Posted :
17 Feb 2015
Job Seekers, Please send resumes to resumes@hireitpeople.com

Short Description:

Individual's primary responsibilities will be designing, developing, and implementing SSRS reporting for Business Intelligence, Financial, Spatial, and Operational Reporting for the enterprise. 

 

Complete Description:

Individual will be responsible for the design and development of SSAS cubes and other data warehousing objects and SSRS reports based upon said objects. 

 

Experience architecting and delivering mapping reports containing spatial and analytical layers, importing (ESRI files) and manipulating geodata is highly desirable. 

 

Experience creating data flows and process flow diagrams, and product support documents.

 

Expert level T-SQL abilities developing complex T-SQL statements and stored procedures; strong understanding of T-SQL query performance optimization

 

Ability to use Windows Server 2012, Windows 7, and Microsoft Office 2010 for word processing and spreadsheet manipulation.

 

Collaborative attitude, flexible interaction with but not limited to, business, database, application, and infrastructure units with a focus on knowledge transfer to technical team members.

 

Strong troubleshooting skills.

 

Excellent verbal and written communication skills.

 

 

Skills:

Skill

Required / Desired

Amount

of Experience

Masterful, data warehouse experience with SQL 2008 R2 or greater

Required

6

Years

Design, development, and deployment of SSRS reports

Required

6

Years

Detailed experience with dimensional modeling (SSAS) and OLAP

Required

6

Years

Designing and maintaining ETL processes (SSIS).

Required

6

Years

Expert level T-SQL abilities developing complex T-SQL statements and stored procedures; strong understanding of T-SQL query performance optimization

Required

6

Years

Experience creating data flows and process flow diagrams, and product support documents

Highly desired

 

 

Experience architecting and delivering mapping reports containing spatial and analytical layers, importing (ESRI files) and manipulating geodata

Highly desired