28 days ago
Guadalajara, MexicoStaff+
Responsibilities
- Design and build scalable Snowflake data models using dimensional modeling, star and snowflake schemas, OBT, and Data Vault patterns.
- Develop, test, document, and maintain dbt staging, intermediate, and mart models with version control, CI/CD, data contracts, and freshness and data-quality testing.
- Monitor and optimize Snowflake compute and storage costs through warehouse sizing, auto-suspend tuning, query profiling, clustering keys, materialization choices, and resource monitors.
- Design and build ELT/ETL pipelines that ingest, transform, and deliver data from ERP, MES, IoT, APIs, and flat files into Snowflake, AWS Glue, and Lambda.
- Automate data workflows using orchestration tools and Python scripting.
- Implement data-quality checks, lineage tracking, documentation standards, and data-governance practices.
- Support trusted analytics and reporting through optimized data sources and BI calculations.
Requirements
- At least 3 years of experience in data engineering, analytics engineering, or a related role.
- Hands-on production experience with Snowflake and dbt.
- Expert Snowflake skills including data modeling, performance tuning, query optimization, Snowpark, stored procedures, streams and tasks, data sharing, and cost management.
- Strong dbt proficiency with Jinja, macros, packages, incremental models, snapshots, exposures, and CI/CD integration.
- Advanced SQL skills covering complex transformations, window functions, CTEs, and analytical queries.
- Proficiency in Python for pipeline development, automation, scripting, and API integrations.
- Experience with Power BI or Tableau, including data-source optimization and DAX or LOD calculations.
- Experience with Azure, AWS, or GCP, including storage, compute, networking, and infrastructure-as-code basics.
Tech Stack
Categories
Data Engineering
About Nagarro
Nagarro provides digital engineering and IT consulting services to enterprises, delivering custom software development, cloud modernization, data and analytics, IoT, and digital commerce solutions. Its business model centers on project-based and managed services across the full product lifecycle, from strategy and design to build and operations. Nagarro is a public company headquartered in Munich and listed on the Frankfurt Stock Exchange, with global delivery across multiple regions.