Previous Job
ETL/Data Engineer
Ref No.: 17-09660
Location: Itasca, Illinois
Position Type:Right to Hire
Start Date: 09/27/2017
*** No C2C/3rd party candidates will be accepted for this role. My client cannot sponsor. Thank you. ***

: ETL/Data Engineer
Location: Itasca, IL
Duration: Direct Hire/or Contract to Hire
Rate/Salary: Open DOE
Start: ASAP

Position Description:
My client is looking for an ETL/Data Engineer to work at Itasca, IL corporate office. This is a direct hire or contract to hire position.

This professional will be responsible for supporting the company's payment integrity applications, database, and reporting needs. Primary responsibilities will be to analyze, design, develop, implement and maintain technical solutions in AWS and Azure using data warehouse technologies, SQL Server 2016 with sharding, distributed cache solution, Azure Data Factory, SSIS, and ETL solutions.

Key Role/Responsibilities:
  • Assist in creating technical solutions to satisfy business requirements through database and application design and development
  • Lead data modeling and requirements analysis efforts
  • Debug and optimize enterprise database-driven applications
  • Create backup and archiving strategies for big data stored in various formats (files, SQL and NoSQL databases, etc.)
  • Assist in the development of database and application interfaces between various hardware and/or software systems
  • Develop and maintain BI reports for internal and external consumption, leveraging PowerBI, SQL Server Reporting Services, Excel, etc
  • Create data integration and technical solutions around Microsoft SQL Server, Azure Data Lake, and Azure Data Warehouse
  • Create and maintain various data import/export processes using ETL solutions such as SQL Server Integration Services
  • Assist technical and business analyst in the preparation of the data analysis materials
  • Participate in application design discussions and the change management process
  • Apply a high standard of customer service when interacting with all levels of staff
  • Responsible for maintaining technical documentation to support new and existing solutions
  • Assist with other special projects or related duties as assigned

Required Skills
  • Bachelor's Degree or equivalent experience
  • 4+ years of experience in MS SQL databases and development environments in a corporate IT environment including:
    • Solid understanding of SQL vs NoSQL technologies (ACID vs Base)
    • Experience in development of data-driven systems using ETL frameworks
    • Experience in writing and publishing reports in PowerBI and SSRS
    • Strong understanding of general BI and Data warehouse best practices
    • Ability to create and troubleshoot complex T-SQL through stored procedures and views
    • Willingness to learn new technologies
    • Excellent oral and written communication skills with all levels of users and management
    • Proficient in SQL Management Studio 2005/2008/2012/2016, Azure DB, Azure Data Warehouse, Visual Studio 2005/2008/2012 and SQL Profiler
  • Good understanding of SSIS Packages and third-party components (Fuzzy lookup, Slow Changing Dimensions, XML, CSV files, FTP, etc.)
  • Comfortable reading and interpreting XML
  • Experience with developing data models (conceptual, physical and logical) which describe data elements, their relationships and how they are used
  • Ability to understand data principles, data structure options and able to analyze existing data/structure to produce complex data mapping
  • Ability to estimate design and development efforts of complex solutions

If interested and well qualified, please send an updated copy of your resume to