BI/Data Analyst

Location: Remote – Colombia

Schedule: U.S. EST hours, 8:00 AM EST start

Duration: 9–12 Month Contract

Start: ASAP

Role Overview

We are seeking a BI/Data Analyst to support a large-scale Business Intelligence modernization project involving the migration of approximately 700–800 existing Power BI reports into Microsoft Fabric.

This role will focus heavily on analyzing the existing Power BI environment before and throughout the migration. The BI/Data Analyst will inventory reports, analyze usage and dependencies, trace data and report lineage, identify duplicate or outdated reports, catalog DAX measures, and help determine which reports and metrics should be migrated, consolidated, or retired.

Key Responsibilities

• Inventory and analyze approximately 700–800 existing Power BI reports.
• Review report usage and telemetry to understand adoption and identify unused or outdated reports.
• Trace report dependencies, data lineage, data sources, and relationships across the reporting environment.
• Identify duplicate, redundant, overlapping, and outdated reports.
• Build and maintain a detailed catalog of reports, dependencies, measures, and migration requirements.
• Review and catalog existing DAX measures and metric definitions.
• Use SQL and Power BI hands-on to analyze report logic and underlying data.
• Reconcile existing reports and metrics against source data to identify discrepancies.
• Perform report testing, data validation, and quality checks throughout the migration.
• Identify gaps and inconsistencies across the existing reporting environment.
• Help determine which reports and measures should be migrated, consolidated, redesigned, or retired.
• Partner closely with semantic modeling and migration teams as reports transition into the new Microsoft Fabric environment.
• Document findings, lineage, dependencies, and recommendations clearly.
• Communicate effectively with technical and business stakeholders throughout the project.

Required Qualifications

• 3–5+ years of experience in Business Intelligence, Data Analysis, or a related role.
• Strong hands-on experience with Power BI.
• Strong SQL skills.
• Experience auditing, inventorying, or analyzing an existing BI/reporting environment.
• Experience with report usage analysis, dependency mapping, and data/report lineage tracing.
• Experience identifying duplicate or redundant reports and cataloging findings.
• Experience reading, analyzing, and cataloging DAX measures.
• Strong report reconciliation, testing, and data-validation experience.
• Ability to understand existing report logic, KPIs, metrics, and data sources.
• Strong analytical and documentation skills.
• Strong English communication skills and experience working with English-speaking teams or clients.
• Ability to work remotely from Colombia while aligned with an 8:00 AM EST start time.

Preferred Qualifications

• Microsoft Fabric experience.
• Experience supporting Power BI or enterprise BI migration/modernization initiatives.
• Banking or financial-services industry experience.
• Experience working with large, complex enterprise reporting environments.