Job Summary

Database Developer (SSIS / Hadoop) - Exciting CONTRACT TO HIRE JOB // Downtown Chicago

  • Location:
    Chicago , Illinois
  • Salary:
    55 $ - 60 $ / Hour
  • Category:
    Information Systems
  • Contract Type:
  • Job reference:

Modis is currently seeking a Database Developer who has an expertise with SQL SSIS and Big Data Technologies (Hadoop).  This is a CONTRACT TO HIRE job opportunity with our top Investment Banking client, located in the heart of downtown Chicago / central loop.
Candidates must be eligible to work directly with Modis on a W2 basis, and should be eligible to convert to full-time status within 6 months, without the need for work-visa sponsorship.
Our client is one of the largest investment and brokerage firms in the US, with more than 15,000 employees nationwide.  This Database Developer will be joining the Asset Liability Management line of business to assist with Capital Stress Testing & Market Risk Reporting.  Primary responsibilities will be to develop, maintain and document the a new data infrastructure used for Data Governance – using SQL SSIS and Hadoop.
Primary Responsibilities will include:
• Developing a new database infrastructure for Data Governance and Stress testing by consolidating several data sources into one primarily platform using SSIS, Pig and Sqoop (for Hadoop).
• Building new data flows, data structures and business logic using SQL, and Data modeling tools, like Erwin.
• Developing complex SQL Queries and leading query optimization efforts.
• Conducting data analysis using Pig and related tools.
• Understanding process inputs and creating solutions to automate the data sources.
• Conducted data management and applying data governance standards
• Conducting data lineage and data quality analysis to ensure consistency of data from the source to target.
• Ensuring the data meets quality thresholds for validity, integrity and accuracy
• Supporting day to day data operations and troubleshooting issues that arise.
• Designing database and data models using Erwin or other data modeling tools
Required Qualifications & Experience
- Required Bachelor of Science in a Computer Science or MIS field.
- 5+ years’ experience in SQL Database Development
- Experience with Erwin or other data modeling tools
- Strong experience with SQL-based business intelligence with SSIS
- Strong experience with Hadoop and big-data analytics (Pig, Sqoop)
- A background in Data Quality Management or Data Governance is preferred
- Experience with any Big Data Analytics software (Aginity, Informatica PowerCenter, MapR, Hadoop, etc) preferred
If interested in this or other SQL Business Intelligence jobs available through Modis in the Downtown Chicago area, please apply today with your most recently up to date MS Word resume – or visit our website at to view and apply for and of the hundreds of IT jobs we currently have across the US!  
Duration: 6 Months Contract to Hire
Rate: $55-$60/ hour W2
Conversion Salary Range: $100,000 - $110,000 / year
Benefits: Optional benefits available through Modis include Medical/Dental/Vision insurance, 401K, Commuter benefits, flexible spending accounts, continued training and more!

Apply Below


Note: Required fields marked with an asterisk (*).


Primary Number
[Ctrl (Cmd Mac) + Click] to select multiple industries
Upload your resume
Terms of Use


Upload your resume using

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability.

Equal employment opportunity information:
EEO is the Law (poster) | EEO is the Law (poster supplement) | Reaffirmation of Affirmative Action Policy Statement