Senior

We are seeking a skilled professional (Senior/Team lead) to join our US Advisory team in DE&M capability, focusing on Data Modeling and Insights Generation, PBI Dashboard and Report Development, and PowerApps/Workflow Development.

Key Responsibilities:

Data Modeling and Insights: Design data models to transform raw data into actionable insights, analyzing historical and current data for informed decision-making.

Power BI Development: Create and optimize dynamic dashboards and reports in Power BI, utilizing Power Query for sophisticated data models and DAX for data manipulation. Develop and deploy comprehensive Power BI solutions.

PowerApps and Workflow Development: Design and implement applications and workflows using PowerApps, Power Automate, and the Microsoft Power Platform. Collaborate with stakeholders to meet business needs and ensure solutions are scalable and reliable. Maintain and optimize workflows, integrate solutions with platforms like SharePoint and Teams, and provide training and documentation.

This role requires strong technical expertise and the ability to translate business requirements into effective technical solutions.

·Data Modeling and Insights Generation:

• Design and map data models to effectively transform raw data into meaningful insights.
• Analyze both historical and present data to support informed decision-making.

·PBI Dashboard and Report Development:

• Utilize Power BI to create dynamic, interactive, and visually appealing dashboards and reports.
• Enhance and optimize existing Power BI dashboards and reports to improve visual appeal and performance.
• Build sophisticated multi-dimensional data models using Power Query.
• Execute DAX queries and functions to manipulate data within Power BI.
• Design, develop, and deploy comprehensive Power BI solutions and reporting tools.

·PowerApps/Workflow Development

• Design, develop, and implement applications and workflows using PowerApps, Power Automate, and other Microsoft Power Platform tools.
• Collaborate with stakeholders to understand business requirements and translate them into technical solutions.
• Optimize and maintain existing workflows to improve performance and user experience.

·PowerApps/Workflow Development cont.

• Ensure the scalability and reliability of PowerApps solutions in production environments.
• Troubleshoot and resolve issues related to PowerApps applications and workflows.
• Integrate PowerApps solutions with other Microsoft platforms such as SharePoint, Dynamics 365, and Teams.
• Provide technical documentation and training to end-users and team members.

Required Qualifications & Experience

•Minimum of 5-6 years progressive experience in utilizing Power BI, building data models with Power Query and Designing workflows and apps. •Proven experience in developing applications and workflows using PowerApps and Power Automate. Experience with Data connectors, Common Data Service (CDS), and API integrations is a plus •Strong understanding of Microsoft Power Platform architecture and capabilities with working knowledge of integrating PowerApps with other Microsoft products (e.g., SharePoint, Dynamics 365). •Knowledge of Alteryx for data manipulation and workflow management (good to have). •Advanced proficiency in Microsoft Excel, including the use of complex formulas and functions along with VBA. •Strong analytical skills and the ability to work with large datasets. •Experience in running and optimizing DAX queries and functions. •Proven track record of enhancing and maintaining interactive dashboards and reports using PowerBI & Excel.