Description

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

Responsibilities

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

Required Skills

• 10 years of data integration and ETL experience using SQL Server Integration Services (SSIS).
• 8 years of SQL programming experience.
• 8 years of IT industry 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.
• 4 years of experience identifying and mapping data elements across disparate systems.
• 3 years of experience using Agile Scrum methodology.
• 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.
• Bachelor’s Degree in Computer Science, Computer Engineering, or a closely related field.

Preferred Skills

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

Key Skills

Education

Any Graduate