Skip to content

This website works best using cookies which are currently disabled.Cookie policy  Allow cookies

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, JobServe 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.

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

More information about our Privacy Policy.


Job Details


Senior Data Warehouse Developer (SSIS) (Contract)

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

Resource 1 is in need of a Sr. Data Warehouse Developer (SSIS) for a 6-month contract (with extensions) in Chicago, IL.

Client permits working from home up to 2 days a week after candidate has been there a couple months. Selected individual will join a team responsible for the development, maintenance and execution of extraction, transformation and load (ETL) routines for importing data from heterogeneous data sources into the data warehouse using MS SQL Server Integration Services (SSIS). Individual should have at least 10 years of data warehouse/SSIS experience. This is a very large (40 TB of data), complex, HA (Highly Available) environment that includes SQL Server 2016 databases and clustered columnstore indexing (CCI). Must have experience designing, developing, enhancing and troubleshooting SSIS packages. Should also be knowledgeable in designing and implementing database schemas using Kimball/Inmon methodologies. Strong T-SQL development/tuning experience is required. Individual will work with business SMEs and Data Architects to design and implement 3NF and dimensional data models. May also be asked to help define and implement standards and practices for data warehousing initiatives throughout the company. Selected individual should understand data normalization and denormalization rules, as well as other techniques to support reporting and analytics.

Technical Environment:

MS SQL Server, SQL Server Integration Services (SSIS), T-SQL, Enterprise Data Warehouse (EDW), Database Objects, Dimensional Data Models, Kimball/Inmon, Database Schemas & Columnstore Indexes.

Posted Date: 13 Mar 2020 Reference: JSDWH_SSIS_2020 Company: Resource 1 Contact: Sarah Smith