Power BI, Analytics Engineer

This is a fully remote position, open to applicants in Brazil, +1 more country.

📋 Description

• Comprehend the reporting needs of finance and business stakeholders and convert them into Power BI dashboards.

• Create and sustain Power BI semantic models, along with their relationships and measures.

• Formulate advanced and efficient DAX measures for business and financial reporting.

• Develop reports utilizing governed data within a medallion architecture, primarily focusing on the gold layer.

• Implement and uphold row-level security for sensitive financial, commission, and personnel data.

• Utilize Direct Lake on Microsoft Fabric when appropriate and enhance models and reports.

• Document and reproduce existing reporting definitions and business logic from the DataCube.

• Validate reports against source data and established business definitions.

• Assist in user acceptance testing alongside finance and business stakeholders.

• Document measures, definitions, and reporting logic thoroughly.

• Collaborate with the Senior Fabric Engineer and offer insights on changes to the gold-layer model.

• Create clear, intuitive, and visually appealing dashboards.

• Contribute to both internal and client-facing analytics and reporting initiatives within the Data & AI Practice.

⛳️ Requirements

• Extensive hands-on experience with Power BI, including the development of production-level dashboards and reporting solutions.

• Strong expertise in Power BI semantic modeling.

• Exceptional knowledge of DAX, with a focus on complex, efficient, and high-performance measures.

• In-depth understanding of analytical data modeling, including star schemas, relationships, and measures.

• Experience in designing and implementing row-level security (RLS) within Power BI.

• Solid understanding of Power BI connectivity and storage methods, including Import, DirectQuery, and Direct Lake.

• Experience in optimizing Power BI models and reports for enhanced performance.

• Familiarity with tools such as DAX Studio, Tabular Editor, or VertiPaq Analyzer.

• Strong SQL skills for querying, investigating, and validating underlying data.

• Proven experience in gathering requirements directly from business stakeholders and translating them into reporting solutions.

• Ability to challenge or clarify requirements to ensure the accuracy of reporting definitions and calculations.

• Strong skills in designing dashboards and reports.

• Capability to work independently while collaborating with a lead engineer responsible for the broader data platform.

• Proficient written and spoken English skills.

• Experience with Microsoft Fabric, OneLake, and Direct Lake; familiarity with finance reporting, modern data engineering concepts, cloud data platforms, CI/CD for Power BI, Microsoft certifications, and multi-client experience is advantageous but not mandatory.

🏝️ Benefits

• Join a collegial environment where responsibility and authority are shared equally among colleagues.

• A culture that fosters learning from mistakes rather than criticizing failure.

• An agile environment that welcomes new ideas.

• Opportunities for growth and exposure to diverse projects.

• Continuous training and mentoring.

• Potential for travel.