Data/Snowflake Architect
About the role
&K Global Talent Solutions Inc is an International recruiting agency that has been providing technical resources in Canada region since 1993. This position is with one of our clients in Canada, who is actively hiring candidates to expand their teams.
Role: Data/Snowflake Architect Employment type: Contract Technology: SQLMesh Location: Remote (Canada)
Job Description- Role Overview: We are looking for a Senior Data Architect 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. Required Skills 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. Preferred Domain Experience Experience working with healthcare or orthodontic systems such as Cloud 9, OrthoFi, PMS, CRM, or similar platforms is highly desirable
Note: Applicants for employment in Canada should possess work authorization which does not require sponsorship by the employer for a visa
About K&K Global Talent Solutions INC.
K&K Global Talents Solutions Inc: A New Era in the US Recruitment Industry With their partnership with a highly reputable German recruitment firm boasting over 30 years of experience, K&K Global Talents Solutions Inc. is an emerging player in the US recruitment industry. This collaboration allows them to merge the advantages of a new entrant with the vast knowledge and expertise of a well-established player. Clients and candidates are guaranteed to benefit from innovative recruitment approaches, cutting-edge strategies, and a wealth of knowledge and trust. K&K Global Talents represents the future of recruitment in both IT and Nursing industry, with a modern outlook and flexibility, combined with the methodologies that have sustained success for over 30 years, thanks to their esteemed German partner.
Similar Jobs
Data/Snowflake Architect
About the role
&K Global Talent Solutions Inc is an International recruiting agency that has been providing technical resources in Canada region since 1993. This position is with one of our clients in Canada, who is actively hiring candidates to expand their teams.
Role: Data/Snowflake Architect Employment type: Contract Technology: SQLMesh Location: Remote (Canada)
Job Description- Role Overview: We are looking for a Senior Data Architect 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. Required Skills 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. Preferred Domain Experience Experience working with healthcare or orthodontic systems such as Cloud 9, OrthoFi, PMS, CRM, or similar platforms is highly desirable
Note: Applicants for employment in Canada should possess work authorization which does not require sponsorship by the employer for a visa
About K&K Global Talent Solutions INC.
K&K Global Talents Solutions Inc: A New Era in the US Recruitment Industry With their partnership with a highly reputable German recruitment firm boasting over 30 years of experience, K&K Global Talents Solutions Inc. is an emerging player in the US recruitment industry. This collaboration allows them to merge the advantages of a new entrant with the vast knowledge and expertise of a well-established player. Clients and candidates are guaranteed to benefit from innovative recruitment approaches, cutting-edge strategies, and a wealth of knowledge and trust. K&K Global Talents represents the future of recruitment in both IT and Nursing industry, with a modern outlook and flexibility, combined with the methodologies that have sustained success for over 30 years, thanks to their esteemed German partner.