Data and Analytics Specialist

2 weeks ago

York, York City, United Kingdom Mercer Full time

Job Summary

Guy Carpenter & Company, LLC is seeking a highly skilled Data and Analytics Specialist to join our team in the New York, NY office. As a key member of our team, you will be responsible for building automated systems that benchmark key aspects of insurance company performance against peers and support advisory solutions.

Key Responsibilities

  1. Develop and implement leading-edge data analytics systems that enable efficient gathering, reporting, and presenting data for advisory solutions.
  2. Design and maintain high-quality database solutions in PostgreSQL and MS SQL by writing SQL queries, stored procedures, views, functions, joins, and subqueries.
  3. Design and implement data pipelines, continuously expanding them through extraction, transformation, and loading activities using SQL and Microsoft Excel.
  4. Develop reports, visualizations, and presentations using Microsoft PowerPoint to communicate strategic findings and present recommendations to key stakeholders for informed business decisions.
  5. Generate data models and visualization dashboards using knowledge of business principles, insurance accounting standards, and insurance capital model frameworks.

Requirements

Must have a Master's degree or foreign equivalent in Computer Science, Data Science, Information Systems, Computer Engineering, or a related field plus one (1) year of experience in the position offered, as a Software Engineer, Data Analyst, or a related position. Employer will accept pre- or post-Master's degree experience. In the alternative, employer will accept a Bachelor's degree or foreign equivalent in Computer Science, Data Science, Information Systems, Computer Engineering, or a related field plus three (3) years of experience in the position offered, as a Software Engineer, Data Analyst, or a related position. Must have one (1) year (or three [3] years with a Bachelor's) of experience with all of the following:

  1. Programming in Python, R, Java, or.Net for data extraction, manipulation, and analysis.
  2. Implementing scalable web dynpro and EJB applications using the SAP Netweaver Portal to help analyze insurance data, monitor performance, and build a reliable information management system.
  3. Designing high-quality database solutions in PostgreSQL and MS SQL by writing SQL queries, stored procedures, views, functions, joins, and subqueries.
  4. Designing and implementing data pipelines, continuously expanding them through extraction, transformation, and loading activities using SQL and Microsoft Excel.
  5. Creating Excel templates with advanced functions (including Pivot table, VLOOKUP, Charts, Analysis, Power view, Formulas, VBA & Macros) for large datasets, enabling the identification of key trends and patterns.
  6. Developing reports, visualizations, and presentations using Microsoft PowerPoint to communicate strategic findings and present recommendations to key stakeholders for informed business decisions.
  7. Generating data models and visualization dashboards using knowledge of business principles, insurance accounting standards, and insurance capital model frameworks.

Travel Requirement

10% domestic and international travel is required to various and unanticipated company and client sites.

About Guy Carpenter & Company, LLC

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.

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, disability, ethnic origin, family duties, gender orientation or expression, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex/gender, sexual orientation or expression, skin color, veteran status (including protected veterans), or any other characteristic protected by applicable law.

Reasonable Accommodations

If you have a need that requires accommodation, please let us know by contacting reasonableaccommodations@mmc.com.

Base Salary Range

The applicable base salary range for this role is $114,300 - $155,400 per year.

Total Rewards Package

