Senior Specialist - Data Engineering

    • Marsh & McLennan Companies
  • New York, NY
  • Posted 25 days ago | Updated 16 hours ago


On Site
USD 163,238.00 - 182,300.00 per year
Full Time


Business intelligence
Data engineering
Shared services
Machine Learning (ML)
Data collection
Cloud storage
Data Lake
Quality assurance
Meta-data management
Integration testing
Data Analysis
Computer science
Information systems
Electronic engineering
Microsoft Azure
Informatica PowerCenter
Microsoft Power BI
Revenue management
Software design
Data marts
User stories
Business process
Professional services
Microsoft Excel
Computerized system validation
Apache Parquet
Records management
Cloud computing
Control management
Software deployment

Job Details

Marsh & McLennan Shared Services LLC is seeking candidates for the following position based in the New York, New York office (Remote work may be permitted within a commutable distance from the worksite):

Senior Specialist - Data Engineering

We will count on you to:

Develop, implement, and deploy custom data pipelines powering machine learning algorithms, insights generation, client benchmarking tools, business intelligence dashboards, reporting and new data products. Increase the efficiency of data collection and analysis processes and drive the monetization of that data through existing and new products for clients. Leverage multiple large datasets to drive revenues via the development of new products with the Data Strategy team, as well as the enhanced delivery of existing products. Consume data from a variety of sources (relational DBs, APIs, NetApp and other cloud storage, FTPs) & formats (Excel, Csv, xml, parquet, unstructured). Construct and maintain data pipelines between internal/external sources and the data lake utilizing modern ETL frameworks. Own the role of data steward for one or more datasets and implement innovative quality assurance practices, including automated validation with frameworks like dbt or Great Expectations. Implements metadata management capabilities, including lineage mapping. Participate in development standards across the team through code reviews, unit/integration testing, and monitoring. Perform basic exploratory data analysis to create & validate requirements for data pipelines.

What you need to have:

Requires a Bachelor's degree, or foreign equivalent, in Computer Science, Information Systems, Electronic Engineering or a related field, and seven (7) years of progressive, post-baccalaureate experience in the job offered, as a Programmer Analyst, IT Analyst, or in a related occupation. Seven (7) years of experience must include: Collaborating with business users, product managers and data scientists to gather requirements for new product developments and existing product enhancements; Performing analysis of requirements to identify risks, increase the efficiency of data collection and drive the monetization of that data through existing and new products; Developing custom data pipelines powering machine learning algorithms using business intelligence tools including Microsoft Azure data factory, Microsoft Azure data bricks, and Informatica PowerCenter; Implementing client benchmarking tools, insights generation, business intelligence dashboards, reporting and new data products using OBIEE, Power BI and Oracle Data bases; Designing, developing and performing customization of revenue management and billing (RM&B) for on premise and cloud applications; Designing and developing the headcount data mart based on workday source (HCDM) for reporting requirements using Informatica and OBIEE; Responsible for Version Controlling, maintaining the user stories and deployment of the code to different environments using JIRA; Automating the business process using programing languages including Python and Unix Scripting; Participating in development standards across the team through code reviews, unit/integration testing, and monitoring; and implementing metadata management capabilities, including lineage mapping.

Marsh McLennan (NYSE: MMC) is the world's leading professional services firm in the areas of risk, strategy and people. The Company's more than 85,000 colleagues advise clients in over 130 countries. With annual revenue of $23 billion, Marsh McLennan helps clients navigate an increasingly dynamic and complex environment through four market-leading businesses. Marsh provides data-driven risk advisory services and insurance solutions to commercial and consumer clients. Guy Carpenter develops advanced risk, reinsurance and capital strategies that help clients grow profitably and pursue emerging opportunities. Mercer delivers advice and technology-driven solutions that help organizations redefine the world of work, reshape retirement and investment outcomes, and unlock health and well being for a changing workforce. Oliver Wyman serves as a critical strategic, economic and brand advisor to private sector and governmental clients. For more information, visit, or 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, 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

The applicable base salary range for this role is $163,238.00 - $182,300.00 per year.

The base pay offered will be determined on factors such as experience, skills, training, location, certifications, and education. 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.