Pessoa Especialista em Business Intelligence – Microsoft Fabric

This is a fully remote position, open to applicants in Brazil.

📋 Description

• Develop, maintain, and enhance semantic models and reports on the Microsoft Fabric / Power BI platform.

• Ensure the technical quality of deliveries: dimensional modeling, optimized DAX measures, RLS/OLS, and best development practices.

• Define and disseminate technical development standards within the BI CoE.

• Support the integration between data engineering layers and the analytical layer, ensuring data accessibility, reliability, and performance.

• Operate and advance the BI team's CI/CD pipeline, ensuring quality and traceability in deliveries.

• Structure and support the self-service model for business areas: training, governance, and enabling creators.

• Contribute to the management and monitoring of the platform's analytical capabilities, suggesting performance and cost optimizations.

• Engage 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: capabilities, workloads, and connection modes.

• SQL skills for validating and developing queries and applying business rules.

• Knowledge of the Databricks platform, medallion architecture, and engineering pipeline development (Gold Layer).

• Experience with version control using Git: branches, pull requests, and code reviews.

• Familiarity with CI/CD pipelines applied to BI development (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.

• Additional Advantage:

• Hands-on experience with Microsoft Fabric: Lakehouses, Direct Lake, Mirror Shortcuts, and Deployment Pipelines.

• Experience with Tabular Editor and tools for analyzing model quality (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 environments with high volume and seasonality.

• Desirable:

• 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 applied to analytical environments.

• Experience in modernization or migration projects of BI platforms (legacy projects).

• Familiarity with agile methodologies applied to data projects.

• Knowledge of cloud data architecture (Lakehouse, Medallion, Data Mesh).

🏝️ Benefits

• Transportation allowance and/or shuttle service for positions in our distribution centers*;

• Meal/Food allowance;

• Christmas basket allowance;

• Home Office assistance (for hybrid or remote work contracts)*;

• Multi-purchase credit card;

• Employee discount at our stores.

• Health insurance;

• Dr. Be (telemedicine, telepsychology, nutritional coaching, and sports coaching);

• Wellhub (Gympass);

• Programs and campaigns developed to promote the health and wellness of our employees and their families.

• Balance methodology applied alongside leadership and teams to strengthen communication, recognition, well-being, and working style/tools.

• Dental plan;

• Univers - discounts at Raia and Drogasil pharmacies;

• Pet health insurance;

• Running advisory;

• Discounts on universities, schools, language courses, and vocational training;

• Tickets for cinemas, parks, and much more.

• People with disabilities are welcome in all our opportunities.