BI​/Data Architect - INTL Mexico

Senior Bi/Data Architect Consultant

We are seeking a senior BI/Data Architect Consultant with strong hands-on Power BI expertise to assess and guide the redesign of an existing KPI reporting model. The focus is on data modeling, semantic model design, KPI calculation logic, business rules, relationship management, data quality, and validation. The consultant will work alongside the internal team to evaluate the current Power BI environment, identify risks such as duplicate records, relationship issues, and hardcoded logic, and recommend a scalable, maintainable architecture.

The ideal candidate will help design a reliable KPI framework that supports programs, project phases, services, vendors, metrics, and reporting periods while ensuring calculations are accurate, auditable, and easy to maintain. Responsibilities include reviewing source data structures, recommending improvements to reduce manual transformations, defining flexible business rules for KPI weights and SLAs, validating Power BI calculations against source data, and establishing audit controls to ensure transparency and data integrity.

The goal is to leave the organization with a sustainable reporting model that the internal team can confidently manage and evolve after the engagement ends.