Data Architect Job at Openkyber, Pennsylvania

  • Openkyber
  • Pennsylvania

Job Description

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 u se this link to apply directly: brainsworkgroup.catsone.com/careers/index.php?m=portal&a=details&jobOrderID=16836231 Or email: hirings@openkyber.com Check ALL our Jobs: 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

For applications and inquiries, contact:hirings@openkyber.com

Job Tags

Work at office

Similar Jobs

Growing Up Green Charter School

Elementary General Education Teacher- Leave Replacement Job at Growing Up Green Charter School

 ...General Education Elementary Teacher - Leave Replacement Mission Statement: The Growing Up Green Charter School (GUGCS) supports children to be conscious, contributing members of their community through a rigorous, anti-racist, anti-bias, curriculum and engaging... 

Freeport McMoRan

Senior Supervisor Haulage/Crush and Convey Job at Freeport McMoRan

At Climax Molybdenum, we are committed to providing an employment package that recognizes excellence, encourages safe production and a culture supported by our core values. Here, youll find a collaborative environment where safety is a top priority, all opinions are valued...

Overhaul Carriers

Local Truck Driver Home Daily CDL Class A 1300 per week Job at Overhaul Carriers

 ...Position. Overhaul Carriers Ltd. , CDL Class A Intermodal/Containers home daily position. Experience Drivers: Over the Road or Regional experience drivers. Compensation: $1100 to $1300 per week and miles per week 1000. Home Daily : Sun to Thurs or Tues to... 

Wynn Las Vegas

Front Desk - Medical Assistant Job at Wynn Las Vegas

 ...Maintain accurate patient demographic, medical, consent, and appointment information within...  ...Other job duties as assigned Medical Assistant & Clinical Support Assist the Medical...  ...of experience in medical aesthetics, dermatology, plastic surgery, cosmetic medicine, or... 

Hastings Ford, Inc

RECEPTIONIST / FILE CLERK Job at Hastings Ford, Inc

Monday-Friday | No Weekends | Full-Time | Entry LevelLooking for a stable, Monday-Friday position where you can learn new skills and build...  ...messages to the appropriate team members* Assist with basic office and clerical duties* Organize, file, and maintain customer...