Associate Staff Engineer - Data Engineer

Nagarro; Región Centro; Hybrid; MXN 600,000 - 900,000; Full time

Job summary

Nagarro is seeking a data engineer to design and build scalable Snowflake data models, dbt pipelines, and robust ELT/ETL processes. The role emphasizes governance, data quality, and cost optimization across cloud platforms (Azure/AWS/GCP). You will collaborate across ERP, MES, IoT, and API sources to enable analytics and reporting.

The ideal candidate has 3+ years of experience with Snowflake, dbt, SQL, and Python, and proficiency in Power BI or Tableau for dashboards.

Qualifications

• 3+ years in data engineering or analytics engineering with Snowflake and dbt.
• Expert-level Snowflake data modeling, performance tuning, and cost management.
• Strong SQL, Python, and BI/dashboard experience with Power BI or Tableau.

Responsibilities

• Design & Build Data Models in Snowflake using star/snowflake schemas.
• Develop & Maintain dbt Projects end-to-end with tests and CI/CD.
• Snowflake Cost Optimization including warehouse sizing and auto-suspend.
• Data Pipeline Development to ingest data from ERP/MES/IoT/APIs into Snowflake/AWS.
• Data Quality & Governance including lineage and documentation.

Skills

Snowflake

dbt

SQL

Python

Power BI

Tableau

Cloud platforms

Tools

dbt

Power BI

Tableau

Azure

AWS

GCP

Job description

• Full-time
• Service Region: UCC

Company Description

We are a Digital Product Engineering company that is scaling in a big way! We build products, services, and experiences that inspire, excite, and delight. We work at scale — across all devices and digital mediums, and our people exist everywhere in the world (15000+ experts across 26 countries, to be exact). Our work culture is dynamic and non-hierarchical. We are looking for great new colleagues. That is where you come in!

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.

Qualifications

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