Data Architecture Market Risk Lead

Our client, a major bank in New York City, is looking for Data Architecture & Engineering Lead - Market Risk Technology.

New York City Location.

This is hybrid commute, 5 days per 2 weeks in the office.

Salary range 200-240K, plus around 20% bonus, plus great benefits package.

Data Architecture & Engineering Lead — Market Risk Technology

As the leader of data architecture and engineering for bank's Market Risk technology platform, you will oversee the end-to-end design, deployment, and operations of critical data solutions supporting VaR, FRTB, sensitivities, stress testing, limits, and regulatory reporting.

Your accountability spans the platform’s architectural vision, engineering frameworks, and the operational outcomes delivered to Risk, Finance, and Front Office stakeholders.

The platform is currently undergoing a migration from SSIS/SQL Server to Databricks and Delta Lake. You will be responsible for setting the target architecture, driving this migration to completion, and ensuring the stability of the legacy estate until it is fully decommissioned.

Role

• Data Architecture: Oversee the platform’s data architecture, including transactional and analytical stores, Lakehouse implementation, semantic layers, and reporting models. Establish scalable standards that apply across teams rather than bespoke designs for individual projects.
• Engineering Frameworks & Patterns: Develop and enforce reusable libraries and frameworks for data ingestion, quality, reconciliation, lineage, orchestration, error handling, and recovery. Ensure these are built once and adopted broadly across the organization.
• Migration Leadership: Lead the SSIS-to-Databricks migration program, including sequencing, parallel-run reconciliation, cutover, decommissioning, and operational handover at each step.
• Risk Data Models: Design canonical and semantically clear data models for trades, positions, sensitivities, P&L, market data, VaR, stress, limits, capital, and regulatory reporting. Ensure models are fit for the consumers who rely on them.
• Performance & Scale: Optimize SQL and Spark workloads, partitioning, storage design, and query performance to meet stringent EOD SLAs.
• Data Observability: Integrate quality assurance, SLA tracking, pipeline health, reconciliation, anomaly detection, and lineage as core platform capabilities, not afterthoughts.
• Full Lifecycle Ownership: Guide the platform from design through deployment and ongoing operations. While production support handles daily operations, you own the engineering discipline that underpins their success.
• Stakeholder Partnership: Collaborate closely with risk managers, quants, application owners, engineers, support teams, infrastructure, and governance to ensure alignment and platform excellence.

Required Experience

• 15+ years in data architecture, engineering, or platform roles within financial services.
• Hands-on expertise in Market Risk data domains including trades, positions, sensitivities, P&L, market data, VaR, stress, FRTB, capital, and regulatory reporting, with the depth to model the domain, not just describe it.
• Proven experience designing and operating modern data platforms including lakehouse, distributed compute, semantic layers, and hybrid on-prem/cloud environments.
• Production experience with Databricks, Spark, and Delta Lake, plus working knowledge of SQL Server and SSIS to credibly lead migration.
• Expertise in data modeling for operational, dimensional, semantic, and canonical models.
• Demonstrated leadership of large ETL modernization initiatives, including sequencing, parallel-run, cutover, and decommissioning.
• Track record of building reusable engineering frameworks adopted across teams.
• Experience in performance tuning at scale for SQL Server, Databricks, Spark, storage formats, and query optimization.
• Architectural leadership: setting direction, reviewing designs, challenging weak patterns, and mentoring engineers and architects.
• Strong communication skills, capable of defending architectural decisions to senior technology, risk, and business leaders.

Please email your resume or use this link to apply directly:

https://brainsworkgroup.catsone.com/careers/index.php?m=portal&a=details&jobOrderID=16836231

Or email: igork@brainsworkgroup.com

Check ALL our Jobs: http://brainsworkgroup.catsone.com/careers

Keywords: lead director manager VP architect engineer data lake lakehouse SQL SSIS databricks spark ETL Risk VaR FRTB Stress bank finance financial

Skills

Analysis Skills, Architectural Engineering, Architectural Services, Channel Support, Cloud Computing, Communication Skills, Data Lake, Data Modeling, Database Extract Transform and Load (ETL), Error Handling, Error Recovery, Finance, Financial Services, Leadership, Mentoring, Microsoft SQL Server, Operations, Performance Tuning/Optimization, Production Support, Profit & Loss, Quality Assurance, Query Optimization, Reconciliation, Regulatory Reports, Risk, Risk Management, Risk Modeling, SQL (Structured Query Language), SQL Server Integration Services (SSIS), Service Level Agreement (SLA), Software Engineering, Stress Testing, Value At Risk (VaR)

About the Company

Brains Workgroup, Inc.