Data Architect (Snowflake Solutions Architect)

Source Meridian; Colombia; On-site; COP 120,000,000 - 180,000,000; Full time

Benefits offered by this job

Permanent contract

Growth & learning

Health benefits

Competitive salary

Job summary

Source Meridian is seeking a Data Architect (Snowflake Solutions Architect) to join our agile team, shaping a modern data platform for healthcare analytics.

You will design end-to-end Snowflake solutions, set standards, mentor teammates, and collaborate with data engineers, data scientists, and product stakeholders to enable scalable, secure, and high-performing data workflows.

We offer a permanent contract, strong learning opportunities, and a benefits package focused on health and well-being.

Qualifications

• 5+ years of experience in data architecture and data engineering, with hands-on Snowflake experience.
• Deep expertise in Snowflake features (Warehouses, Streams/Tasks, Time Travel, RBAC, Clustering, Stages).
• Strong SQL skills and familiarity with Python.
• Experience with Azure cloud platform and modern ELT tooling.
• Knowledge of data modeling (star, vault, wide tables) and scalable architecture patterns.

Responsibilities

• Architect end-to-end data solutions leveraging Snowflake, including data modeling, ingestion, transformation, security, and performance optimization.
• Define the data platform roadmap, standards, and best practices as part of a lean, high-ownership team.
• Partner with data engineers, analytics engineers, data scientists and business groups to convert requirements into scalable Snowflake solutions.
• Lead design sessions, perform technical reviews, and guide decisions related to warehousing, pipelines, orchestration, and governance.
• Evaluate and integrate tools (dbt, Airflow, Fivetran, Matillion, Azure/AWS services).
• Implement strong data security, privacy, and access management controls within Snowflake.
• Troubleshoot and optimize warehouse performance, cost efficiency, and query execution.
• Mentor teammates and contribute to engineering excellence.

Skills

SQL

Python

Data modeling

CI/CD

English proficiency

Tools

dbt

Airflow

Fivetran

Matillion

Azure

AWS

Job description

We’re looking for a Data Architect (Snowflake Solutions Architect) to join Source Meridian.

About Source Meridian

Source Meridian is a development software company that works to solve the industry’s most challenging problems in healthcare practices. We are laser focused on specific technologies in the healthcare and life science industries: Healthcare technology, artificial intelligence, and healthcare interoperability.

About The Role

We’re looking for a Snowflake Solution Architect to join a small, agile, and highly technical team responsible for defining, building, and owning our client next-generation data platform. This role is a mix of hands‑on architecture, technical leadership, and strategic direction—perfect for someone who wants to shape the foundation, standards, and roadmap of a modern data ecosystem.

You will lead the design and implementation of Snowflake-based solutions, influence platform direction, and work closely with stakeholders across engineering, analytics, data science and product to ensure our client data platform enables scale, reliability, and innovation.

What You’ll Do

• Architect end-to-end data solutions leveraging Snowflake, including data modeling, ingestion, transformation, security, and performance optimization.
• Define the data platform roadmap, standards, and best practices as part of a lean, high-ownership team.
• Partner with data engineers, analytics engineers, data scientists and business groups to convert requirements into scalable Snowflake solutions.
• Lead design sessions, perform technical reviews, and guide decisions related to warehousing, pipelines, orchestration, and governance.
• Evaluate and integrate relevant tools (e.g., dbt, Airflow, Fivetran, Matillion, Azure/AWS services).
• Implement strong data security, privacy, and access management controls within Snowflake.
• Troubleshoot and optimize warehouse performance, cost efficiency, and query execution.
• Mentor teammates and contribute to a culture of engineering excellence and continuous improvement.

Required Qualifications

• 5+ years of experience in data architecture and data engineering, with at least 3 years hands‑on in Snowflake.
• Deep expertise in Snowflake features (Warehouses, Streams/Tasks, Time Travel, RBAC, Clustering, Stages etc.).
• Strong SQL skills and familiarity with Python.
• Experience with Azure cloud platform and modern ELT tooling.
• Strong understanding of data modeling (star, vault, wide tables), CI/CD for data, and scalable architecture patterns.
• C1 - C2 English level: able to lead technical discussions, write clear documentation, and work directly with US‑based stakeholders.

Nice to Have

• Experience with healthcare data and standards like HL7 and FHIR.
• Experience with dbt for transformations.
• Background in building event-driven or real‑time data pipelines.
• Prior experience designing greenfield data platforms.

Soft Skills

• Comfortable working in a small team with high ownership and the ability to set direction.
• Excellent communication skills and the ability to collaborate across technical and non‑technical groups.

What We Offer

• Permanent contract
• Learning and continuous growth environment
• Benefits package focused on health and well‑being
• Competitive salary based on experience

Apply only if you reside in Colombia or Ecuador.

At Source Meridian, you’ll be part of a high-impact tech‑health company, building products that truly make a difference.

We’d love to meet you.