Power BI Specialist

Guy Carpenter is seeking candidates for the following position based in the Mumbai office: We are seeking a highly skilled and motivated Power BI Specialist to join our team as a key member of the Management Information department As a Power BI Specialist, you will be responsible for developing and maintaining interactive dashboards, reports, and visualizations using Power BI to support data-driven decision-making and provide valuable insights to stakeholders. Additionally, proficiency in Excel, SQL and Access database, VBA development, Power Apps, and Power Automate will be essential for this role. What is in it for you? • Opportunity to enhance your knowledge in Insurance/Reinsurance broking • As a Specialist, you will have the opportunity to analyze and interpret data to provide valuable insights and recommendations to key stakeholders • Exposure to different business functions and departments, which can broaden your understanding of the organization as a whole • Opportunity to work with global leads on various initiatives (process improvement, automation) We will count on you for: • Collaborate with business stakeholders to understand their reporting and analytics requirements and translate them into effective Power BI solutions. • Design, develop, and maintain interactive dashboards, reports, and visualizations using Power BI to provide actionable insights and support data-driven decision-making. • Utilize Excel, SQL, and Access database skills to extract, transform, and load data from various sources into Power BI for analysis and visualization. • Develop VBA macros and automation solutions to enhance data processing and reporting capabilities. • Leverage Power Apps and Power Automate to create custom applications and automate workflows for data collection, analysis, and reporting. • Create and optimize data models, data connections, and data transformations to ensure accurate and efficient data analysis. • Perform data analysis and data profiling using SQL to identify data quality issues and recommend solutions for data cleansing and data governance. • Collaborate with data engineers and data architects to ensure the availability, reliability, and security of data sources and data pipelines. • Stay up to date with the latest Power BI features, Excel functions, SQL queries, and industry trends to continuously improve the reporting and analytics capabilities. What you need to have: • This role requires proficiency in Microsoft Excel, SQL, and Power BI • Skills such as data modeling, statistical analysis, data mining, and data visualization • Collaborative (good at working in a team) • Effective communicator • Attention to detail • Analytical ability and Decision making • Influencing and Negotiation skills What makes you stand out? • Strong problem-solving and analytical skills and ability to work with large quantities of data • Good communication, collaboration and people skills • Strong ability to plan and manage numerous processes, people and priorities simultaneously • Experience in statutory audits and dealing with auditors. Guy Carpenter & Company , LLC is a leading global risk and reinsurance specialist with more than 3,500 professionals in over 60 offices around the world. Guy Carpenter delivers a powerful combination of broking expertise, trusted strategic advisory services and industry-leading analytics to help clients adapt to emerging opportunities and achieve profitable growth. Guy Carpenter is a business of Marsh McLennan (NYSE: MMC), the world’s leading professional services firm in the areas of risk, strategy and people. The company’s 85,000 colleagues advise clients in over 130 countries. With annualized revenue of over $23 billion, Marsh McLennan helps clients navigate an increasingly dynamic and complex environment through four market-leading companies including Marsh, Mercer and Oliver Wyman. For more information, visit and follow us on LinkedIn and X. Marsh McLennan is committed to embracing a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age, background, caste, disability, ethnic origin, family duties, gender orientation or expression, gender reassignment, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex/gender, sexual orientation or expression, skin color, or any other characteristic protected by applicable law. Marsh McLennan is committed to hybrid work, which includes the flexibility of working remotely and the collaboration, connections and professional development benefits of working together in the office. All Marsh McLennan colleagues are expected to be in their local office or working onsite with clients at least three days per week. Office-based teams will identify at least one “anchor day” per week on which their full team will be together in person