Senior Snowflake Data Modeler - Investment Analytics

Who You’ll Work With:

The Investment Technology team is seeking a Nashville, TN based Snowflake Data Modeler to design and govern the analytical data foundations supporting our investment processes. You will focus on building high‑quality Snowflake data models and semantic layers that power reporting, analytics, and AI‑enabled insights across portfolio management, risk, and research. This role is ideal for someone who excels at data modeling, understands analytics consumption, and enjoys working closely with investment professionals in a highly analytical environment.

This role partners closely with data engineers, architects, and investment stakeholders but is primarily focused on modeling and consumption, not pipeline engineering.

What You’ll Do:

You will serve as a Snowflake‑focused data modeler, responsible for designing, evolving, and governing data models that power investment analytics, reporting, and downstream applications. The role emphasizes dimensional and domain modeling, semantic layer design, and data quality, enabling research analysts, portfolio managers, risk teams, and quantitative users to access clean, well‑structured data.

 

Snowflake Data Modeling & Design

• Design and maintain dimensional, domain‑oriented, and analytics‑optimized data models in Snowflake.

• Develop fact and dimension models supporting portfolio management, risk, attribution, research, and performance analytics.

• Optimize Snowflake schemas for performance, scalability, and ease of consumption.

Semantic Layer & Analytics Enablement

• Build and maintain semantic layers and curated views that abstract underlying complexity for BI and analytics tools.

• Ensure Snowflake models align with Power BI datasets, metrics, hierarchies, and business definitions.

• Partner with analytics teams to enable consistent metric definitions and reusable analytical patterns.

Data Quality, Validation & Governance

• Define and implement data quality rules, validation checks, and reconciliation logic within modeled datasets.

• Collaborate with data governance teams to document data definitions, lineage, and usage standards.

• Support controlled access patterns, role‑based views, and governed data exposure.

Investment Data Domain Modeling

• Build strong understanding of key investment data domains including reference data, pricing, terms & conditions, indices, risk inputs, and derived analytics.

• Model data in ways that reflect how investment teams consume and analyze information.

• Ensure that data relationships and grain are clearly defined and analytically sound.

AI‑Ready & Discoverable Data Structures

• Design Snowflake models that are AI‑ready, with consistent schemas, clear relationships, and rich metadata.

• Support semantic consistency to enable natural‑language querying and AI‑driven analytics.

• Partner with architecture teams on Snowflake‑based semantic and knowledge layers that support GenAI use cases.

Collaboration & Cross‑Functional Partnership

• Work closely with data engineers to ensure pipelines land data in structures optimized for modeling.

• Partner with investment teams to translate analytical requirements into robust data models.

• Contribute to modeling standards, best practices, and reusable design patterns across the organization.

 

What We’re Looking For:

Core Technical Skills

• Strong expertise in Snowflake data modeling for analytics and reporting use cases.

• Advanced SQL skills for modeling, transformation, and performance optimization in Snowflake.

• Deep experience with dimensional modeling, star/snowflake schemas, and domain‑driven design.

Analytics & Consumption

• Experience designing data models to support Power BI, including semantic alignment and metric consistency.

• Familiarity with BI consumption patterns and performance considerations.

Data Quality & Governance

• Experience implementing data validation, reconciliation, and quality frameworks.

• Working knowledge of metadata, lineage, and governance concepts (e.g., Purview or similar tools).

• Understanding of how well‑structured models support AI, search, and natural‑language analytics.

• Familiarity with semantic layers, business glossaries, and model discoverability.

Data & Investment Knowledge

• Experience or strong interest in investment data domains (fixed income, equities, multi‑asset preferred).

• Strong analytical thinking and attention to detail.

• Ability to communicate modeling concepts clearly to both technical and investment audiences.

• Collaborative mindset and comfort working across engineering, analytics, and business teams.

About AB 

We are a leading global investment management firm offering high-quality research and diversified investment services to institutional clients, retail investors, and private-wealth clients in major markets around the globe. With over 4,000 employees across 57 locations operating in 26 countries and jurisdictions, our ambition is simple: to be the most trusted investment firm in the world. We realize that it's our people who give us a competitive advantage and drive success in the market, and our goal is to create an inclusive culture that rewards hard work. 

 

Our culture of intellectual curiosity and collaboration creates an environment where you can thrive and do your best work. Whether you're producing thought-provoking research, identifying compelling investment opportunities, infusing new technologies into our business or providing thoughtful advice to our clients, we are fully invested in you. If you're ready to challenge your limits and empower your career, join us! 

Nashville, Tennessee