Data Engineer Databricks - Banking
Summary
Data engineer for a banking data migration project: map legacy banking data to a new Databricks-based platform, profile and cleanse data, define reconciliation rules, and support cutover/go-live. Core needs are banking domain knowledge, data modeling fundamentals (keys, master/reference data), and client-facing communication; SQL is a strong plus.
Responsibilities:
- Perform source-to-target data mapping across all banking domains
- Analyze legacy banking systems and define field-level transformation, derivation, and lookup rules for migration to the target platform
- Facilitate workshops with client business SMEs, product owners, and core banking vendors to validate mapping logic and obtain sign-offs
- Ensure mapping coverage for regulatory and compliance fields to maintain reporting continuity
- Drive data profiling, quality assessment, and cleansing strategy to identify gaps, orphan records, and remediation needs
- Prepare mapping design; optionally write SQL transformations and create parametrization for DMT (Data Migration Tool)
- Define reconciliation rules based on business logic to ensure no data loss and correctness of transformation; support RBRO with financial reconciliation
- Define loading and transformation dependencies
- Support cutover planning, dry runs, and go-live execution, ensuring zero financial discrepancies post-migration
- Maintain mapping sheet and produce mapping status reports
Qualifications:
- Understanding of banking products and processes
- Ability to discuss edge cases and exceptions with clients
- Understanding of basic data concepts: primary key, foreign key, reference data, master data, etc..
- SQL knowledge — optional but a strong plus
*We are an equal opportunity employer and value diversity. All employment decisions are made without regard to age, gender, disability, race, ethnicity, religion, sexual orientation, or any other protected characteristic. We encourage applicants from all backgrounds to apply.*
Skills
As published by lever
Resume/CV, Full name, Email, Phone, Current location, Current company, LinkedIn URL