Description

You will design, program, and monitor electronic data import/export functions and ETL processes.

This role is on-site.

Responsibilities

• Perform data profiling on source data to identify quality issues, anomalies, and metadata.
• Design and implement process cleanup after complex ETL runs to release system resources.
• Map data elements across multiple systems using standardized templates and best practices.
• Develop new solutions, generate ad-hoc reports, and fix bugs within data workflows.

Required Skills

• 10 years of data integration and ETL experience using SQL Server Integration Services (SSIS).
• 8 years of SQL programming experience.
• 5 years of experience designing ETL processes, including naming conventions and multi-system connectivity.
• 5 years of recent professional experience as an MS SQL DBA.
• Strong understanding of Master Data Management (MDM), data warehouses, and data marts.
• Experience with Microsoft platforms including SSIS, DQS, and MDS.
• Working knowledge of AWS, Azure, and Amazon Redshift.
• Understanding of ITSM/ITBM frameworks.

Preferred Skills

• Knowledge of ServiceNow.
• Familiarity with GitHub version control.
• Experience with healthcare standard data sets such as HIPAA ANSI X12, ADT, or CCD.

Bachelor’s Degree in Computer Science, Computer Engineering, or a closely related field.

Key Skills

Education

Any Graduate