IIT Inc. Home

IIT Jobs Data Bank-Job Detail

Submit Resume For This Job (via email)
Follow us on LinkedIn or Twitter or Facebook
Follow us on Facebook Follow us on LinkedIn
ID Location Skills $$ Job Type Status
12177 Chicago, IL 60601 SSIS Data Integration and ETL Specialist - with P&C Insurance Data Experience (No Visa Sponsorship) DOE FTE Employee CLOSED
If you are unable to click on links above to submit resume, you may email your resume to

Subject=IIT Career Site/Resume for JobID=12177 (SSIS Data Integration and ETL Specialist - with P&C Insurance Data Experience (No Visa Sponsorship)) in Chicago IL 60601 (AMI)

FTE Permanent Employee position - although client may consider Contract-to-Hire

This client does NOT provide visa sponsorships

Mandatory Requirements

Microsoft SSIS / ETL experience with strong SQL Scripting skills

Good understanding of Property and Casualty Insurance Data Sets

Business / Systems Analysis Skills 

Good understanding of relational/dimensional data model

Desired Requirements

SSAS (SQL Server Analysis Services) (Tabular)


Ability to read and understand C# 

Understanding of RESTful Api


Client is a P&C Software Developer Company, with locations around the world. They have a NEW product developed for auto/home insurance industry. In order to demo the product to customers, there needs to be significant relevant data added to the demo systems (dataset with hundreds of millions of rows with auto/home insurance quote/premium/billing data)

The Data Integration Specialist hired for this role will have some knowledge of P&C data... will work with users to understands needs of different "demos" the company is working on. Thereafter, this person will create SQL Scripts and load/test the data into the application. 

The candidate will work heavily with SSIS and SQL and will have strong background in understading relational / dimensional data models.

Submit Resume For This Job (via email)
Don't See a Position Matching Your Skills?
Click here to Email / Register your resume and be notified of future job openings.
About IIT:

Founded in 1995, IIT is a leading provider of Workforce Solutions to Government and Fortune-1000 organizations. IIT is a winner of Inc-500 award. IIT's core services include:

  • Consulting for projects / IT Outsourcing
  • IT staffing (Contract / Temporary / Contingent / Consulting)
  • Custom Workforce Solutions
  • Recruitment Process Outsourcing (RPO)
  • Headquartered in New York, IIT has over 400 consultants deployed at Client Sites. Other IIT highlights include

  • Winner of Inc-500 award 2 consecutive years
  • Winner of Ernst & Young / USPAACC Fast-50 award 2 consecutive years
  • Winner of USPAACC Top-10 Award in the Northeast US
  • IBM Business Partner
  • Oracle Business Partner
  • Adobe Business Partner
  • NYSA Member - New York Staffing Association - Regional Affiliate of ASA / American Staffing Association
  • NYS MBE certified
  • Our Consultants love working for IIT

  • Competitive compensation
  • W2 or C2C
  • Biweekly Direct Deposit for W2 Consultants
  • Visa and Green Card sponsorship opportunities for qualified individuals
  • Local contact for you to meet and talk to anytime (not someone sitting overseas in a different time zone)
  • Follow us on LinkedIn or Twitter or Facebook

    IIT is an Equal Opportunity Employer