Data Engineer II

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.

Data Engineer II Overview:
Mastercard’s Enterprise Credit Risk (ECR) team is seeking a Data Engineer II to design, build, and maintain data platforms and products that support credit decisioning, risk analytics, regulatory reporting, and machine learning initiatives. In this role, you will work with large and complex datasets to develop scalable, reliable, and high-quality data solutions. You will collaborate with engineers, data scientists, risk analytics, and product partners to translate business needs into effective data products and pipelines.

This is an opportunity for an engineer to deepen their data engineering expertise while contributing to modern cloud-based platforms and ECR's ongoing data modernization efforts.

This is a hybrid role based in O’Fallon, MO, requiring three days per week onsite.

• Design, develop, test, and maintain scalable data pipelines, transformations, and datasets supporting ECR products and initiatives.
• Build and optimize ETL/ELT workflows using technologies such as SQL, Python, Databricks, and Spark.
• Develop and maintain curated data products that support reporting, analytics, credit decisioning, and other business use cases.
• Partner with Product, Risk Analytics, Data Science, and Engineering teams to understand requirements and translate them into effective technical solutions.
• Implement data validation, testing, and quality controls to ensure data accuracy, consistency, and reliability.
• Support the deployment, monitoring, and ongoing operation of production data pipelines and workflows.
• Investigate and troubleshoot data and pipeline issues, contributing to root cause analysis and resolution.
• Participate in code reviews and follow established engineering standards, best practices, and development processes.
• Contribute to the modernization of data platforms, including cloud migration and adoption of modern data engineering technologies.
• Document data solutions, pipelines, data flows, and operational processes.
• Identify opportunities to improve the performance, reliability, scalability, and efficiency of data solutions.

• Experience as a Data Engineer or in a similar technical role, with a solid understanding of core data engineering concepts, methodologies, and best practices.
• Experience designing, building, and maintaining ETL/ELT pipelines and data transformations.
• Strong SQL skills, including the ability to write and optimize queries to retrieve, transform, and analyze large datasets efficiently.
• Experience with Python or another programming language used for data processing and automation.
• Experience working with relational databases, including Postgress, and an understanding of data modeling and database design.
• Familiarity with cloud-based data platforms and modern data engineering technologies.
• Familiarity with distributed data processing technologies such as Databricks, Apache Spark, or comparable platforms.
• Understanding of data testing, validation, and quality practices to ensure accuracy and consistency across data pipelines.
• Strong analytical and problem-solving skills, with the ability to troubleshoot complex data issues and develop effective solutions.
• Ability to manage multiple tasks and priorities while working effectively in…