Data/Snowflake Engineer at WorkNovas Technology Worknovas, LLC | Torre
Data/Snowflake Engineer
trending_up Invest in Torre
WorkNovas Technology Worknovas, LLC

Data/Snowflake Engineer

WorkNovas Technology Worknovas, LLC
Emma
Emma
Emma highlights
This highlight was written by Emma’s AI. Ask Emma to edit it.
Freelance
Recurrent
Provide your expected compensation while applying
location_on
Remote (for Canada residents)
Shared by
Laura Motta
 about 2 months ago

Responsibilities

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 ResponsibilitiesDesign 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.Required SkillsStrong 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.Preferred Domain ExperienceExperience working with healthcare or orthodontic systems such as Cloud 9, OrthoFi, PMS, CRM, or similar platforms is highly desirable.
This job post is closed.