Description

You will own the maintenance, monitoring, and optimization of the data warehouse ETL infrastructure.

This role is on-site.

Responsibilities

• Monitor daily job executions in Compose to identify and resolve production errors.
• Validate data quality and accuracy across pipelines.
• Modify tasks to incorporate new tables and transforms.
• Maintain core structure upgrades and implement security-related tasks.
• Monitor latencies and perform performance tuning.

Required Skills

• 8-10 years of experience in data warehousing and ETL development.
• Advanced SQL proficiency, including complex joins, subqueries, and common table expressions.
• Strong debugging skills and performance tuning techniques.
• Expertise in SSIS.
• Experience with data warehousing automation tools.

Preferred Skills

• Data modeling experience, particularly in healthcare subject areas.
• Understanding of data warehouse architecture.

Key Skills

Education

Any Graduate