Associate Staff Engineer - Data Engineer (Snowflake/dbt)

Location: Hybrid in Guadalajara, Mexico

Company

hirify.global is a digital product engineering company delivering products, services, and digital experiences at scale across 26 countries.

What you will do

• Design and develop scalable Snowflake data models using dimensional modeling, star and snowflake schemas, OBT, and Data Vault patterns.
• Build, test, document, and maintain dbt projects across staging, intermediate, and mart layers.
• Optimize Snowflake compute and storage costs through warehouse sizing, query profiling, clustering, materialization strategies, and resource monitors.
• Develop ELT and ETL pipelines integrating ERP, MES, IoT, API, and flat-file data into Snowflake, AWS Glue, and Lambda.
• Automate workflows with orchestration tools and Python, while implementing data quality checks, lineage tracking, and governance standards.

Requirements

• 3+ years of experience in data engineering, analytics engineering, or a related role.
• Production experience with Snowflake and dbt, including data modeling, performance tuning, Snowpark, stored procedures, streams, tasks, data sharing, macros, packages, incremental models, snapshots, exposures, and CI/CD.
• Expert 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.
• Cloud experience with Azure, AWS, or GCP, including storage, compute, networking, and infrastructure-as-code basics.

Culture & Benefits

• Hybrid work model in Guadalajara.
• Dynamic, non-hierarchical work culture.
• Opportunity to work within a global organization of more than 15,000 experts across 26 countries.