Senior Data Engineer – Snowflake

This is a fully remote position, open to applicants in Mexico, +5 more countries.

📋 Description

• Develop extraction processes from SAP ASE (Sybase) and SQL Server using ODBC, leveraging Openflow as the connector pattern.

• Integrate REST APIs with authentication, token renewal, pagination, request limit control, and retries.

• Incorporate files and other sources into the data warehouse, preserving the original data and its extraction mark.

• Enable data reprocessing from the landing layer without needing to re-query the source systems.

• Construct the Bronze, Silver, and Gold layers with conformed dimensions, historical data, and business facts with certified metrics.

• Develop models and transformations with dbt, including declarative tests, incremental materializations, and generated documentation.

• Define approved master catalogs with the client to unify identifiers and names across systems.

• Collaborate with the AI engineer to design semantic models, verified queries, and a glossary of metrics for agent consumption.

• Ensure traceability of each figure to its source, table, and cut-off date, and expose the information through consumption views.

• Implement quality rules and quarantine mechanisms for records that do not meet defined criteria.

• Orchestrate the nightly processing window, including monitoring and execution logs.

• Reconcile the Gold layer against the client's current reports and document discrepancies and their causes.

• Manage credit consumption and configure resource monitoring mechanisms in Snowflake.

• Collaborate on evaluating the accuracy and repeatability of responses generated by AI agents.

• Implement RBAC, row access policies, and masking policies in accordance with the access matrix agreed upon with the client.

• Ensure that agents query and respond only to information authorized for each role.

• Document lineage, pipeline operations, and reprocessing procedures.

• Prepare for the technical and operational transfer to the client's team.

⛳️ Requirements

• At least five years of experience building production data warehouses and a minimum of two years working with Snowflake.

• Advanced knowledge of Snowflake: warehouses, RBAC, row access policies, masking, and resource monitors.

• Advanced experience in dimensional modeling: conformed dimensions, historical data, and star schemas.

• Advanced proficiency in dbt: declarative tests, incremental materializations, and generated documentation.

• Advanced SQL skills and experience in extraction from SAP ASE (Sybase) and SQL Server, including reverse engineering of undocumented schemas.

• Advanced experience ingesting from REST APIs: authentication, pagination, rate control, and retries.

• Advanced experience in orchestrating pipelines and data quality with quarantine measures.

• Intermediate to advanced experience integrating LLM models with data warehouses: semantic models, governed text-to-SQL, verified queries, and accuracy and repeatability assessment.

• Intermediate experience designing data layers for agents, ensuring traceability to the source and cut-off date, consumption views, and credit control.

• Experience working directly with business users to define rules, standardize catalogs, and validate figures.

• Native or professional-level Spanish and intermediate English, with an understanding of technical documentation.

• Residence in Mexico or LATAM and availability for full-time remote work.

• Desirable: experience with Snowflake Intelligence, Cortex Analyst, Cortex Agents, Cortex Search, or Snowflake CoCo.

• Desirable: implementation of RAG on unstructured documents integrated into the data warehouse.

• Desirable: experience with Openflow, Dynamic Tables, or Snowpark.

• Desirable: experience with niche ERPs on Sybase or SQL Server.

• Desirable: SnowPro Core or Advanced certification.

🏝️ Benefits

• Integration into global brands and disruptive startups.

• Remote work/Home office.

• Adjusted hours based on the assigned project/work cell.

• Work from Monday to Friday.

• Day off on your birthday.

• Major medical expense insurance (applicable in Mexico).

• Life insurance (applicable in Mexico).

• Access to courses and certifications.

• Virtual integration events and interest groups.

• English classes.

• Proudly certified as a Great Place to Work.