Associate Staff Engineer - Data Engineer

SmartRecruiters, Inc.; Región Centro; Híbrido; MXN 700.000 - 1.100.000; Jornada completa

Descripción de la vacante

SmartRecruiters, Inc. is seeking a data engineer to design and implement scalable Snowflake data models and dbt pipelines for analytics across the organization.

You will own the data warehouse layer powering dashboards and reports, collaborating with cross-functional teams on data ingestion from ERP, MES, IoT, and APIs. Qualifications include 3+ years in data engineering with Snowflake and dbt, strong SQL and Python, and experience with BI tools such as Power BI or Tableau.

Formación

• 3+ years of experience in data engineering, analytics engineering, or related role with Snowflake and dbt in production.
• Proficient in designing scalable data models and ETL/ELT pipelines.
• Strong SQL, Python, and data governance/data quality practices.

Responsabilidades

• Design and build scalable data models in Snowflake using dimensional modeling.
• Develop and maintain dbt projects end-to-end with best practices and tests.
• Optimize Snowflake compute/storage costs including warehousing sizing and cost controls.
• Design and build robust ELT/ETL data pipelines from ERP, MES, IoT, APIs, and flat files into Snowflake/AWS Glue/Lambda.
• Implement data quality checks, lineage tracking, and governance standards.

Conocimientos

Snowflake

DBT

SQL

Python

Data modeling

ETL pipelines

Cloud platforms

BI tools

Herramientas

dbt

Snowflake

Power BI

Tableau

AWS/Azure/GCP

Descripción del empleo

• Full-time
• Service Region: UCC

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