Senior Data Engineer

About the role

The company is expanding its data engineering capacity to support a growing product portfolio and increasing analytical demand from internal teams and enterprise customers. This senior position will join a newly formed data engineering team in Sri Lanka, building trustworthy and usable data pipelines and models.

Key responsibilities

• Design and build dimensional and analytical models in dbt on a cloud data warehouse (Snowflake), covering core domains and new business lines.
• Develop and maintain ingestion and orchestration pipelines using dbt Core, Snowflake SQL, Python, and Airflow, ensuring reliable scheduled execution.
• Profile source data from transactional systems and third‑party integrations to define grain, keys, and business meaning, documenting assumptions.
• Implement data quality tests, monitoring, and alerting to catch anomalies before they affect reports or customer‑facing outputs.
• Diagnose production data issues across ingestion, transformation, and source layers, documenting root causes for the team.

Required profile

• 5+ years of data engineering experience, including at least 3 years building analytical models in a cloud data warehouse.
• Strong analytical SQL skills, preferably with Snowflake.
• Hands‑on experience with dbt in production, including model layering, testing, documentation, and incremental strategies.
• Proficiency in Python for pipeline development and API/file integrations.
• Ability to investigate undocumented source systems and map data to business processes.

Required skills

• dbt Core
• Snowflake
• SQL (advanced)
• Python
• Airflow or equivalent orchestration tool
• Git version control and CI/CD workflows
• Familiarity with BI tools such as Tableau, Looker, or Power BI