Role Description We are seeking a data-driven Ai Engineer to join our team at a high-growth advertising technology company. This role focuses on scaling our reporting infrastructure for advertising performance and billing reconciliation, ensuring that financial and operational data is accurate, automated, and actionable. - Develop robust data pipelines, ensuring data quality and reliability. - Enable efficient data consumption across the organization. - Collaborate closely with cross-functional teams including Product, Engineering, Analytics, and Business stakeholders to deliver high-impact data platforms. The ideal candidate is a proactive problem-solver with strong technical expertise, capable of working with large datasets, modern data architectures, and cloud-based environments. You thrive in fast-paced settings, navigate ambiguity with confidence, and are passionate about turning data into actionable value. Qualifications - Strong experience working with Databricks Lakehouse architecture (Must-Have). - Nice to have expertise in Databricks Mosaic AI and Unity Catalog for governing AI assets. - Hands-on experience building RAG (Retrieval-Augmented Generation) pipelines using Vector Search. - Advanced SQL development (Must-Have). - Experience integrating LLM APIs (OpenAI, Anthropic, etc.) into data workflows (Must-Have). - Hands-on experience using AI for: - Data enrichment. - Anomaly detection. - Automated classification. - Experience with LangChain, LlamaIndex, or similar frameworks. - Exposure to Model Context Protocol (MCP) or similar approaches to connect AI models with external tools and data sources. - Strong understanding of Tool Calling / Function Calling: enabling LLMs to interact with SQL databases and external APIs securely. - Experience in Prompt Engineering and Guardrailing: designing system prompts that maintain context and hierarchy. - Experience with GitHub workflows (Nice-to-Have / Medium). - Familiarity with CI/CD pipelines (Jenkins or similar). - Experience working with YAML/YML configuration files. Requirements - Architect AI Agents: Build and deploy agents that can perform NLP-based data generation, automated data enrichment, and complex data reasoning within Databricks. - Natural Language Interfaces: Develop "Chat with your Data" features, allowing stakeholders to query the data warehouse using natural language. - Integrate LLMs into data workflows for automation and intelligence. - Develop scalable data models to support analytics and AI use cases. - Implement AI-driven enhancements such as anomaly detection and data enrichment. - Collaborate with data, analytics, and engineering teams to improve data reliability. - Optimize performance and scalability of data and AI workflows. - Support automation through CI/CD practices. - Ensure data quality, traceability, and maintainability across pipelines. Benefits - Monetary compensation. - Year-end Bonus. - IMSS, AFORE, INFONAVIT. - Major Medical Expenses Insurance. - Life Insurance. - Funeral Expenses Coverage. - TDU Membership. - MediAccess. - Health Check-Up Subsidy. - Preferential rates for car insurance. - Vacations. - Official Mexican Holidays. - Life Happens Days. - Bereavement Leave. - Civil Marriage Leave. - English Classes. - Certifications. - Educational Agreements (Talisis, U-ERRE, UNID, TecMilenio, Tec de Monterrey, UDEM, SPIS). - Corporate Agreements & Discounts (Sorteos Tec, Envia Flores, TopGolf). - Taquitos Rewards. - Birthday Bonus. - Work-from-home Bonus. - Laptop Policy. Company Description Enroute is committed to providing equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.

• Propose and build: Design modern architectural solutions (focus on Data Lakehouse) and rapidly test new technologies. • Develop: Create efficient data processes and pipelines (ETL/ELT) using industry best practices. • Automate and Orchestrate: Implement automations in Cloud environments (GCP, AWS, or Azure), ensuring high performance, security, and data governance. • Operate with a Product Mindset: Ensure the data platform is scalable, flexible, and oriented to serve business areas with structured data and AI models. • Facilitate and Translate: Act as a bridge between technical and business teams, translating complex engineering and AI concepts for stakeholders in a clear and educational manner. • Collaborate: Support colleagues and teams in adopting industry best practices, serving as a technical reference.

