ES
Data Architect/ Snowflake Architect
Epsilon Solutions LTD
🌏 Worldwide
Remote
Senior
2 months ago
- Snowflake
- Azure Data Factory
- SQL
- Terraform
- Azure DevOps
- GitHub Actions
- Datadog
- Azure
- CRM
- ETL
- ELT
- IaC
- CI/CD
- HIPAA
- Data Modeling
2 months ago
Duration: 12 Months Contract
Location: Canada (100% remote)
Key Technologies: Data/Snowflake Engineer Snowflake | Azure Data Factory | SQL | SQLMesh | Terraform | Azure DevOps | GitHub Actions | Atlan | Datadog
Role Overview: We are looking for a Senior Data Engineer with strong experience in Snowflake and Azure to build and maintain scalable data pipelines for an orthodontics/healthcare client.
The role involves integrating data from systems such as Cloud 9, OrthoFi, CRM, and other business applications into Snowflake using Azure Data Factory.
Key Responsibilities:
- Design and develop scalable ETL/ELT pipelines using Azure Data Factory.
- Build and optimize Snowflake data models, SQL transformations, and analytical datasets.
- Integrate and standardize data from multiple healthcare and business source systems.
- Develop complex KPIs and business metrics across patient, practice, financial, and marketing data.
- Develop and maintain transformation models using SQLMesh.
- Implement data quality, validation, reconciliation, and monitoring processes.
- Support data governance, metadata, and lineage using Atlan.
- Monitor pipelines and data workloads using Datadog.
- Use Terraform/IaC for infrastructure provisioning and management.
- Implement CI/CD pipelines using Azure DevOps and/or GitHub Actions.
- Follow security and compliance best practices when working with healthcare data, including PHI/PII and HIPAA requirements.
- Troubleshoot production issues and perform root cause analysis.
- Strong hands-on experience with Snowflake and advanced SQL.
- Strong experience with Azure Data Factory and ETL/ELT pipeline development.
- Experience in data modeling and data warehousing.
- Experience building complex KPIs and analytical metrics.
- Experience integrating multiple source systems and handling incremental/CDC data.
- Familiarity with Terraform / Infrastructure as Code.
- Experience with Azure DevOps or GitHub Actions and CI/CD.
- Experience with SQLMesh is preferred.
- Familiarity with Atlan and Datadog is preferred.
- Healthcare/orthodontics domain experience and knowledge of HIPAA/PHI is a plus.
- Experience working with healthcare or orthodontic systems such as Cloud 9, OrthoFi, PMS, CRM, or similar platforms is highly desirable.
Data Architect/ Snowflake Architect · Epsilon Solutions LTD