Description

You will manage and maintain the enterprise data warehouse ETL infrastructure, ensuring data integrity and system stability.

This role is on-site.

Responsibilities

• Monitor daily job configurations in Compose to track execution status and resolve production errors.
• Validate data quality and accuracy across all pipelines.
• Modify existing tasks to incorporate new tables and transform logic.
• Execute core structure upgrades and implement security-related changes.
• Monitor system latencies and apply performance tuning techniques.

Required Skills

• 8-10 years of experience with SSIS.
• Advanced SQL proficiency, including complex joins, subqueries, and Common Table Expressions (CTEs).
• Strong debugging skills for troubleshooting pipeline failures.
• Experience with performance tuning techniques for large-scale datasets.
• Ability to work independently in a production support capacity.

Preferred Skills

• Data modeling experience, particularly within Healthcare subject areas.
• Knowledge of data warehousing automation tools.

Key Skills

Education

Any Graduate