Associate Staff Engineer - Data Engineer
Nagarro Guadalajara, Sonora, Mexico
IT Services and IT Consulting · 10,001+ employees
Applying here? Try the free cover letter tool — paste this posting and your résumé, no account needed.
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
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
-
Data Engineer
Merchants Bank of Indiana Carmel, Indiana, United States
-
Data Engineer Lead
Blend360 Bogotá, Bogota D.C., Colombia
-
Senior Data Engineer
Mesh San Francisco, California, United States · $180K–$200K/yr
-
Senior Data Engineer (AI & Data Products)
Raydar Netherlands · £90K–£110K/yr
-
Senior Data Engineer
Evolve United States · $155K–$165K/yr
-
Senior Data Engineer
DNV Toronto, Ontario, Canada · CA$130K–CA$155K/yr