Previous Job
SSIS ETL Designer
Ref No.: 17-09125
Location: Itasca, Illinois
Position Type:Right to Hire
Start Date: 09/27/2017
Title: SSIS ETL Designer 
Location: Itasca
Rate: DOE
Start Date: ASAP 

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
Required Experience
4+ years of experience in MS SQL databases and development environments in a corporate IT environment