Nagarro

Senior Engineer - Data Engineer

Nagarro Guadalajara, Sonora, Mexico

IT Services and IT Consulting · 10,001+ employees

8 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

Architect and develop scalable data models in Snowflake while maintaining robust ELT/ETL pipelines for diverse data sources. Implement data quality checks, governance standards, and cost optimization strategies to ensure reliable and performant analytics.

What they look for

Snowflake Dbt SQL Python Data Modeling ELT/ETL Cloud Development AWS Glue Data Governance Performance Tuning CI/CD Data Warehousing Power BI Tableau Jinja API Integration

Requirements

Requires 3+ years of experience in data engineering with expert-level proficiency in Snowflake, dbt, and SQL. Candidates must possess strong Python scripting skills and experience with cloud platforms and BI tools.

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