Skip to content

CareerBoard

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 
OR
Clear covering letter
 
 
 * denotes required field
 
 
 
Additional Information:
 
First Name
 
Last Name
 
Address
 
Country
 
Home Telephone
 
Mobile/Cell
 
Availability/Notice
 
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

 

Senior Data Warehouse Developer (SSIS) (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) for a position in Chicago, IL.

Client is open to a 6-month contract with extensions or a 6-month contract-for-hire. Client will also allow 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 7 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: 08 Nov 2019 Reference: JS6239789 Company: Resource 1 Contact: Sarah Smith