Associate Staff Engineer - Data Engineer

Nagarro1; Región Centro; On-site; MXN 600,000 - 900,000; Full time

Job summary

Nagarro1 in Mexico is seeking a data engineer to design and build scalable Snowflake data models and end-to-end pipelines. You will own the data warehouse layer powering analytics and reporting, and enforce best practices in dbt development, testing, and CI/CD.

The ideal candidate has 3+ years in data engineering with expert Snowflake skills, strong SQL, Python scripting, and experience with BI tools such as Power BI or Tableau. Cloud platform familiarity is required.

Qualifications

• 3+ years of experience in data engineering, analytics engineering, or related role.
• Hands-on Snowflake and dbt in a production environment.
• Advanced SQL skills for complex transformations.
• Proficiency in Python for data pipelines.
• Experience with BI tools (Power BI, Tableau).
• Cloud platform experience (Azure, AWS, or GCP).

Responsibilities

• Design & build scalable Snowflake data models using star/snowflake patterns, OBT and Data Vault.
• Develop, test, and document dbt models across staging, intermediate, and mart layers.
• Monitor and optimize Snowflake costs including warehouse sizing and auto-suspend tuning.
• Build robust ELT/ETL pipelines from ERP, MES, IoT, APIs, and flat files into Snowflake/AWS Glue/Lambda.
• Implement data quality checks, lineage, and governance.

Skills

Snowflake

dbt

SQL

Python

Power BI

Tableau

Tools

AWS Glue

Lambda

Job description

Role and Responsibility:

• Design & Build Data Models: Architect and develop scalable, performant data models in Snowflake using dimensional modeling (star/snowflake schemas), OBT, and Data Vault patterns. You''''ll own the data warehouse layer that powers analytics and reporting across the organization.


• Develop & Maintain dbt Projects: Build, test, and document dbt models end-to-end - staging, intermediate, and mart layers. Enforce best practices including version control, CI/CD, data contracts, and comprehensive testing (schema, data, and freshness tests).


• Snowflake Cost Optimization: Monitor and optimize Snowflake compute and storage costs. This includes warehouse sizing and auto-suspend tuning, query profiling, clustering key strategies, materialization choices, and implementing resource monitors to control spend.


• Data Pipeline Development: Design and build robust ELT/ETL data pipelines to ingest, transform, and deliver data from diverse sources (ERP, MES, IoT, APIs, flat files) into Snowflake/ AWS Glue/ Lambda. Automate workflows using orchestration tools and Python scripting.


• Data Quality & Governance: Implement data quality checks, lineage tracking, and documentation standards. Champion data governance practices to ensure trusted, reliable data across the organization.

Expectation from the Candidate:

• Experience: 3+ years of experience in data engineering, analytics engineering, or a related role, with hands-on Snowflake and dbt experience in a production environment.


• Technical Prowess: Expert-level Snowflake skills: data modeling, performance tuning, query optimization, Snowpark, stored procedures, streams/tasks, data sharing, and cost management.


• Strong dbt proficiency: model development, Jinja/macros, packages, incremental models, snapshots, exposures, and CI/CD integration.


• Advanced SQL skills for complex transformations, window functions, CTEs, and analytical queries.


• Proficiency in Python for data pipeline development, automation, scripting, and API integrations.


• Experience with dashboard/BI tools (Power BI, Tableau) including data source optimization and DAX/LOD calculations.


• Cloud platform experience (Azure, AWS, or GCP) including storage, compute, networking, and infrastructure-as-code basics.

Must have skills: Cloud development (Strong), DBT, SQL (Expert), Snowflake