Data Engineer II
About The Position
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.
Requirements
- 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 a fast-paced environment.
- Ability to work independently while collaborating effectively across cross-functional and Agile teams.
- A continuous improvement mindset, with the ability to think critically, innovate, and identify opportunities to enhance data solutions.
- Strong verbal and written communication skills, with the ability to clearly communicate technical concepts to both technical and non-technical stakeholders.
- Bachelor’s degree in Computer Science, Engineering, Information Systems, or a related STEM discipline. Equivalent practical experience will also be considered.
Responsibilities
- 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.
Benefits
- insurance (including medical, prescription drug, dental, vision, disability, life insurance)
- flexible spending account and health savings account
- 16 weeks of new parent leave
- up to 20 days of bereavement leave
- 80 hours of Paid Sick and Safe Time
- 25 days of vacation time
- 5 personal days
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
