Associate BI Analyst (Microsoft Fabric & Power BI)

El Comeback•Cataño, PR

6h•$40,000

About The Position

Positions posted by El Comeback are done on behalf of companies that we support in their search for candidates. Our client, Ballester Hermanos, Inc, is looking foor a Associate BI Analyst (Microsoft Fabric & Power BI) Job Description: Title: Associate BI Analyst (Microsoft Fabric & Power BI) Location: Cataño, Puerto Rico Compensation: ~$40,000 base + bonus/benefits About Us: We are a leading wholesale distributor scaling from $500M to $1B in annual sales, modernizing our analytics from legacy Business Objects to Microsoft Fabric + Power BI . Were building a trusted, scalable BI foundation that empowers Sales, Supply Chain, Finance, and Operations. What Youll Do Develop robust Power BI datasets and reports using dimensional modelling and clean DAX. Assist our Microsoft Fabric buildout: Dataflows Gen2, Lakehouse/Warehouse artifacts, deployment pipelines. Implement governance: workspace standards, RLS, documentation, and data dictionary. Support the migration of legacy reports to modern Power BI dashboards; enable business teams via templates and training. Collaborate with IT/data engineering on data quality checks and incremental refresh strategies. Continuously improve report performance, usability, and adoption. What You Bring 1–3 years of Power BI development or equivalent project work. Strong SQL and Power Query (M); solid grasp of star schemas and DAX measures. Familiarity with Microsoft Fabric concepts; eagerness to learn advanced features. Clear communication, attention to detail, and ownership mindset. Bonus: PL-300 or progress toward DP-600; exposure to Purview, deployment pipelines, or Business Objects migrations. Why Join Be part of a high-growth transformation. Learn Microsoft Fabric end-to-end with mentorship and sponsored certifications. Build portfolio-defining solutions impacting frontline sales, inventory, and finance. Mission of the Role Accelerate our migration to Microsoft Fabric and Power BI by building reliable data models, scalable reports, and repeatable governance/operational practices. Serve as the connective tissue between business users, data engineering, and IT—ensuring trustworthy analytics for Sales, Supply Chain, Finance, and Operations

Requirements

1–3 years of Power BI development or equivalent project work.
Strong SQL and Power Query (M); solid grasp of star schemas and DAX measures.
Familiarity with Microsoft Fabric concepts; eagerness to learn advanced features.
Clear communication, attention to detail, and ownership mindset.
Power BI (strong): Data modelling (star schema), DAX measures, Power Query (M), RLS, incremental refresh, aggregations.
Performance tuning (model size, relationships, calc groups via Tabular Editor, visuals optimization).
Fabric Fundamentals: Workspaces, OneLake concepts, Lakehouse vs Warehouse, Dataflows Gen2, Deployment Pipelines.
Basic familiarity with notebooks/Spark (ability to read and follow patterns).
SQL: Strong querying skills (CTEs, window functions, joins, basic optimization).

Nice To Haves

PL-300 or progress toward DP-600; exposure to Purview, deployment pipelines, or Business Objects migrations.

Responsibilities

Power BI Development & Modelling Build semantic models (datasets) with star schemas; optimize DAX and model relationships.
Develop enterprise-grade, user-friendly reports and dashboards with consistent standards.
Implement incremental refresh, aggregations, and row-level security (RLS).
Microsoft Fabric (Foundation) Assist with data ingestion using Dataflows Gen2; support Lakehouse/Warehouse artifacts in OneLake.
Support Deployment Pipelines, workspace organization, capacity usage monitoring, and Git integration.
Data Quality & Documentation Define data dictionary/business definitions, KPIs, and lineage in collaboration with business stakeholders.
Write reusable Power Query (M) transformations; create validation checks for data quality.
Governance & Operations Help implement workspace standards, naming conventions, CI/CD, access/RLS, and tagging.
Participate in Microsoft Purview cataloguing/lineage and sensitivity labelling (with Security/Compliance).
Migration Tasks (Business Objects Fabric/Power BI) Inventory legacy reports, map to new models, design replacement visuals, and user acceptance tests.
Work alongside IT/Engineering to plan decommissioning and training of business teams.
Support & Enablement Respond to ad-hoc report needs with an enablement-first approach: templates, training, office hours.
Produce concise documentation and How-To guides for departmental analysts.