Role Description We are looking for a Mid-to-Senior Data Engineer to architect, build, and operate cloud-native data pipelines on AWS. In this role, you will anchor the flow of data from diverse source systems—including relational databases, SaaS applications, and event streams—into a central Snowflake data platform modeled in dbt Cloud. You will be responsible for ensuring technical excellence across our data infrastructure by writing production-grade Python, utilizing modern AI coding assistants like GitHub Copilot and Claude, and managing infrastructure as code via Terraform. This role is critical to shaping and defending our core data architecture, optimizing platform performance, and delivering curated, analytics-ready datasets for downstream BI and reporting. As a key contributor on a fully remote team, your autonomy, ownership mindset, and clear written communication will directly impact our ability to scale data solutions and maintain full historical accuracy using advanced dimensional modeling techniques. Key Responsibilities - Design and own the architectural evolution of data pipelines and platform components, leading design reviews and defending technical decisions with evidence-based reasoning. - Build and maintain robust ingestion pipelines leveraging AWS DMS, Amazon AppFlow, and Amazon EventBridge to land data seamlessly into AWS S3 and Snowflake. - Optimize and model analytics datasets within dbt Cloud, applying strict dimensional modeling (Kimball techniques) and implementing SCD Type 2 logic. - Lead performance tuning and cost optimization efforts across the Snowflake ecosystem, proactively implementing monitoring, alerting, and root-cause analysis. - Collaborate with cross-functional teams to prepare curated datasets for Power BI, while mentoring peers through rigorous code reviews and engineering enablement. Qualifications - 5+ years of professional experience in Data Engineering roles. - Proficiency with Python (including AWS Lambda), advanced SQL, dbt Cloud, Snowflake, Terraform (IaC), and Docker. - Deep hands-on experience with core AWS data services (S3, Glue, Athena, EventBridge, AppFlow, DMS). - Solid grasp of dimensional modeling (star schemas, fact/dimension design) and practical implementation of SCD Type 2. - High autonomy, ownership mindset, discipline to raise risks early, and comfort utilizing AI-assisted development tools (GitHub Copilot, Claude). - Advanced English (written and spoken) is mandatory for seamless remote collaboration. Nice to Have - AWS Certified Data Engineer – Associate (DEA-C01) or equivalent certification. - Experience with change-data-capture (CDC) and near-real-time ingestion patterns. - Exposure to workflow orchestration tools such as Apache Airflow, Dagster, or Prefect. - Familiarity with data observability frameworks (Great Expectations, Monte Carlo) and open table formats like Apache Iceberg. Benefits - 100% Remote - Holidays off - Paid Time Off - Health insurance assistance - Competitive USD compensation - Growth opportunities

• Design, develop, maintain, and optimize data pipelines that support data integration, transformation, and analytics initiatives • Develop and maintain data models, data warehouses, and data structures that support reporting, business intelligence, and enterprise analytics • Extract, transform, validate, and load data from multiple source systems while ensuring data quality, integrity, consistency, and compliance with business requirements • Support the design, implementation, maintenance, and optimization of the organization’s data architecture and technology platforms • Develop, maintain, and optimize SQL queries, database objects, and data transformation processes to improve performance and scalability • Collaborate with Business Intelligence, Analytics, Technology, and business stakeholders to gather requirements and deliver data solutions that support business objectives • Support data quality initiatives by identifying, troubleshooting, and resolving data inconsistencies, duplicate records, and integration issues • Prepare and maintain technical documentation, data dictionaries, process documentation, and knowledge base resources to support ongoing operations and knowledge transfer • Communicate technical concepts, project updates, and data insights effectively to technical and non-technical stakeholders • Research and evaluate emerging technologies, tools, and best practices to improve data engineering capabilities and operational efficiency • Adhere to company policies and procedures • Meet or exceed performance targets for related KPIs • Continuously improve knowledge of products, services, and processes by participating in training programs and continuous learning modules • Collaborate with other departments as needed • Maintain a positive, empathetic, and professional attitude toward customers and colleagues at all times