We are excited to offer a competitive total rewards package which includes health and welfare benefits, tuition assistance, 401K savings, and other retirement programs as well as employee assistance programs.

  • Microsoft Data Analytics Solutions Specialist

    3 weeks ago

    York, York City, United Kingdom Simpson Associates Full time

    About the RoleSimpson Associates is a leading provider of data and performance management solutions, and we're seeking a highly skilled Microsoft Support Consultant to join our team. As a key contact for supported customers, you'll play a critical role in delivering exceptional customer service and shaping the evolution of our customers' solutions.Key...

  • Microsoft Data Analytics Solutions Specialist

    3 weeks ago

    York, York City, United Kingdom Simpson Associates Full time

    About the RoleSimpson Associates is a leading provider of data and performance management solutions, and we're seeking a highly skilled Microsoft Support Consultant to join our team. As a key contact for supported customers, you'll play a critical role in delivering exceptional customer service and shaping the evolution of our customers' solutions.Key...

  • Microsoft Data Analytics Support Specialist

    3 weeks ago

    York, York City, United Kingdom Simpson Associates Full time

    About the RoleSimpson Associates is a leading provider of data and performance management solutions, and we're seeking a highly skilled Microsoft Support Consultant to join our team. As a key contact for supported customers, you'll play a critical role in delivering exceptional customer service and shaping the evolution of our customers' solutions.Key...

  • Microsoft Data Analytics Support Specialist

    3 weeks ago

    York, York City, United Kingdom Simpson Associates Full time

    About the RoleSimpson Associates is a leading provider of data and performance management solutions, and we're seeking a highly skilled Microsoft Support Consultant to join our team. As a key contact for supported customers, you'll play a critical role in delivering exceptional customer service and shaping the evolution of our customers' solutions.Key...

  • Microsoft Data Analytics Support Specialist

    4 weeks ago

    York, York City, United Kingdom Simpson Associates Full time

    About the RoleSimpson Associates is a leading provider of data and performance management solutions, and we're seeking a highly skilled Microsoft Support Consultant to join our team. As a key contact for supported customers, you'll play a critical role in delivering exceptional customer service and shaping the evolution of our customers' solutions.Key...

  • Microsoft Data Analytics Support Specialist

    4 weeks ago

    York, York City, United Kingdom Simpson Associates Full time

    About the RoleSimpson Associates is a leading provider of data and performance management solutions, and we're seeking a highly skilled Microsoft Support Consultant to join our team. As a key contact for supported customers, you'll play a critical role in delivering exceptional customer service and shaping the evolution of our customers' solutions.Key...

  • Data and Analytics Manager

    4 weeks ago

    York, York City, United Kingdom SoftwareONE Full time

    Unlock the Power of Marketing DataSoftwareOne is a global software and cloud technology solutions provider, and we're on a mission to redefine how organizations build, buy, and manage everything in the cloud. As a critical part of this journey, we're seeking a Senior Global Marketing Analytics Manager to join our Marketing Leadership Team.About the RoleThis...

  • Data and Analytics Manager

    4 weeks ago

    York, York City, United Kingdom SoftwareONE Full time

    Unlock the Power of Marketing DataSoftwareOne is a global software and cloud technology solutions provider, and we're on a mission to redefine how organizations build, buy, and manage everything in the cloud. As a critical part of this journey, we're seeking a Senior Global Marketing Analytics Manager to join our Marketing Leadership Team.About the RoleThis...

  • Data and Analytics Manager

    1 month ago

    York, York City, United Kingdom SoftwareONE Full time

    About SoftwareONESoftwareONE is a global software and cloud technology solutions provider that is redefining how organizations build, buy, and manage everything in the cloud. With a portfolio of 7,500 software brands and sales and delivery capabilities in 90 countries, the company is driven to deliver value to its clients. Headquartered in Switzerland,...

  • Data and Analytics Manager

    1 month ago

    York, York City, United Kingdom SoftwareONE Full time

    About SoftwareONESoftwareONE is a global software and cloud technology solutions provider that is redefining how organizations build, buy, and manage everything in the cloud. With a portfolio of 7,500 software brands and sales and delivery capabilities in 90 countries, the company is driven to deliver value to its clients. Headquartered in Switzerland,...

  • Data Scientist

    3 weeks ago

    York, York City, United Kingdom Aviva plc Full time

    About the RoleWe are seeking a talented Data Scientist to join our Insurance, Wealth, and Retirement Analytics Team. As a key member of the team, you will play a crucial role in shaping the future of insurance by applying data science techniques.The team is recognized as a centre of excellence, providing analytical insights that improve decision making and...

  • Data Scientist

    3 weeks ago

    York, York City, United Kingdom Aviva plc Full time

    About the RoleWe are seeking a talented Data Scientist to join our Insurance, Wealth, and Retirement Analytics Team. As a key member of the team, you will play a crucial role in shaping the future of insurance by applying data science techniques.The team is recognized as a centre of excellence, providing analytical insights that improve decision making and...

  • Data Scientist

    3 weeks ago

    York, York City, United Kingdom Aviva plc Full time

    About the RoleWe are seeking a highly skilled Data Scientist to join our Insurance, Wealth, and Retirement Analytics Team. As a key member of the team, you will be responsible for applying data science techniques to improve decision making and performance within Aviva.The ideal candidate will have a strong background in statistical modelling and machine...

  • Data Scientist

    3 weeks ago

    York, York City, United Kingdom Aviva plc Full time

    About the RoleWe are seeking a highly skilled Data Scientist to join our Insurance, Wealth, and Retirement Analytics Team. As a key member of the team, you will be responsible for applying data science techniques to improve decision making and performance within Aviva.The ideal candidate will have a strong background in statistical modelling and machine...

  • Data Analyst

    4 weeks ago

    York, York City, United Kingdom STEM Learning Full time

    Data Analyst RoleWe are seeking a highly skilled Data Analyst to join our team at STEM Learning. As a Data Analyst, you will play a crucial role in leveraging analytics and data science methodologies to enhance our understanding of our offerings, deepen our knowledge of our audience, and measure the impact of our work.Key Responsibilities:Embed Data...

  • Data Analyst

    4 weeks ago

    York, York City, United Kingdom STEM Learning Full time

    Data Analyst RoleWe are seeking a highly skilled Data Analyst to join our team at STEM Learning. As a Data Analyst, you will play a crucial role in leveraging analytics and data science methodologies to enhance our understanding of our offerings, deepen our knowledge of our audience, and measure the impact of our work.Key Responsibilities:Embed Data...

  • Data Analyst

    4 weeks ago

    York, York City, United Kingdom STEM Learning Full time

    Data Analyst RoleWe are seeking a highly skilled Data Analyst to join our team at STEM Learning. As a Data Analyst, you will play a pivotal role in leveraging analytics and data science methodologies to enhance our understanding of our offerings, deepen our knowledge of our audience, and measure the impact of our work.Key Responsibilities:Embed Data...

  • Data Analyst

    4 weeks ago

    York, York City, United Kingdom STEM Learning Full time

    Data Analyst RoleWe are seeking a highly skilled Data Analyst to join our team at STEM Learning. As a Data Analyst, you will play a pivotal role in leveraging analytics and data science methodologies to enhance our understanding of our offerings, deepen our knowledge of our audience, and measure the impact of our work.Key Responsibilities:Embed Data...

  • Microsoft Support Consultant

    2 months ago

    York, York City, United Kingdom Simpson Associates Full time

    About Simpson AssociatesWe are a leading provider of data and performance management solutions, helping organizations understand and resolve complex challenges. Our team is passionate about leveraging data to drive business success.Job SummaryWe are seeking a highly skilled Microsoft Support Consultant to join our team. As a key contact for supported...

  • Microsoft Support Consultant

    2 months ago

    York, York City, United Kingdom Simpson Associates Full time

    About Simpson AssociatesWe are a leading provider of data and performance management solutions, helping organizations understand and resolve complex challenges. Our team is passionate about leveraging data to drive business success.Job SummaryWe are seeking a highly skilled Microsoft Support Consultant to join our team. As a key contact for supported...