Data Integration Engineer VP (CCR, Python, Data Bricks) - F2F in NYC

Role: Data Integration Engineer VP (Counterparty Credit Risk)

Exp: 12+ yrs

Location: NYC (Onsite)

Note: Final Round In-Person in NYC

Major Responsibilities:

Data Engineering & Integration

• Design, develop, maintain and optimize scalable data pipelines to ingest, transform, and integrate counterparty, trade, collateral and market data from upstream systems (Systems Of Record) for CCR exposure analytics (e.g., EPE, PFE, sensitivities).
• Implement robust ETL/ELT solutions for structured and semistructured data across batch and streaming processes using enterprise data platforms (e.g., data lakes, data warehouses, and distributed processing frameworks).
• Support integration of trading and derivatives data (e.g., exposures, collateral, netting, margin) into CCR calculation and reporting platforms.

Counterparty Credit Risk Support

• Partner with EM and CRR users and business analysts to understand business requirements related to exposure, PFE, and stress testing.
• Enable accurate, consistent, validated CCR data for EPE/PFE calculations, limit monitoring, whatif pre-trade intraday analysis, and regulatory and HO
• Deliver timely enhancements to ETL pipelines, CCR data models, data lineage, and controls aligned with the EM users and regulatory expectations (e.g., Basel regulations).

Data Quality, Controls & Governance

• Implement data quality checks, reconciliations, and monitoring to ensure completeness, accuracy, and timeliness of CCR data (Data governance and compliance).
• Proactively identify and execute opportunities for process standardization/optimization, tooling enhancements, and operational simplification across the CCR application stack.
• Lead by example in technical documentation, knowledge transfer, implementation standards, data management, and control frameworks, reducing dependency on key individuals and ensuring service quality, productivity, and continuous skill

Incident, Problem & Change Management

• Proactively investigate, identify root cause of recurring incidents, and resolve data issues across upstream and downstream systems, working with IT and business stakeholders.
• Demonstrate a continuous improvement mindset through their example, with a focus on reducing incidents, manual interventions, and operational risk, and improving turnaround time for incidents.
• Drive root cause analysis (RCA) for impactful incidents (Calculation breaks, data validation/reconciliation issues), ensuring recurring issues are eliminated through permanent fixes rather than shortterm workarounds.
• Enforce robust change and release governance aligned with Mizuho Americas CAB, DevOps, CI/CD, risk, audit, and control standards, eliminating production release incidents and continuously enhancing release processes to mitigate the risk.

Platform Reliability, Automation & Resilience

• Champion automation and selfhealing for batch monitoring, data validation, reconciliations, and recovery processes for production as well as lower testing environments.
• Partner with BAU Ops and Infrastructure teams to improve data transparency, and observability, alerting, capacity planning, and resilience of CCR platforms.
• Ensure DR/BCP readiness for EMcritical systems, including regular/annual testing and documented recovery procedures.

Collaboration & Delivery

• Work closely with EM and CRR users, Business Analysts, Risk Analytics, and Technology teams to deliver endtoend data solutions.
• Take initiative and come up with enhancement proposals and lead platform migrations, and strategic data initiatives.
• Support audit, regulatory, and adhoc data requests related to counterparty credit risk.

Required Qualifications:

Experience:

• Bachelor s Degree in Computer Science, Management of Information Systems, or related business discipline(s).
• 10+ years of strong programming experience in Python and advanced SQL, with a focus on data transformation and analytics.
• 5+ years of experience in data engineering, data integration, or enterprise data management within financial services.
• 3+ years in a VPlevel or equivalent senior role supporting risk or exposure platforms.
• 3+ years of handson experience with Databricks and PySpark for large scale ETL and data integration.
• Demonstrated experience operating global, offshoreleveraged support models in a regulated environment.

Technical & Domain Expertise

• Proficient understanding of Exposure Management and Counterparty Credit Risk concepts, including derivative trade cycles, market data, EPE, PFE, netting, Collateral/margin management, limits, stress testing, and whatif analysis.
• Experience supporting batchintensive and intraday realtime risk platforms (Python, PySpark, ETL, Tidal, Stored Procedure, SQL, Snowflake, PowerBI).
• Demonstrated experience designing and managing Databricks, Medallion Architecture, Unity Catalog, Workflows/Orchestration, including complex DAGs and dependencies (Exposure to Astronomer/Airflow is a plus).
• Hands-on experience with Cloud computing and infrastructure (Azure, Data Lake, ADF, Kafka, Spark based distributed compute, other Cloud native technologies).
• Experience implementing CI/CD pipelines using Jenkins, GitLab CI, or Azure DevOps in a data engineering environment.
• Familiarity with regulatory risk data principles and expectations for banking institutions (e.g., aggregation, reconciliation, and auditability of risk data).
• Proven track record taking initiative and driving a technological transformation project with an Agile based application/software development.
• Proven ability to utilize JIRA, Confluence to manage tasks, technical documentation, production incidents, and releases.

Leadership & Soft Skills

• Demonstrated continuous improvement mindset, with the ability to drive cultural change across the engineering team.
• Strong experience collaborating with distributed, multicultural global teams and thirdparty vendors.
• Excellent interpersonal, written and verbal communication skills with the ability to work with both technical and nontechnical stakeholders, and senior Technology team leads.
• Ability to prioritize and effectively manage multiple tasks under time-critical and regulatory pressure.
• Highly motivated, self-directed individual with the ability to work independently and in team environments.
• Effective presenter capable of articulating high level concepts to strategic execution plans including system/architecture/data flow diagrams, combined with extreme attention to detail.
• Strong analytical, problem solving (breaking ambiguolarge problems to smaller/less complex ones), and decision-making skills.
• Collaborative team player and relationship builder.

Regards,

Prakash

732-9 3 4-4169

prakash.v(@)smg(-)llc(.)us