Contract Duration: 12 months
Engagement: Full-time contract
Location: Remote, Mexico, Colombia, Argentina
Project Objective
Our client is looking for a senior, hands-on Data Architect / Engineer to lead the design and delivery of an analytical data platform in Microsoft Fabric.
The objective is to offload historical and analytical workloads from a core transactional product into a secure, governed analytical data store. The solution must preserve the authorization context required for downstream consumption, support customer-facing reporting, and establish a foundation for future data products.
Design and implement ingestion and historical offload from Azure-based transactional databases into Microsoft Fabric.

~ Establish a layered or medallion architecture covering source-aligned, transformed, and consumption-ready data.

~ Design for historical preservation, change handling, retention, deletions, reconciliation, and future transactional data purging.

~ Implement the engineering controls required for production operation, including testing, data quality, monitoring, recovery, security, and deployment.

~ Transfer knowledge to the internal Data & Analytics team so the platform can be operated and extended after the contract.

Senior-level experience delivering data architecture and data-engineering solutions in production environments.

~ Proven experience transforming data from complex OLTP applications into analytical platforms, data warehouses, lakehouses, or OLAP solutions.





~ Strong hands-on experience building data solutions in Azure, with practical experience or working knowledge of Microsoft Fabric.

~ Experience designing layered or medallion data architectures, analytical models, semantic layers, and downstream consumption patterns.

~ Strong understanding of historical data offload and lifecycle management, including incremental change, deletions, retention, archival, reconciliation, and purge considerations.

~ Experience designing secure analytical solutions based on application roles, permissions, tenant boundaries, and access‐control requirements.

~ Experience with both single-tenant and multi-tenant data environments.

~ Advanced SQL and strong hands‐on Python skills for building maintainable, testable, production‐ready data pipelines and transformations.

~ Experience with PySpark or comparable distributed data‐processing frameworks.

~ Practical use of AI‐assisted engineering tools for technical discovery, development, testing, troubleshooting, and documentation, with appropriate review and validation of outputs.

~ Strong written and spoken English.

You will act as the primary technical owner for the assigned project scope. Success requires hands‐on delivery, proactive identification of technical risks, clear communication of decisions and trade‐offs, and close collaboration with Data & Analytics, Engineering, Product, Architecture, Security, and external delivery partners.

📌 Senior Data Engineer (Ciudad de México)
🏢 Alcor
📍 Ciudad de México