Data Engineer II

Mastercard•O'fallon, MO

5d•$92,000 - $147,000•Onsite

About The Position

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.

Requirements

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.

Responsibilities

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.

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