Sr. Investment Data Modeler (Aladdin & Snowflake)

Smart IT Frame LLC; Newark (NJ); Hybrid; USD 110,000 - 150,000; Full time

Job summary

Smart IT Frame LLC is seeking a Senior Data Modeler to lead data architecture initiatives for a top financial services client. The ideal candidate will have over 8 years of experience, particularly within investment management, and a deep understanding of Snowflake and BlackRock Aladdin.

This hybrid position emphasizes designing robust data models and collaborating with cross-functional teams to streamline data processes and optimize performance.

Qualifications

• 8+ years of experience in data modeling within financial services.
• Hands-on experience with BlackRock Aladdin.
• Advanced proficiency in Snowflake platform architecture.

Responsibilities

• Architect data models for investment banking domains.
• Collaborate with teams to implement data pipelines.
• Design optimized schemas and maintain data governance.

Skills

Data modeling expertise

Strong SQL skills

Experience with BlackRock Aladdin

Proficiency in Snowflake

Familiarity with ETL/ELT pipelines

Good communication skills

Education

Degree in Data Science or related field

Tools

Erwin

Power BI

Tableau

Job description

Location: Newark, NJ (Hybrid)

Work Type: Full Time

Job Descriptio

n:We are seeking an experienced Senior Data Modeler 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 BlackRock Aladdin ecosyste

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

e.Key Responsibiliti

• esEnterprise Data Modeling: 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 Integration: Collaborate with platform teams to ingest, map, and harmonize data pipelines from the BlackRock Aladdin ecosystem (including Aladdin Data Cloud and APIs) into enterprise data structure
• s.Snowflake Optimization: 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 Collaboration: 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 & Documentation: Author and maintain comprehensive data dictionaries, Entity-Relationship Diagrams (ERDs), and metadata registries. Support data lineage tracking and data quality framework
• s.Agile Delivery: Actively participate in Agile/Scrum cycles, contributing to sprint planning, technical reviews, and story groomin

g.Required Technical Skills & Qualificatio

• nsExperience: 8+ years of dedicated data modeling experience, explicitly within the Financial Services or Investment Management sectors (strong understanding of equities, fixed income, derivatives, etc.
• )Core Systems: Proven, hands-on experience working with the BlackRock Aladdin platform and its underlying data structures/API
• s.Cloud Platform: Advanced proficiency in Snowflake, including architecture design, data sharing, and performance optimizatio
• n.Modeling Tools: Expert-level command of enterprise modeling tools such as Erwin, ER/Studio, or SQLDB
• M.Technical Language: Exceptional SQL skills for writing complex analytical queries, data validation scripts, and stored procedure
• s.Pipeline Exposure: Familiarity with modern ETL/ELT pipelines and transformation workflows (e.g., dbt, Informatica
• )Soft Skills: 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 SnowPro Certificatio
• n.Hands-on experience using dbt (data build tool) 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 CDMC or DAMA DMBO
• K.Familiarity with cloud ecosystems (AWS, Azure, or GCP