Senior Data Architect / Engineer

• Contract Duration: 12 months
• Engagement: Full-time contract
• Location: Remote, Mexico, Colombia, Argentina

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.

You will own the technical delivery of this initiative, working with internal teams and external technical partners from discovery and architecture through implementation, production readiness, documentation, and knowledge transfer.

• Deliver a production-ready architecture that separates transactional and analytical workloads.
• 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.
• Create analytical and semantic models that support secure downstream reporting and customer-facing use cases.
• Understand the application's roles, permissions, and visibility rules, and translate the required authorization context into appropriate analytical access patterns.
• Design for historical preserv