Senior Data Engineer
About the role
The Senior Data Engineer will join a growing Sri Lanka-based data engineering team, supporting the company's expanding product portfolio and analytical needs. This role is responsible for designing and building dimensional and analytical models in dbt, developing and maintaining data pipelines using dbt Core, Snowflake SQL, and Python, and ensuring data quality and reliability. The engineer will profile source data, implement monitoring and alerting, diagnose production issues, and collaborate with analysts and stakeholders to clarify requirements. The ideal candidate is comfortable working with undocumented data sources and has strong technical and communication skills. PetDesk is a leader in veterinary client engagement tools and offers a standardized, fair recruitment process.
Must have
- 5+ years in data engineering, including 3+ years building analytical models in a cloud data warehouse
- Advanced SQL: writing, debugging, and optimizing complex analytical queries over large datasets; Snowflake preferred
- Production dbt experience: model layering, testing, documentation, incremental strategies, in a version-controlled project
- Proficient in Python for pipeline development, API and file-based integrations, and orchestration with Airflow or equivalent
- Demonstrated ability to investigate undocumented source systems and map data to real business processes, with judgment about what to model and what to flag
- Familiarity with dimensional modeling and the trade-offs between normalized, wide, and aggregate structures
- Git-based development, pull request review, and CI/CD pipelines
- Enough exposure to BI tools (Tableau, Looker, Power BI, or similar) to model data that serves reporting well
- Clear written and spoken English and strong async habits; thorough PR descriptions, written context for decisions
- Conscientious about data accuracy; raises questions when the data doesn't look right
Technologies
- Airflow
- CI/CD
- Data Engineering
- Data Warehousing
- dbt
- Dimensional Modeling
- Git
- Looker
- Power BI
- Python
- Snowflake
- SQL
- Tableau
Highlights
The hiring process averages two weeks and follows a standardized interview method. External recruiters are not considered. AI tools may be used to support the recruitment process, but final decisions are made by humans. For questions about data processing, candidates can contact the company.
Also posted as
Jobs across Sri Lanka, watched for you.Colombo, Sri Lanka