Deep expertise in Databricks architecture, including Delta Lake (versioning and time‑travel), Unity Catalog (RBAC and lineage), Workflows, and Spark / PySpark optimization.
Proven experience in regulatory data management and governance aligned with BCBS 239, with emphasis on accuracy, completeness, and adaptability.
Strong experience designing front‑to‑back data lineage and controls across trading, operations, and finance systems.
Ability to design deterministic, explainable, testable, and scalable reconciliation and data quality rules.
Experience supporting Broker‑Dealer regulatory reporting under heightened supervisory expectations (e.g. Federal Reserve, OCC).
Strong stakeholder leadership across Risk & Compliance, Data Office, IT / DevOps, and Business Line Owners.
Equal Opportunity & Compliance
Position Level
Senior Associate
Country
United Kingdom
Additional Information
Huron is redefining what a global consulting organization can be. Advancing new ideas every day to build even stronger clients, individuals and communities. We're helping our clients find new ways to drive growth, enhance business performance and sustain leadership in the markets they serve. And, we're developing strategies and implementing solutions that enable the transformative change they need to own their future.
As a member of the Huron corporate team, you'll help to evolve our business model to stay ahead of market forces, industry trends and client needs. Our accounting, finance, human resources, IT, legal, marketing and facilities management professionals work collaboratively to support Huron's collective strategies and enable real transformation to produce sustainable business results.
Join our team and create your future.
The Senior Technical Analyst will lead the design and delivery of a regulatory‑grade data foundation supporting Broker‑Dealer and CUSO reporting obligations. The role focuses on establishing a governed Data‑to‑Capital value chain that reduces data opacity, enables regulator‑defensible reporting, and delivers audit‑ready lineage, reconciliation, and controls across capital, liquidity, and market activities.
The Analyst will design and implement a Databricks Medallion Architecture (Bronze / Silver / Gold) to create a trusted Golden Source, supporting requirements such as Reg YY, 2052a (5G), Basel III Endgame / SA‑CCR, and BCBS 239, while enabling explainable, governed use of AI for anomaly detection and remediation.
Key Job Duties
Define the target‑state architecture for a regulatory‑grade CUSO Data Fabric using Databricks (Delta Lake, Unity Catalog, Workflows).
Design and implement pipelines:
Raw ingestion with full lineage preservation
Validated and reconciled datasets with T+1 controls
Curated regulatory data marts for Reg YY, 2052a, capital/RWA, and management analytics
Build end‑to‑end lineage, metadata standards, and audit evidence outputs so every reported figure is traceable to raw source data and transformation logic.
Engineer explainable reconciliation controls between front‑office trade feeds and finance / GL sources, including break classification and decision logs.
Implement automated regulatory controls for identifier integrity (LEI/UTI/UPI), timeliness SLAs, error correction workflows, and regulatory "clock" concepts.
Enable AI‑assisted anomaly detection and remediation in a governed, human‑in‑the‑loop framework with no black‑box regulatory outputs.
Support phased modernization delivery through diagnostics, target architecture blueprints, and proof‑of‑value pilots for priority reporting streams.
Huron Consulting · Belfast - 20 Adelaide Street