Analyst (Power BI)

As a Power BI Specialist at Oliver Wyman's Data & Analytics team in Hyderabad or Gurugram office, you will play a crucial role in developing high-quality dashboards, reports, and data models to provide business insights to consulting teams. Your strong analytical skills, attention to detail, and ability to translate business requirements into impactful visualizations will be pivotal in delivering outstanding results. You will work closely with Senior Analysts and Lead Analysts to deliver data-driven insights by performing the following key responsibilities: - Develop Power BI dashboards, reports, and visualizations based on business requirements. - Work with senior team members to understand KPIs, metrics, and data definitions. - Perform data cleaning, transformation, and modeling using SQL, Power Query, and DAX. - Ensure accuracy and consistency of data across reports and data sources. - Prepare documentation for dashboards, data models, and business logic. - Conduct basic troubleshooting and performance optimization for reports. - Support ad-hoc analysis requests from business stakeholders. - Stay updated with Power BI features and best practices to improve reporting standards. Qualifications Required: - Bachelor's degree in science, Finance, Mathematics, Economics, or equivalent. MS or Certificate courses in analytics preferred. Experience & Skills Requirements: - 1+ years of experience in Power BI, with strong foundational skills in Power Query, DAX, and data modeling. - Experience with Power BI ecosystem tools, including custom visuals, Dataflows, and Power Automate. - Ability to understand business logic and convert it into meaningful dashboards. - Good knowledge of Excel, SQL, or other analytical tools. - Strong attention to detail and data accuracy. - Good communication skills and willingness to learn quickly. - Ability to work in a fast-paced environment with multiple tasks. - Experience using Power Automate, Power Apps, and Sharepoint is preferred. - Excellent analytical and problem-solving skills with proficiency in data modeling and visualization skills. - Strong written and verbal communication skills with the ability to interact effectively with all levels of stakeholders. - Fast learner with the ability to pick up new tools/platforms quickly. - Advanced skills in MS-Office, along with familiarity with Gen AI and other analytical tools preferred. - Willingness to travel as required to meet client needs. Oliver Wyman, a business of Marsh, is a global leader in risk, reinsurance, capital, people and investments, and management consulting, with the aim to help clients thrive through the power of perspective. Marsh is committed to embracing diversity, inclusivity, and a flexible work environment, providing the opportunity for remote work while fostering collaboration and professional development. All colleagues are expected to be in their local office or working onsite with clients at least three days per week, with teams having at least one 'anchor day' per week for in-person collaboration. As a Power BI Specialist at Oliver Wyman's Data & Analytics team in Hyderabad or Gurugram office, you will play a crucial role in developing high-quality dashboards, reports, and data models to provide business insights to consulting teams. Your strong analytical skills, attention to detail, and ability to translate business requirements into impactful visualizations will be pivotal in delivering outstanding results. You will work closely with Senior Analysts and Lead Analysts to deliver data-driven insights by performing the following key responsibilities: - Develop Power BI dashboards, reports, and visualizations based on business requirements. - Work with senior team members to understand KPIs, metrics, and data definitions. - Perform data cleaning, transformation, and modeling using SQL, Power Query, and DAX. - Ensure accuracy and consistency of data across reports and data sources. - Prepare documentation for dashboards, data models, and business logic. - Conduct basic troubleshooting and performance optimization for reports. - Support ad-hoc analysis requests from business stakeholders. - Stay updated with Power BI features and best practices to improve reporting standards. Qualifications Required: - Bachelor's degree in science, Finance, Mathematics, Economics, or equivalent. MS or Certificate courses in analytics preferred. Experience & Skills Requirements: - 1+ years of experience in Power BI, with strong foundational skills in Power Query, DAX, and data modeling. - Experience with Power BI ecosystem tools, including custom visuals, Dataflows, and Power Automate. - Ability to understand business logic and convert it into meaningful dashboards. - Good knowledge of Excel, SQL, or other analytical tools. - Strong attention to detail and data accuracy. - Good communication skills and willingness to learn quickly. - Ability to work in a fast-paced environment with multiple tasks. - Experience using