Back to jobs
Job Description
Requirements
Must have:
- Proven experience in data architecture and enterprise data pipeline design.
- Advanced SQL proficiency.
- Hands-on experience working with Snowflake as a core data platform.
- Practical experience using dbt for data transformations and modeling.
- Experience with Airflow for pipeline orchestration.
- General knowledge of AWS, particularly services such as AWS Glue and orchestration environments.
- Experience designing pipelines with error handling, monitoring, and notification mechanisms.
- Solid understanding of Data Fabric / Data Mesh principles, including domain-based data ownership and data sharing.
- Experience with data quality practices, focusing on integrity, completeness, and traceability.
- Experience with CI/CD tools, preferably GitHub Actions.
- Ability to design scalable, loosely coupled data solutions aligned with best practices.
- Basic Python knowledge for configuration and orchestration purposes.
Nice to Have
- Experience with MicroStrategy and enterprise BI environments.
- Experience designing and supporting semantic data models.
- Familiarity with data governance and lineage tools such as Atlan.
- Experience with Infrastructure as Code, preferably Terraform.
- Experience working with data quality frameworks (e.g., dbt Elementary, Great Expectations).
- Strong skills in technical documentation and requirements gathering.
Responsibilities
- Lead end-to-end technical design and architecture of enterprise data pipelines, ensuring robust, scalable, and repeatable solutions.
- Design and implement integrations from multiple source systems into Snowflake, ensuring effective decoupling from SaaS vendors.
- Design and define data transformations primarily using SQL with dbt, focusing on data quality, traceability, and efficient downstream consumption.
- Define and oversee data pipelines with proper monitoring, error handling, alerting, and data integrity/completeness validations.
- Actively participate in the technical execution of solutions, maintaining a hands-on approach at the architecture and technical review level.
- Design solutions aligned with a Data Mesh model built on a Data Fabric architecture, including data sharing mechanisms across domains.
- Contribute to continuous improvement initiatives related to data quality, governance, and lineage, aiming for cost-efficient and scalable solutions.
- Collaborate closely with technical and business stakeholders for requirements gathering, solution design, and deliverables review.
- Ensure data models are optimized for consumption by BI tools and downstream applications.
- Support and collaborate on CI/CD practices for data pipelines and transformations using GitHub Actions.
Required Languages
English Fluent advanced 80- 95%
Job Location
Mexico