Data Engineering and Reporting Lead

Company:

Guy Carpenter

Description:

We are seeking a talented individual to join our Data Engineering and Reporting team at Guy Carpenter. This role will be based in the New York City office. This is a hybrid role that has a requirement of working at least three days a week in the office. As a Data Engineering and Reporting Lead, you will play a critical role in implementing the target data architecture for the organization and will interact with cross-functional teams to ensure the highest quality and efficiency of data.

We will count on you to:

• Lead the data engineering and reporting to migrate our on-premise data assets to the Azure cloud.
• Lead the technology activities to enable the delivery of meaningful, data-driven capabilities in alignment with business strategies, optimizing data solutions for scalability, security, and performance.
• Develop, implement, and deploy data products using Azure Databricks and Power BI to support business intelligence dashboards, reporting, and analytical needs of the organization.
• Collaborate with stakeholders to design and implement scalable and maintainable data models while ensuring adherence to data governance and compliance standards.

What you need to have:

• Bachelor's or Master's degree in Computer Science, Engineering, or a related field.
• 10+ years in the data and analytics space with extensive experience delivering enhanced data and analytics capabilities.
• 5+ years of experience in the reinsurance domain.
• 8+ years of hands-on experience designing and implementing data consumption solutions using Azure cloud offerings including ADLS, Azure Databricks, Azure Synapse, and Power BI.
• Expertise in advanced SQL, preferably using DBT or similar tools, and experience in data modeling for reporting and analytics.

What makes you stand out:

• Experience with Python, Spark, and JSON.
• Knowledge of information and cloud security.

Why join our team:

• We help you be your best through professional development opportunities, interesting work, and supportive leaders.
• We foster a vibrant and inclusive culture where you can work with talented colleagues to create new solutions and have an impact for colleagues, clients, and communities.
• Our scale enables us to provide a range of career opportunities, as well as benefits and rewards to enhance your well-being.

Marsh McLennan (NYSE: MMC) is a global leader in risk, strategy and people, advising clients in 130 countries across four businesses: Marsh, Guy Carpenter, Mercer and Oliver Wyman. With annual revenue of $23 billion and more than 85,000 colleagues, Marsh McLennan helps build the confidence to thrive through the power of perspective. For more information, visit marshmclennan.com, or follow 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, 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. If you have a need that requires accommodation, please let us know by contacting reasonableaccommodations@mmc.com.

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.

The applicable base salary range for this role is $136,200 to $272,400.

The base pay offered will be determined on factors such as experience, skills, training, location, certifications, education, and any applicable minimum wage requirements. Decisions will be determined on a case-by-case basis. In addition to the base salary, this position may be eligible for performance-based incentives.

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.

Apply