Senior Data Architect - Azure & Lakehouse (Remote, Mexico & LATAM)

About the role

DaCodes, a firm of experts in software and digital transformation, is looking for a Senior Data Architect to lead the modernization of legacy ETL workloads into scalable cloud lakehouse architectures on Azure. The role combines architecture ownership, hands-on technical analysis and guidance for up to three engineers or developers. It is remote and open to candidates based in Mexico and Latin America, with English required.

Key responsibilities

• Analyze legacy production workloads: reverse engineer Alteryx workflows, SSIS packages and SQL Server jobs to find undocumented dependencies, historical fixes and implicit business logic.
• Validate automated analysis: audit reports generated by analysis agents against source artifacts and resolve discrepancies.
• Define the target lakehouse architecture, ingestion patterns, data types, partitioning, naming conventions and scalability standards.
• Establish data modeling, lineage, access and governance practices, including security policies in Unity Catalog.
• Review and approve documented design plans (including plan.md) before authorizing automated code generation.
• Act as the final technical authority for exceptions and ambiguities flagged as needing human judgment.
• Guide the engineering team, review implementation approaches and unblock up to three engineers or developers.
• Approve integrations as a technical reviewer for pull requests to protected branches such as preprod and main.
• Document assumptions, alternatives and trade-offs so architecture decisions can be audited.

Required profile

• Senior-level experience in data engineering and data architecture, owning cloud architecture decisions.
• Demonstrated experience modernizing legacy ETL workloads into lakehouse architectures.
• Experience with data modeling, governance and lineage, and technical leadership of engineers or developers (formal people management not required).
• Ability to decide with incomplete information and strong communication skills.
• English sufficient for independent technical discussion and documentation.

Required skills

• Apache Spark and PySpark in production.
• Delta Lake, medallion architecture and lakehouse patterns.
• Azure cloud data platforms, SQL Server, T-SQL and SSIS.
• Azure DevOps, Git, CI/CD and pull request reviews.
• Nice to have: Databricks, Unity Catalog, streaming (Solace, Kafka, Lakeflow), SAST tools and reviewing AI-generated code.

What we offer

• Remote work with a schedule aligned to the team or project, Monday to Friday.
• Day off on your birthday, medical and life insurance (Mexico).
• Work with global brands and startups, multicultural teams.
• Courses, certifications, English classes and virtual team-building events.