It's fun to work in a company where people truly BELIEVE in what they are doing!

We're committed to bringing passion and customer focus to the business.

Senior Consultant - Power Platforms Specialist

Job Description: We are seeking a highly skilled Power Platforms Specialist with 6-8 years of relevant experience to join the Operational Excellence team at Fractal. In this role, you will play a pivotal role in developing, maintaining, and enhancing a host of complex Power BI dashboards, which serve as the backbone of operations within Fractal. You will also be responsible for creating and maintaining automations using Power Automate, providing reports with key business metrics to senior leadership in the organization.

Role Details

Develop, maintain & enhance complex Power BI dashboards with technical mastery in: Data manipulation & parameterization using MQuery/ M language in Power BIWriting custom functions in MQueryPulling data in Power BI using APIs, SharePoint, SQL, DirectQuery connectionsAdvanced DAX evaluations including, but not limited to, creating complex measures using: Iterative functions (MINX, MAXX, CONCATENATEX, SUMX, COUNTX, RANKX, and so on) Calculated tables (SUMMARIZE, ADDCOLUMNS, UNION, SELECTCOLUMNS, CROSSJOIN, VALUES, DISTINCT, and so on) Relationships using DAX (CROSSFILTER, TREATAS, USERELATIONSHIP, and so on)Implementation of Field Parameters, Bookmarks, Tooltips, Drill Through features in Power BIDataflows in Power BI & Implementing dynamic row-level securityEnhance and optimize existing code and its performance with the help of DAX Studio, Tabular Editor, Measure Killer, Performance Analyser and other such toolsUnderstanding and application of how Dashboard subscription works on Power BI serviceUnderstanding and application of Paginated Report creationCreate Power Automate flows to trigger data refreshes (ability to use Power Automate Desktop in attended & unattended modes)Creating Power Automate flows to trigger automated workflows which would enable: Sending automated emails to senior stakeholders with business updates. Creating and sending dynamic adaptive cards to business leaders. Creating structured flows which are reusable with the help of Parent-Child flow concepts.Ability to work with Power BI APIs with the help of authentication using Azure Active Directory and Service Principal accountUnderstanding of SharePoint ListsExperience of Azure Devops Integration with Power BI for CI/CD

Qualifications and Skills

6-8 years of experience in Power Platforms, with a focus on Power BI and Power AutomateExpert-level knowledge in Power BI, DAX, and Power Automate and experience with data integration from various sources like APIs, SharePoint, SQL, and DirectQuery connectionsUnderstanding of RESTful APIs in PowerBIAbility to work individually and as a part of a dynamic team and in a fast-paced environment.Up to date with new releases and functionalities in Power BIWillingness to understand and dive deeper into Fractal ways of working and operational concepts for a service-based organization.Demonstrated ability to guide and mentor junior team membersExcellent written and verbal communication skills

Location: Mumbai/Pune
 

Must have skills: Power BI, Advanced DAX, M Language, RESTful APIs, Power BI APIs, Power Automate

Join our dynamic team dedicated to operational excellence and technology. We seek motivated individuals committed to technical excellence and eager to learn and grow

If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us!

Not the right fit?  Let us know you're interested in a future opportunity by clicking Introduce Yourself in the top-right corner of the page or create an account to set up email alerts as new job postings become available that meet your interest!