Senior Data Architect – Azure, Lakehouse

This is a fully remote position, open to applicants in Mexico, +5 more countries.

📋 Description

• Assess legacy production workloads by reverse engineering Alteryx workflows, SSIS packages, and SQL Server jobs.

• Determine actual behavior, undocumented dependencies, historical fixes, and implicit business logic.

• Audit automated analysis reports against original source artifacts and rectify discrepancies, omissions, and unsupported assumptions.

• Specify target lakehouse architecture, ingestion patterns, data types, partitioning strategies, naming conventions, and scalability standards.

• Establish data modeling, lineage, access, governance, and Unity Catalog security practices.

• Review and officially approve documented design plans prior to authorizing automated code generation.

• Resolve technical escalations, business ambiguities, and limitations of multi-agent systems requiring human intervention.

• Provide technical guidance and remove obstacles for up to three engineers or developers simultaneously.

• Review and approve pull requests aimed at protected branches such as preprod and main.

• Document assumptions, alternatives, trade-offs, and approvals for architecture decision traceability and auditability.

• Validate automated analysis and offer technical oversight within an AI-assisted modernization workflow.

⛳️ Requirements

• Senior-level experience in data engineering and data architecture, with direct responsibility for cloud architecture design decisions.

• Proven experience leading the modernization of legacy ETL workloads into lakehouse architectures.

• Practical experience with Apache Spark in production and PySpark for data processing and transformation.

• Comprehensive knowledge of Delta Lake, Medallion architecture, lakehouse patterns, and data warehouse concepts.

• Familiarity with Azure cloud data platforms.

• Strong working knowledge of SQL Server, T-SQL, and SSIS, including the ability to investigate existing ETL logic and dependencies.

• Experience in data modeling, data governance, and data lineage.

• Proficiency in Azure DevOps, Git-based collaboration, CI/CD, and pull request reviews.

• Experience providing technical leadership to engineers or developers; formal people management experience is not required.

• Capability to make informed decisions with incomplete information, validate assumptions, and document the rationale behind technical choices.

• Excellent communication skills to articulate design decisions, clarify business rules, and facilitate implementation.

• Proficiency in English sufficient for independent participation in technical discussions and the production of clear documentation.

• Nice to have — non-blocking: practical experience with Databricks and Unity Catalog.

• Nice to have — non-blocking: experience analyzing or migrating Alteryx workflows.

• Nice to have — non-blocking: experience with streaming technologies such as Solace, Kafka, or Lakeflow.

• Nice to have — non-blocking: broader DevOps experience supporting data platform delivery.

• Nice to have — non-blocking: experience with SAST controls and vulnerability management tools, such as Fluid Attacks or similar platforms.

• Nice to have — non-blocking: experience reviewing AI-generated analysis or code within an engineering workflow.

🏝️ Benefits

• Collaborate with global brands and innovative startups.

• Enjoy the flexibility of remote work/Home office.

• Work schedule aligned with your assigned team/project.

• Work Monday through Friday.

• Take a day off on your birthday.

• Major medical expenses insurance (applicable in Mexico).

• Life insurance coverage (applicable in Mexico).

• Be part of multicultural teams.

• Access to courses and certifications.

• Participate in virtual team-building events and interest groups.

• Attend English classes.

• Explore opportunities within our various business lines.

• Proudly certified as a Great Place to Work.