[Hiring] Data Engineer @In All Media

Role Description

This role is embedded within a centralized Human Resources Data Mart (HRDM) engineering team, specifically supporting the Analytics product area. The primary objective is to maintain a secure, high-quality HR data warehouse that powers workforce analytics across international enterprise Centers of Excellence (COEs) and executive leadership.

As a Senior Data Engineer, you will build data pipelines and cloud infrastructure using dbt, AWS, Snowflake, and BigQuery, bridging traditional data architecture with modern AI capabilities. You will construct a dbt-based semantic layer and establish Model Context Protocol (MCP) and Snowflake Cortex workflows, enabling business leaders to query certified workforce data via natural-language AI agents.

Qualifications

• 5+ years of dedicated, hands-on data engineering experience.
• Deep expertise in Snowflake (data modeling, datamarts, warehouse design), Google BigQuery (querying and optimization), and dbt (data transformations).
• Strong object-oriented Python scripting capabilities and hands-on experience with REST API integrations and real-time data ingestion.
• Proficiency in Apache Airflow for pipeline orchestration and advanced, highly optimized SQL writing skills.
• Demonstrated experience in the secure handling of large-scale, sensitive data (PII) and writing comprehensive technical documentation.
• Experience working in Agile teams and remote, distributed environments.
• Advanced/Fluent English communication skills for daily interaction.

Requirements

• Develop, optimize, and maintain secure data pipelines using dbt, PySpark, Python, and Apache Airflow to ingest HR data sources from REST APIs, real-time streams (e.g., Google Sheets, web APIs), and external platforms.
• Provision, configure, and maintain scalable infrastructure for extraction, transformation, and loading processes utilizing Terraform, AWS Glue, AWS EMR, and AWS S3.
• Design and maintain optimized data models, data marts, and warehouse structures across Snowflake and Google BigQuery.
• Build semantic views and ontology layers (mapping CORE → SEMANTIC → METRICS) on top of dbt models to provide business-friendly entity abstractions for BI tools and LLM agents.
• Configure and deploy generative AI query agents using Snowflake Cortex (Cortex Analyst, Cortex Search) and maintain MCP (Model Context Protocol) connections between Snowflake and internal AI tools for secure, natural-language data querying.
• Monitor data pipelines to enforce 99.5% uptime, build automated tests within a Data Quality Framework, ensure secure handling of sensitive data (PII), and produce comprehensive technical documentation.

Benefits

• Remote work opportunity from LATAM.
• Full-time vendor contract.
• Collaboration with teams aligned to US Eastern Standard Time (EST).
• Flexibility to overlap a minimum of 4 core working hours with US time zones.

Nice-to-Have Skills

• Experience in semantic modeling design to provide business-object abstractions over dbt and warehouse models.
• Hands-on experience with Snowflake Cortex (Cortex Analyst, Cortex Search) or equivalent LLM query frameworks.
• Exposure to MCP (Model Context Protocol) or similar tool-calling and context-exposure frameworks.
• Familiarity with prompt and context engineering to ground AI agents in certified enterprise data sources.

Language

All interviews, documentation, and daily communication will be in English.