Position Details

Type Full-Time

Experience mid

Exp. Years 3-7+ years

Education Bachelor's degree in finance, Accounting, Data/Information Management, Computer Science, or related field; Master's degree preferred

Category Data & Analytics

About this role

Data Modeler to join Bank of New York Mellon's Finance Data Governance team, responsible for designing and evolving data models, embedding standards and lineage into pipelines, and enabling accurate financial reporting.

Key Responsibilities

Design and evolve data models across finance domains
Implement models across data warehouses/lakehouses
Define data architecture standards
Embed data lineage and quality controls
Deliver ERDs, data contracts, and metadata catalogs

Technical Overview

Focus on finance data modeling within data warehouses/lakehouses; implement ETL/ELT pipelines with SQL and tools like dbt, Spark, and Informatica; governance tooling for lineage and metadata catalogs.

Ideal Candidate

The ideal candidate is a mid-level data modeler with 3-7+ years of data architecture experience, strong in data governance and data lineage, and proficient with tools like dbt, Spark, Informatica, and governance platforms (Collibra/Alation/Purview). Financial services domain experience is preferred.

Must-Have Skills

Bachelor's degree in financeaccountingdata/information managementcomputer scienceor related field; Master's preferred3-7+ years of experience in data architecture and data modelingStrong data modeling skills (conceptual/logical/physical)Data governance expertiseEnd-to-end data lineage and metadata management experience

Nice-to-Have Skills

Experience with finance data domains (General LedgerP&Letc.)Experience with data contracts and data quality controlsExperience with governance tooling (CollibraAlationInformaticaPurviewMantaSolidatus)

Tools & Platforms

dbtSparkInformaticaCollibraAlationInformaticaPurviewMantaSolidatusExcel

Required Skills

3-7+ years data architecture and data modeling; data governance; end-to-end data lineage; SQL / PostgreSQL; dbt; Spark; Informatica; Collibra; Alation; Purview; Manta; Solidatus; data quality; data contracts; ETL/ELT

Hard Skills

SQL / PostgreSQLdbtSparkInformaticaCollibraAlationPurviewMantaSolidatusExcel

Soft Skills

Cross-functional collaborationMentoringCommunicationProblem solvingLeadership

Industry & Role

Industry Banking

Job Function Design, govern, and operationalize finance data models and data pipelines to support reporting and regulatory requirements.

Role Subtype Data Architect

Tech Domains SQL / PostgreSQL, Python, Tableau, Power BI, SharePoint

Keywords for Your Resume

Data ModelerData Governance ArchitectFinance Data Governanceconceptual data modellogical data modelphysical data modeldata warehouseslakehousesdbtSparkInformaticaCollibraAlationPurviewMantaSolidatusdata lineagemetadata catalogdata qualityend-to-end data lineageETLELTERDsource-to-target mappingsdata contractsmaster data managementreference datagovernancedata modelingdata governanceSQL / PostgreSQL

Deal Breakers

Lack of 3-7+ years data modeling/architecture experience, No experience with data governance tools, No familiarity with finance data domains

Apply for this Position →

Get matched to jobs like this

Luna finds roles that fit your skills and career goals — no endless scrolling required.

Create a Free Profile