Business Intelligence Leader

    • Norwood, MA

At Mercer, we make a difference in the lives of more than 110 million people every day by advancing their health, wealth, and careers. We're in the business of creating more secure and rewarding futures for our clients and their employees - whether we're designing affordable health plans, assuring income for retirement or aligning workers with workforce needs. Using analysis and insights as catalysts for change, we anticipate and understand the individual impact of business decisions, now and in the future. We see people's current and future needs through a lens of innovation, and our holistic view, specialized expertise, and deep analytical rigor underpin each and every idea and solution we offer. For more than 70 years, we've turned our insights into actions, enabling people around the globe to live, work, and retire well. We embrace a culture that celebrates and promotes the many backgrounds, heritages and perspectives of our colleagues and clients. At Mercer, we say we Make Tomorrow, Today . Visit for more information and follow us on LinkedIn and Twitter @Mercer


Business Intelligence and Data Strategy

  • Define strategy for operational dashboards and scorecards that meet the business needs for client and operational reporting
  • Define the strategy for data storage and structure so that the operations is able to best use that data
  • Collaborate with technology leads to manage business data in line with digital roadmap and areas where the technology roadmap impacts or enables business data reporting; serve as the operational representative to manage the conversation with technology, ask appropriate questions and manage impacts to business priorities
  • Support predictive modeling and data visualization to drive business value
  • Build partnerships across the matrixed organization so that resources across departments align with the BI Strategy and priorities
  • Participate in strategic projects to represent the power and ability of business data to drive business strategy; ensure the massive amount of data available is stored and harnessed

Data Governance
  • Define key roles and responsibilities within a business data governance framework
  • Build Data Governance framework for business reporting; provide key leadership and direction in the governance model; serve as expert voice to drive the organization forward
  • Determine maturity of current business data model; assess where reporting activities are happening across the organization and how to build integrations and alignment with best practices
  • Ensure quality and best practices in data collection, transformation and reporting; ensure data structures are built the right way; focus on the new build as well as how to move the legacy data forward
  • Develop plan for onboarding of new data sources; ensure governance for access to data sources and self-service reporting
  • Lead report development roadmap reviews and change management to ensure new requests or custom requests are in line with standards and best practices
  • Build control plan to ensure data loads and report production align with optimal delivery channels: automation, self-service or GOSS production team
  • Assess legacy reports for improvements that reduce production time and/or improve report quality and value

Staff Management
  • Manage a team of report developers and production analysts
  • Ensure report developers follows best practices
  • Ensure report usage and business value are periodically audited to eliminate reports no longer being used
  • Develop team skills; bring the team along to ensure the entire team operates in line with standards and procedures
  • Provide guidance and support to the team member assignments


  • Bachelor's degree strongly preferred, advanced degree a plus

Knowledge & Skills
  • Extensive experience with SQL databases and data architecture
  • Extensive experience in data modeling
  • Understanding of disciplined approach towards Data Visualization and Reporting
  • Experience in setting up complex ETL processes, involving relational and non-relational data
  • Experience with at least one major BI/Reporting Application
  • Ability to lead cross-functional team communication and develop cross-functional partnerships
  • Excellent problem solving and data analysis skills
  • Familiarity with SQL Server, Informatica, Microstrategy, Power BI, Qlik
  • Exposure to cloud computing and Big Data stacks
  • Excellent grasp of data structures and interaction between applications and data
  • Ability to quickly grasp existing systems, goals and technical options for given situations
  • Experience with analytics and statistical modelling
  • Experience implementing a data governance program
  • Experienced complete lifecycle of at least one data warehouse/Business Intelligence program at Enterprise scale
  • Structured thinker; problem solver; result oriented person passionate about data driven decision making
  • Should possess good communication capabilities; collaborative abilities; results driven; adaptable; organized and quality focused
  • Understanding of best standards, guidelines etc. and drives to adherence
  • Ability to handle complex problems from design to execution and deliver in time bound manner under constraints

Marsh & McLennan Companies offers competitive salaries and comprehensive benefits and programs including: health and welfare, tuition assistance, 401K, employee assistance program, domestic partnership benefits, career mobility, employee network groups, volunteer opportunities, and other programs. For more information about our company, please visit us at: We embrace a culture that celebrates and promotes the many backgrounds, heritages and perspectives of our colleagues and clients. For more information, please visit us at:

Mercer LLC and its separately incorporated operating entities around the world are part of Marsh & McLennan Companies, a publicly held company (ticker symbol: MMC).

Marsh & McLennan Companies and its Affiliates are EOE Minority/Female/Disability/Vet/Sexual Orientation/Gender Identity employers.

Back to top