Skip to content


Contact us at 1-877-619-5627
Advertise your job!

Job Application


Please answer the following questions in order to process your application.

Email Address *
I certify that I am a U.S. citizen, permanent resident, or a foreign national with authorization to work in the United States. *
File Attachments:
(2MB file maximum. doc, docx, pdf, rtf or txt files only)
Attach a Resume * 
Optional covering letter 
Clear covering letter
 * denotes required field
Additional Information:
First Name
Last Name
Home Telephone
Hourly Rate USD
Approximately how far are you willing to travel to work (in miles) ?

Key Privacy Information

When you apply for a job, CareerBoard will collect the information you provide in the application and disclose it to the advertiser of the job.

If the advertiser wishes to contact you they have agreed to use your information following data protection law.

CareerBoard will keep a copy of the application for 90 days.

More information about our Privacy Policy.


Job Details


Sr. SSIS/Azure Developer (Contract/Full Time)

Location: Chicago, Illinois Country: United States of America Rate: Market (DOE)

Resource 1 is in need of a Sr. Data Warehouse Developer (SSIS)/Azure SQL Database Developer for a contract-for-hire position in Chicago, IL. Individual will join a team responsible for the design, development and implementation of ETL routines using SSIS to import data from heterogeneous sources into the data warehouse. This is a very large (40 TB), complex, highly available environment that includes clustered columnstore indexing.


  • Azure SQL Database data mart development and support
  • Data load design and implementation from on-premise sources into Azure SQL Database
  • Design, development and implementation of the Enterprise Data Warehouse, data marts and related applications
  • Design and development of ETL solutions using MS SQL Server Integration Services (SSIS)
  • Design and development of OLAP solutions using MS SQL Server Analysis Services (SSAS)
  • Work with business SMEs and data architects to implement dimensional data models
  • Help define and implement standards and practices for data warehousing initiatives
  • Act as a SME for the Information Management team when interacting with internal business partners and external clients
  • Assign and track developer tasks
  • Mentor and coach developers
  • Develop and execute release plans
  • Troubleshoot production dataflow and code
  • Provide optimization suggestions for queries that pull from EDW data marts


  • 8+ years of progressive responsibilities within IT functions, with a strong track record of work delivery and organizational leadership
  • 8+ years hands-on experience in data warehousing development and design
  • 8+ years of ETL process design experience, preferably with SSIS
  • 1+ years leading a development team
  • Expert in Azure SQL Database development, changes, maintenance and support
  • Expert in developing complex ETL processes using SSIS
  • Expert in writing, tuning and troubleshooting complex SQL scripts
  • Expert in designing and implementing database schemas using Kimball/Inmon methodologies
  • Strong documentation experience, verbal communication skills and collaboration ability
  • Strong understanding of data normalization rules, denormalization and other techniques to support reporting and analytics
  • Healthcare industry experience would be a plus

Technical Environment: SQL Server, ETL, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Azure SQL Database, Enterprise Data Warehouse (EDW), Database Objects, Kimball/Inmon, Database Schemas, OLAP, Data Marts, Dimensional Data Models, Columnstore Indexing, SQL, Data Normalization & Data Denormalization.

Posted Date: 30 Aug 2019 Reference: JSSSIS312 Company: Resource 1 Contact: Sarah Smith