Senior Snowflake Developer (Data Architect)

Proxify; Estado de México; Remote; MXN 1,531,000 - 2,552,000; Full time

Benefits offered by this job

Flexible withdrawal options

Consistent working hours

24 flex days off per year

Job summary

A global remote workforce platform seeks a Senior Snowflake Developer to design and implement scalable, secure data warehouse solutions. Ideal candidates will have 5+ years in data warehousing, significant experience with Snowflake, and proficiency in SQL/Python. The role involves optimizing SQL queries, managing data ingestion pipelines, and ensuring cost-efficient operations. They offer predictable working hours, flex days, and on-time monthly payments. This position allows for remote work with cutting-edge companies.

Qualifications

• 5+ years of experience in data warehousing with 3 years focused on Snowflake.
• High proficiency in SQL and Python for data processing.
• Expertise in dbt for transformation and modeling.
• Experience with at least one major cloud provider (AWS, Azure, or GCP) and their native data services.
• Deep understanding of Star/Snowflake schemas, Data Vault 2.0, and dimensional modeling.
• Experience with Git-based workflows, CI/CD for data pipelines, and infrastructure as code (Terraform).
• Intermediate-advanced English level.

Responsibilities

• Design and implement scalable data warehouse solutions using Snowflake.
• Optimize SQL queries and configurations for cost-efficiency.
• Build near real-time data ingestion pipelines using Snowpipe.
• Transition traditional SQL‑only logic into modern Snowpark (Python/Java) workflows to support complex data transformations and machine learning readiness.
• Implement fine‑grained access control (RBAC), data masking, and governance policies using Snowflake Horizon.
• Integrate Snowflake with modern data stack tools like dbt (Data Build Tool), Airflow, and Fivetran.

Skills

Data warehousing

SQL

Python

dbt

Cloud provider services (AWS, Azure, GCP)

Star/Snowflake schemas

Git-based workflows

Infrastructure as code (Terraform)

English (Intermediate-Advanced)

Git & CI/CD for data pipelines

Terraform (infrastructure as code)

English proficiency

Tools

Snowflake tooling

dbt tooling

Airflow

Fivetran

Snowpipe

Stream & Task

Job description

Talent has no borders. Proxify's mission is to connect top developers around the world with the opportunities they deserve. So, it doesn't matter where you are; we are here to help you fast-track your independent career in the right direction. 🙂

Since our launch, Proxify's developers have successfully worked with 1200+ happy clients to build their products and growth features. 5000+ talented developers trust Proxify and its network to fulfill their dreams and objectives.

Proxify is shaped by a global network of supportive, talented developers interested in remote full-time jobs. Our Glassdoor (4.5/5) and Trustpilot (4.8/5) ratings reflect the trust developers place in us and our commitment to our members' success.

The Role:

We are looking for a Senior Snowflake Developer to lead the architecture and optimization of a cloud data platform for one of our clients. You are a perfect candidate if you are growth-oriented, you love what you do, and you enjoy working on new ideas to develop exciting products.

What we’re looking for:

• 5+ years of hands‑on experience in data warehousing, with at least 3 years focused specifically on Snowflake.
• High proficiency in SQL and Python (specifically for Snowpark or data processing).
• Expert knowledge of dbt for transformation and modeling.
• Strong experience with at least one major cloud provider (AWS, Azure, or GCP) and their native data services (e.g., S3, Lambda, Azure Data Factory).
• Deep understanding of Star/Snowflake schemas, Data Vault 2.0, and dimensional modeling.
• Experience with Git‑based workflows, CI/CD for data pipelines, and infrastructure as code (Terraform).
• Intermediate‑advanced English level.

Responsibilities:

• Design and implement scalable, secure, and robust data warehouse solutions using the Snowflake Cloud Data Platform.
• Optimize complex SQL queries, clustering keys, and virtual warehouse configurations to minimize latency and maximize cost‑efficiency.
• Build automated, near real‑time data ingestion pipelines using Snowpipe, Stream & Task, and Dynamic Tables.
• Transition traditional SQL‑only logic into modern Snowpark (Python/Java) workflows to support complex data transformations and machine learning readiness.
• Implement fine‑grained access control (RBAC), data masking, and governance policies using Snowflake Horizon.
• Integrate Snowflake with modern data stack tools like dbt (Data Build Tool), Airflow, and Fivetran.

What we offer:

Get paid, not played

No more unreliable clients. Enjoy on‑time monthly payments with flexible withdrawal options.

Predictable project hours

Enjoy a harmonious work‑life balance with consistent 8‑hour working days with clients.

Flex days, so you can recharge

Enjoy up to 24 flex days off per year without losing pay, for full‑time positions found through Proxify.

Career‑accelerating positions at cutting‑edge companies

Discover exclusive long‑term remote positions at the world's most exciting companies.

Hand‑picked opportunities, just for you

Skip the typical recruitment roadblocks and biases with personally matched positions.

One seamless process, multiple opportunities

A one‑time contracting process for endless opportunities, with no extra assessments.

Compensation

Enjoy the same pay, every month with positions landed through Proxify.