Business Intelligence Specialist – Microsoft Fabric

Role Overview

• Develop, maintain, and evolve semantic models and reports on the Microsoft Fabric / Power BI platform
• Ensure the technical quality of deliverables: dimensional modeling, optimized DAX measures, RLS/OLS, and development best practices
• Define and disseminate technical development standards within the BI CoE
• Support integration between data engineering layers and the analytical layer, ensuring data is accessible, reliable, and performant
• Operate and enhance the BI team’s CI/CD pipeline, ensuring quality and traceability of deliveries
• Structure and support a self-service model for business areas: training, governance, and creator enablement
• Contribute to the management and monitoring of the platform’s analytical capabilities, proposing performance and cost optimizations
• Participate in data governance initiatives: lineage, sensitivity classification, and access policies
• Produce technical documentation and conduct workshops and training for internal teams
• Collaborate with multiple technology and business areas, acting as a technical reference and solution facilitator

Requirements

• Advanced proficiency in DAX: complex measures, time intelligence, and performance optimization
• Experience with dimensional modeling (star schema, snowflake) and semantic model design
• Practical knowledge of Microsoft Fabric or Power BI Premium: capacities, workloads, and connection modes
• SQL for validation, query development, and application of business rules
• Knowledge of the Databricks platform, medallion architecture, and engineering pipeline development (Gold layer)
• Experience with version control using Git: branching, pull requests, and code reviews
• Familiarity with CI/CD pipelines applied to BI development (Azure DevOps, GitHub)
• Experience with RLS (Row-Level Security) and OLS (Object-Level Security)
• Strong technical communication skills and the ability to interact with engineering teams and business stakeholders
• Hands-on experience with Microsoft Fabric: Lakehouses, Direct Lake, Mirror Shortcuts, and Deployment Pipelines
• Experience with Tabular Editor and model quality analysis tools (Best Practice Analyzer)
• Familiarity with Data Catalogs
• Experience with the .pbip format and collaborative report development
• Microsoft certifications: PL-300 (Power BI Data Analyst) and/or DP-600 (Fabric Analytics Engineer)
• Experience in the retail sector or in high-volume, seasonal environments
• Understanding of data ingestion pipelines (Azure Data Factory, Fabric Data Pipelines, or equivalents)
• Knowledge of Python or PowerShell for automation via data APIs
• Understanding of LGPD (Brazilian General Data Protection Law) as applied to analytical environments
• Experience in modernization or migration projects for BI platforms (legacy migrations)
• Familiarity with agile methodologies applied to data projects
• Knowledge of cloud data architecture (Lakehouse, Medallion, Data Mesh)

Tech Stack

• Azure
• Python
• SQL

Benefits

• Transport allowance and/or company shuttle for our DCs*
• Meal / food allowance
• Christmas food basket voucher
• Home office allowance (for hybrid or remote contracts)*
• Multi-purchase credit card
• Employee discount in our stores
• Health insurance
• Dr. Be (telemedicine, telepsychology, nutritional coaching, and sports coaching)
• Wellhub (Gympass)
• Programs and campaigns designed to promote the health and well-being of our employees and their families
• Balance methodology applied with leadership and teams to strengthen communication and recognition, well-being, and work style/tools
• Dental plan
• Univers – discounts at Raia and Drogasil pharmacies
• Pet health plan
• Running coaching
• Discounts at universities, schools, language courses, and professional training
• Tickets for cinemas, parks, and more