2 days ago
Guadalajara, MexicoSenior
Responsibilities
- Architect and develop scalable Snowflake data models using dimensional modeling, star and snowflake schemas, OBT, and Data Vault patterns.
- Build, test, document, and maintain dbt models across staging, intermediate, and mart layers.
- 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 and transform ERP, MES, IoT, API, and flat-file data into Snowflake, AWS Glue, and Lambda-based workflows.
- Automate data workflows using Python scripting and orchestration tools.
- Implement data quality checks, lineage tracking, documentation standards, and data governance practices.
- Optimize data sources and calculations for Power BI and Tableau dashboards.
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 covering data modeling, performance tuning, query optimization, Snowpark, stored procedures, streams, tasks, data sharing, and cost management.
- Strong dbt proficiency with model development, Jinja, macros, packages, incremental models, snapshots, exposures, and CI/CD integration.
- Advanced SQL skills, including complex transformations, window functions, common table expressions, 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 across 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.
