Nagarro

Associate Staff Engineer - Data Engineer

Nagarro Guadalajara, Sonora, Mexico

IT Services and IT Consulting · 10,001+ employees

3 h ago
data-engineer Mid (2-5 yrs) Full-time Mexico
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

Design and build scalable data models and robust ELT/ETL pipelines to support organizational analytics. Maintain dbt projects and implement data quality, governance, and cost optimization strategies for Snowflake.

What they look for

Snowflake Dbt SQL Python Data Modeling Data Warehousing ELT ETL AWS Glue Lambda Data Governance CI/CD Power BI Tableau Cloud Computing

Requirements

Requires 3+ years of experience in data engineering with expert-level skills in Snowflake, dbt, and SQL. Proficiency in Python, cloud platforms, and BI tools is essential for this role.

Full description

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

  • Service Region: UCC

Similar roles