ETL Data Engineering Lead

    • Marsh & McLennan Companies
  • Westlake, TX
  • Posted 27 days ago | Updated 14 hours ago

Overview

On Site
USD 133,800.00 - 267,500.00 per year
Full Time

Skills

Extract
transform
load
Data engineering
Data integration
Life insurance
Business requirements
Data extraction
Data profiling
Data cleansing
Data quality
Data processing
Access control
Data masking
Technical Support
Disaster recovery
Knowledge sharing
System documentation
Computer science
Data structure
Design architecture
Programming languages
IBM InfoSphere DataStage
Microsoft SSIS
Apache NiFi
Apache Airflow
Google Cloud Platform
Data validation
Data governance
Problem solving
Analytical skill
Professional services
Professional development
Leadership
Expect
Talend
Databricks
Data
Management
Design
Analytics
Collaboration
Brand
Partnership
Mentorship
Taxes
Specification
Workflow
Transformation
Scripting
Scalability
IMPACT
Administration
Encryption
Backup administration
Governance
Python
Java
Scala
Automation
Informatica
Cloud computing
Amazon Web Services
Microsoft Azure
MMC
Strategy
Insurance
Reinsurance
LinkedIn
AIM
Law
Training
SAP BASIS

Job Details

Marsh McLennan LLC is seeking candidates for the following position based either in the Westlake Texas or New York City office. This role is an onsite position.

ETL Data Engineering Lead

What can you expect?
  • We are seeking a highly skilled and experienced Data Engineering Lead specializing in ETL (Extract, Transform, Load) processes using Qlik Talend Data Integration, and Databricks.
  • As the Data Engineering Lead, you will be responsible for leading a team of data engineers and overseeing the design, development, and implementation of ETL solutions to support our organization's data integration and analytics initiatives.
  • You will collaborate closely with cross-functional teams, including data scientists, business analysts, and software engineers, to ensure the successful delivery of high-quality data solutions.

What is in it for you?
  • A company with a strong Brand and strong results to match
  • Culture of internal mobility, collaboration and valued partnership from the business.
  • Employee Resource Groups which provide access to leaders, relevant volunteer and mentoring opportunities and interactions with counterparts in industry groups and client organizations.
  • Competitive pay (salary and bonus potential), Full benefits package - starting day one (medical, dental, vision, STD/LTD, life insurance, RSP (Retirement Savings Plan or TFSA (tax free savings account.)
  • Tuition Reimbursement plan and participation in our Employee Stock Purchase Plan
  • Entitled to vacation, floating holidays, time off to give back to your community, sick days, and national holidays (with early dismissal).


We will count on you to:

Architect, Design, and development of Data Pipelines
  • Lead a team of data engineers in the design, development, and implementation of ETL processes using Qlik, Talend, and Databricks.
  • Collaborate with stakeholders to understand business requirements and translate them into technical specifications for ETL workflows.
  • Design and optimize data models, data pipelines, and data integration processes to ensure efficient and reliable data extraction, transformation, and loading.
  • Develop and maintain ETL workflows, scripts, and jobs using Qlik, Talend, and Databricks.
  • Perform data profiling, data cleansing, and data quality checks to ensure data accuracy and integrity.
  • Monitor and troubleshoot ETL processes to identify and resolve issues in a timely manner.
  • Implement best practices and standards for data engineering, ensuring scalability, performance, and maintainability of ETL solutions.
  • Stay up to date with the latest trends and technologies in data engineering and ETL tools and evaluate their potential impact on our data infrastructure.
  • Provide technical guidance and mentorship to junior data engineers, fostering a culture of continuous learning and professional growth.


Platform administration - As the Data Platform Administrator, you will be responsible for the administration, configuration, and maintenance of our data platform, ensuring its optimal performance, reliability, and security.

  • Administer and maintain the Qlik Talend data platforms, including installation, configuration, and upgrades.
  • Monitor and optimize the performance of the data platform, ensuring efficient data processing and query execution.
  • Implement and enforce security measures to protect sensitive data, including user access controls, data encryption, and data masking.
  • Troubleshoot and resolve issues related to the data platform, working closely with technical support teams and vendors.
  • Collaborate with data engineers to design and implement data integration workflows using Qlik Talend and Databricks.
  • Perform regular backups and disaster recovery procedures to ensure data availability and integrity.
  • Monitor system logs and alerts to proactively identify and address potential issues or bottlenecks.
  • Stay up to date with the latest features and enhancements of Qlik and Talend and evaluate their potential impact on our data platform.
  • Provide technical guidance and support to end-users, assisting them with data platform-related queries and issues.
  • Collaborate with cross-functional teams to understand their data requirements and provide recommendations for data platform improvements.
  • Document system configurations, processes, and procedures to ensure knowledge sharing and maintain system documentation.


What you need to have:
  • University Degree - BS in Computer Science or Engineering.
  • Over 10 years of relevant work experience in Data integration ETL development, Data structure Design, Architecture and Governance.
  • Programming Languages: Knowledge of programming languages such as Python, Java, or Scala can be advantageous for scripting, automation, and custom ETL development.
  • ETL Tools: Proficiency in using popular ETL tools such as Informatica, Talend, IBM DataStage, or Microsoft SSIS. Experience with other tools like Qlik, Apache NiFi, or Apache Airflow may also be beneficial.
  • Cloud Platforms: Experience with cloud-based data platforms like AWS, Azure, or Google Cloud can be advantageous, as organizations increasingly adopt cloud-based data integration solutions.
  • Data Quality and Governance: Understanding of data quality principles and experience with data profiling, data cleansing, and data validation techniques. Knowledge of data governance frameworks and practices is desirable.
  • Problem-Solving and Analytical Skills: Strong problem-solving abilities and analytical thinking are crucial for troubleshooting ETL issues, optimizing performance, and ensuring data accuracy


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 marshmclennan.com, 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

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 $133,800 to $267,500.

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.