Senior Investment Data Modeler (Aladdin & Snowflake)

Straive is a global leader in enterprise-grade data analytics and AI solutions, committed to empowering businesses across various industries with cutting-edge technology and expert insights. Backed by EQT, a top private equity firm, we are uniquely positioned to drive innovation through significant investments and an entrepreneurial spirit.

Our core focus is on delivering advanced Data Analytics & AI Solutions. By combining sophisticated technology with subject matter expertise, we deliver material impact on our clients' topline and streamline their operations. We specialize in providing tailored solutions across financial services, CPG, legal, pharma, life sciences, retail and logistics, helping them build robust data analytics and AI capabilities.

With a client base spanning 30 countries, Straive's strategically located teams operate from eight countries and is headquartered in Singapore. This global presence enables us to offer localized expertise with a worldwide perspective.

Join Straive to be part of a dynamic team at the forefront of data analytics and AI innovation. Here, you'll have the opportunity to contribute to transformative projects, supported by significant investments and an entrepreneurial drive fueled by our partnership with EQT.

Website: https://www.straive.com/

Job Title: Senior Investment Data Modeler (Aladdin & Snowflake)

Location: Newark, NJ (Hybrid – 2 to 3 days onsite per week)

Industry: Investment Banking / Asset Management

Position Overview

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 ecosystem.

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 excellence.

Key Responsibilities

• Enterprise 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 analytics.
• 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 structures.
• 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 structures.
• Data Governance & Documentation: Author and maintain comprehensive data dictionaries, Entity-Relationship Diagrams (ERDs), and metadata registries. Support data lineage tracking and data quality frameworks.
• Agile Delivery: Actively participate in Agile/Scrum cycles, contributing to sprint planning, technical reviews, and story grooming.

Required Technical Skills & Qualifications

• Experience: 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/APIs.
• Cloud Platform: Advanced proficiency in Snowflake, including architecture design, data sharing, and performance optimization.
• Modeling Tools: Expert-level command of enterprise modeling tools such as Erwin, ER/Studio, or SQLDBM.
• Technical Language: Exceptional SQL skills for writing complex analytical queries, data validation scripts, and stored procedures.
• 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 stakeholders.

Preferred Qualifications (Nice to Have)

• Active Snowflake SnowPro Certification.
• Hands-on experience using dbt (data build tool) for data transformation inside Snowflake.
• Familiarity with Python for basic data profiling and task automation.
• Knowledge of industry-standard data governance frameworks such as CDMC or DAMA DMBOK.
• Familiarity with cloud ecosystems (AWS, Azure, or GCP)

This job description is not intended to cover or contain a comprehensive listing of all responsibilities, duties, or activities that are required. Responsibilities, duties, and/or activities may change, or new ones may be added at any time with or without notice.

If you are a motivated professional with a passion for delivering impactful solutions, we’d love to hear from you. Apply today to be part of a dynamic and forward-thinking team at Straive.

“Straive is an Equal Opportunity Employer. Our policy is clear: there shall be no discrimination based on age, disability, sex, race, religion or belief, gender reassignment, marriage/civil partnership, pregnancy/maternity, or sexual orientation.

We are an inclusive organization and actively promote equality of opportunity for all with the right mix of talent, skills and potential. We welcome all applications from a wide range of candidates. Selection for roles will be based on individual merit alone.”