Lead Data Engineer

Location: O'Fallon, Missouri

Time Type: Full time

Job Description

Our Purpose

Mastercard powers economies and empowers people in 200+ countries and territories worldwide. Together with our customers, we’re helping build a sustainable economy where everyone can prosper. We support a wide range of digital payments choices, making transactions secure, simple, smart and accessible. Our technology and innovation, partnerships and networks combine to deliver a unique set of products and services that help people, businesses and governments realize their greatest potential.

Title and Summary

Lead Data Engineer

At Mastercard, we’re shaping the future of data integrity and trust to empower organization wide Data and Analytics platforms. We are looking for a hands-on Data Engineer with strong software engineering skills to design and implement scalable, cloud-based solutions that ensure the accuracy, consistency, and reliability of our data pipelines. This role is highly technical—about 70% coding—and will evolve to lead AI-driven data processing initiatives.
If you’re passionate about building robust data systems, working with cutting-edge technologies like Databricks, PySpark, and AWS, and want to make a global impact, we’d love to hear from you.

What You’ll Do
Develop & Optimize: Build and maintain data processing and data quality frameworks using PySpark, Databricks, and Python.
Design & Deploy: Architect and implement ETL/ELT pipelines leveraging AWS services (S3, Glue, Lambda, Redshift) and streaming data solutions.
Monitor & Automate: Implement data quality checks, anomaly detection, and workflow orchestration using Apache Airflow, AWS Step Functions, and Unix shell scripting.
Collaborate: Work closely with data engineers, scientists, and business stakeholders to define standards and resolve data issues.
Lead & Mentor: Provide technical guidance to junior engineers and contribute to best practices across the team.
Future Focus: Drive adoption of AI-based tools for anomaly detection and predictive data quality improvements.

What We’re Looking For
Required Skills & Experience
Strong software engineering background with experience in data engineering roles.
Proficiency in:
PySpark, Databricks, and Python for pipeline development.
AWS cloud services (S3, Glue, Lambda, Redshift).
Working experience of Graph databases and G-Sql.
Workflow orchestration tools (Apache Airflow, AWS Step Functions).
Advanced SQL for validation and reconciliation.
Ability to design and deploy solutions for streaming and batch data.
Excellent problem-solving and communication skills.

Nice-to-Have
Experience with AI/ML-based anomaly detection.
Exposure to CI/CD pipelines and DevOps practices.
Exposure to master data management platform
Knowledge of Scala or advanced Python.

Why join us?
Work on global-scale data systems impacting millions of transactions daily.
Be part of a forward-thinking team embracing AI and next-gen data technologies.
Opportunities for career growth and continuous learning.

Mastercard is a merit-based, inclusive, equal opportunity employer that considers applicants without regard to gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law. We hire the most qualified candidate for the role. In the US or Canada, if you require accommodations or assistance to complete the online application process or during the recruitment process, please contact [email protected] and identify the type of accommodation or assistance you are requesting. Do not include any medical or health information in this email. The Reasonable Accommodations team will respond to your email promptly.

Corporate Security Responsibility

All activities involving access to Mastercard assets, information, and networks comes with an inherent risk to the organization and, therefore, it is expected that every person working for, or on behalf of, Mastercard is responsible for information security and must:

• Abide by Mastercard’s security policies and practices;

• Ensure the confidentiality and integrity of the information being accessed;

• Report any suspected information security violation or breach, and

• Complete all periodic mandatory security trainings in accordance with Mastercard’s guidelines.

In line with Mastercard’s total compensation philosophy and assuming that the job will be performed in the US, the successful candidate will be offered a competitive base salary and may be eligible for an annual bonus or commissions depending on the role. The base salary offered may vary depending on multiple factors, including but not limited to location, job-related knowledge, skills, and experience. Mastercard benefits for full time (and certain part time) employees generally include: insurance (including medical, prescription drug, dental, vision, disability, life insurance); flexible spending account and health savings account; paid leaves (including 16 weeks of new parent leave and up to 20 days of bereavement leave); 80 hours of Paid Sick and Safe Time, 25 days of vacation time and 5 personal days, pro-rated based on date of hire; 10 annual paid U.S. observed holidays; 401k with a best-in-class company match; deferred compensation for eligible roles; fitness reimbursement or on-site fitness facilities; eligibility for tuition reimbursement; and many more. Mastercard benefits for interns generally include: 56 hours of Paid Sick and Safe Time; jury duty leave; and on-site fitness facilities in some locations.

Pay Ranges

O'Fallon, Missouri: $140,000 - $231,000 USD