Key Responsibilities

• Own end-to-end data pipelines including orchestration, monitoring, and failure recovery.
• Implement data quality checks, testing, and documentation standards.
• Optimize warehouse performance and cloud cost efficiency.
• Collaborate with analytics, product, and business teams to define data requirements.
• Model data using ERDs, cardinalities, and PK-FK relationships.
• Develop and optimize dimensional models (facts/dimensions), data marts, and CDC pipelines.
• Write advanced, performant SQL for transformation and analysis.

Candidate Profile

• Proficiency in data analysis & modeling (ERD, cardinalities, PK-FK).
• Hands-on experience with data warehousing (dimensions/facts, CDC, metadata).
• Advanced SQL expertise.
• Software engineering experience in Python, Java, or similar.

Nice to Have

• MS Dynamics 365 integration.
• Experience with modern cloud data warehouses (e.g., Synapse, Snowflake, BigQuery).
• Familiarity with orchestration tools (ADF, Airflow, or equivalent).
• Understanding of data quality, lineage, and governance concepts.