Previous Job
SQL Data Warehouse Developer
Ref No.: 19-09945
Category: Experienced Professional
Location: Chicago, Illinois
Position Type:Contract
Start Date / End Date: 02/01/2019 to 03/15/2019
Genesis10 is currently seeking a Data Warehouse Developer with our client in the healthcare industry in their Chicago, IL location. This is a 12 month + contract to hire position.

  • Handling design, development and implementation of the Enterprise Data Warehouse, data marts and related applications for client.
  • Develops, maintains, and executes extraction, transformation and load (ETL) routines for importing data from heterogeneous data sources into the data warehouse using MS SQL Server Integration Services (SSIS)
  • Work with business SME's and data architects to implement dimensional data models
  • Helps to define and implement standards and practices for data warehousing initiatives throughout the company
  • Acts as a subject matter expert for the Information Management team when interacting with internal business partners and external clients
  • Troubleshoot production dataflow and code
  • Provide optimization suggestions for queries that pull from EDW data marts
  • Expert in developing complex ETL processes (SSIS)
  • Expert in writing, tuning and troubleshooting complex SQL scripts
  • Strong documentation experience and verbal communication skills for collaboration with business stakeholders and technical peers
  • Able to contribute on an individual basis and as part of a team
  • Strong understanding of data normalization rules, denormalization and other techniques to support reporting and analytics
  • Experience with database as a service in Azure
  • Experience creating column store indexes
  • 1+ years of experience with SQL Server 2016
  • 10+ years of progressive responsibilities within IT functions, with a strong track record of work delivery and organizational leadership.
  • 10+ years hands-on experience in data warehousing development and design
  • 10+ years of ETL process design experience, preferably with MS SQL Server Integration Services (SSIS)
  • Minimum Education:
  • Bachelor's degree in Computer Science or equivalent work experience

If you have the described qualifications and are interested in this exciting opportunity, please apply!

About Genesis10:

Genesis10 is a leading U.S. business and technology consulting firm with hundreds of clients needing proven talent and solutions to power their strategic initiatives. If you are a high performing business or IT professional with solid, referenced experience, we want to meet you. Genesis10 recruiters and delivery professionals are highly accomplished career advocates, who get to know you beyond your resume to position you with the opportunities that fit your skills, experience and aspirations. We have benefit options to fit your needs and a support staff that works with you from placement throughout your engagement – project after project. To learn more about Genesis10 and to view all our available career opportunities, please visit us at "Genesis10 is an Equal Opportunity Employer, M/F/D/V”