Sr. Investment Data Modeler; Aladdin & Snowflake

Location:
Newark, NJ (Hybrid)

Work Type:
Full Time

Job Descriptio

n:

We are seeking an experienced Senior Data Model
er to spearhead data architecture and cloud modernization initiatives for a premier financial services client. This role is highly specialized, sitting at the crossroads of sophisticated investment data, enterprise cloud infrastructure, and the Black Rock Aladdin ecosyste

m.The ideal candidate will design, optimize, and scale robust data models within a Snowfla
ke environment, ensuring that complex portfolio, risk, and fixed-income datasets are seamlessly structured for downstream analytics, reporting, and operational excellenc

e.Key Responsibiliti

• es Enterprise Data Modeli
  ng:
  Architect conceptual, logical, and physical data models (utilizing 3NF, Star Schema, and Data Vault methodologies) tailored for core investment banking domains, including fixed income, portfolio management, corporate actions, and risk analytic
• s.Aladdin Integrati
  on:
  Collaborate with platform teams to ingest, map, and harmonize data pipelines from the Black Rock Aladd
  in ecosystem (including Aladdin Data Cloud and APIs) into enterprise data structure
• s.Snowflake Optimizati
  on:
  Design and implement high-performing schemas within Snowflake. Drive query performance tuning, establish clustering strategies, and implement secure role-based access controls (RBAC
• )Cross-Functional Collaborati
  on:
  Partner with Data Engineers, Business Analysts, and BI teams (Power BI/Tableau) to translate complex financial business requirements into scalable, clean data structure
• s.Data Governance & Documentati
  on:
  Author and maintain comprehensive data dictionaries, Entity-Relationship Diagrams (ERDs), and metadata registries. Support data lineage tracking and data quality framework
• s.Agile Delive
  ry:
  Actively participate in Agile/Scrum cycles, contributing to sprint planning, technical reviews, and story groomin

g.Required Technical Skills & Qualificatio

• ns Experien
  ce: 8+ years of dedicated data modeling experience, explicitly within the Financial Services or Investment Manageme
  nt sectors (strong understanding of equities, fixed income, derivatives, etc.
• )Core Syste
  ms:
  Proven, hands-on experience working with the Black Rock Aladd
  in platform and its underlying data structures/API
• s.Cloud Platfo
  rm:
  Advanced proficiency in Snowfla
  ke, including architecture design, data sharing, and performance optimizatio
• n.Modeling Too
  ls:
  Expert-level command of enterprise modeling tools such as Erwin, ER/Studio, or SQLD
  B
• M.Technical Langua
  ge:
  Exceptional SQL skills for writing complex analytical queries, data validation scripts, and stored procedure
• s.Pipeline Exposu
  re:
  Familiarity with modern ETL/ELT pipelines and transformation workflows (e.g., dbt, Informatica
• )Soft Skil
  ls:
  Strong communication skills with a proven ability to explain complex technical data models to non-technical business stakeholder

s.Preferred Qualifications (Nice to Hav

• e)
  Active Snowflake SnowP
  ro Certificatio
• n.Hands-on experience using dbt (data build too
  l) for data transformation inside Snowflak
• e.Familiarity with Python for basic data profiling and task automatio
• n.Knowledge of industry-standard data governance frameworks such as CD
  MC or DAMA DMB
  O
• K.Familiarity with cloud ecosystems (AWS, Azure, or GCP