Data Engineer II

Data Engineer II

Overview
The Operational Insights Analyst II role within the Program Controls, Operations & Modernization (ProCOM) Office establishes and strengthens a scalable "risk intelligence layer" across incident management and operational governance. This role transforms operational data into actionable intelligence that improves situational awareness, control effectiveness, and leadership decision-making. Leveraging proficienty expertise in data engineering, data management, and operational analytics, the role independently develops and maintains data solutions that aggregate, process, and analyze operational data across multiple systems. The position identifies patterns, trends, and emerging risks, translating operational signals into meaningful business insights that support proactive risk management and continuous improvement across products and platforms. This role serves as a key contributor to the evolution of ProCOM's operational intelligence capabilities by improving data reliability, expanding analytical insight, and enabling scalable reporting and risk-monitoring solutions.

• Analyze operational incidents, service disruptions, and risk events to identify trends, recurring failure patterns, and systemic control gaps across products, platforms, and regions.


• Develop executive-ready intelligence briefings and dashboards that communicate operational health, customer impact, financial exposure, and emerging risk trends.


• Independently investigate operational issues and partner with incident owners, engineering teams, and stakeholders to validate information, assess impacts, and identify escalation risks.


• Translate operational data into actionable risk and control insights by evaluating control effectiveness and recommending opportunities for process improvement.


• Develop and maintain data pipelines, workflows, and analytical solutions that support reliable data availability, quality, and operational reporting.


• Design, test, and optimize components of distributed data processing solutions to improve scalability, efficiency, and reliability.


• Build and manage data integration processes that consolidate information from multiple sources into a unified operational intelligence view.


• Contribute to the development and maintenance of data lake environments and analytical data structures supporting risk monitoring and operational decision-making.


• Apply data modeling and database design principles to structure data for efficient storage, retrieval, and analysis.


• Drive workflow orchestration and process automation initiatives that improve operational efficiency and reduce manual effort across intelligence and reporting activities.


• Troubleshoot and resolve routine to moderately complex data processing, workflow, and reporting issues through root cause analysis and implementation of sustainable solutions.


• Develop recurring risk narratives, trend analyses, and operational performance reporting to support leadership reviews and governance forums.


• Ensure compliance with data governance, security, and operational standards while safeguarding the confidentiality, integrity, and availability of operational data.


• Document technical solutions, analytical methodologies, operational processes, and best practices to support knowledge sharing and maintainability.


• Provide technical input on solution design, feasibility, operational risks, and data requirements during project planning and review activities.


• Identify opportunities to improve operational intelligence capabilities through process optimization, automation, enhanced reporting, and adoption of emerging technologies.

• Strong analytical and problem-solving skills with the ability to independently evaluate operational issues, identify risk patterns, and recommend corrective actions.


• Proven ability to transform large and complex datasets into actionable business insights and executive-level recommendations.


• Proficient in data engineering concepts, including:


• Data pipelines (ingestion, transformation, storage)


• Data processing and distributed systems


• Data integration and data management


• Data lake architecture and utilization


• Workflow orchestration and workflow management


• Data modeling and database design


• Database architecture and administration fundamentals


• Data security, governance, and operational controls


• Ability to design, develop, and maintain scalable data solutions supporting operational analytics, risk intelligence, and reporting.


• Experience identifying data quality issues, troubleshooting operational data challenges, and implementing sustainable improvements.


• Ability to evaluate current workflows and recommend process improvements that increase efficiency, scalability, and reliability.


• Strong written and verbal communication skills with the ability to clearly communicate technical concepts and operational insights to both technical and non-technical audiences.


• Experience developing dashboards, trend analysis, performance reporting, and executive-ready presentations.


• Demonstrated ability to work independently on moderately complex assignments while collaborating effectively across teams and stakeholder groups.


• Strong organizational and documentation skills with a focus on accuracy, repeatability, and continuous improvement.


• Curiosity and a proactive mindset with the ability to navigate ambiguity and identify opportunities for innovation and operational enhancement.


• Ability to quickly learn new technologies, analytical tools, and business processes within a fast-paced environment.

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.

O'Fallon, Missouri: $92,000 - $147,000 USD