Lead Data Lakehouse Architect & End-to-End Pipelines

EPAM Systems, Inc.; México; A distancia; MXN 900.000 - 1.500.000; Jornada completa

Descripción de la vacante

EPAM Systems, Inc. is seeking a Chief Data Engineer to own end-to-end data modeling and pipeline delivery for a multi-phase enterprise data lake re-architecture on a modern AWS stack.

You will partner closely with stakeholders across time zones and drive outcomes with high autonomy. You will lead dimensional modeling, build lakehouse ETL/ELT workflows, and design dbt transformations while ensuring quality through SQL checks and tests.

Formación

• 7+ years of data engineering experience with modern data warehousing and lakehouse patterns.
• 7+ years of hands-on SQL experience for analytics engineering and data validation.
• Experience with ETL/ELT solutions across batch and incremental processing.
• Experience with Databricks in production environments.
• Experience with dbt for transformations, testing, and documentation.
• Senior stakeholder management experience working with non-technical partners.
• End-to-end delivery ownership from requirements through deployment and support.
• Strong dimensional modeling skills using star schema and Kimball methodology.
• Strong documentation skills using collaboration tools (e.g., Confluence).
• Excellent communication skills for clear written updates and executive-ready narratives.

Responsabilidades

• Lead dimensional data modeling using star schemas, fact/dimension design, and aggregate-aware structures.
• Own end-to-end pipeline delivery from requirements discovery through deployment and hypercare.
• Design ETL/ELT workflows that evolve traditional warehousing practices into a modern lakehouse approach.
• Build and maintain transformations in dbt with reliable tests, documentation, and lineage practices.
• Develop data pipelines in Databricks with performance, scalability, and maintainability in mind.
• Partner with US-based stakeholders to elicit requirements, clarify definitions, and anticipate future needs.
• Coordinate delivery across an engineering team with time-zone overlap and ensure clear handoffs.
• Validate data quality through SQL-based checks, unit tests, and UAT support.
• Document models, pipelines, and decisions to enable alignment and long-term maintainability.
• Provide basic dashboarding support to validate outputs and confirm business usability.

Conocimientos

Data engineering

SQL

End-to-end delivery

Dimensional modeling

Stakeholder management

Documentation

Communication

Data lakehouse

Herramientas

Databricks

dbt

Tableau

Power BI

Informatica

Cognos

Business Objects

Oracle

Confluence

Descripción del empleo

EPAM Systems, Inc. is seeking a Chief Data Engineer to own end-to-end data modeling and pipeline delivery for a multi-phase enterprise data lake re-architecture on a modern AWS stack.

You will partner closely with stakeholders across time zones and drive outcomes with high autonomy. You will lead dimensional modeling, build lakehouse ETL/ELT workflows, and design dbt transformations while ensuring quality through SQL checks and tests.