> Markdown version of [/jobs/ext/2061119-snowflake-data-modeler-investment-analytics](https://www.wearedevelopers.com/jobs/ext/2061119-snowflake-data-modeler-investment-analytics). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Snowflake Data Modeler - Investment Analytics - **Company:** AllianceBernstein Holding L.P. - **Location:** Nashville, TN, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Data Analysis, Data Validation, Data Governance, Data Structures, Software Design Patterns, Dimensional Modeling, Document-Oriented Databases, Metadata, Performance Tuning, Reference Data, Power BI, Sql Optimization, Snowflake, Data Layers, Star Schema, Domain Driven Design - **Published:** August 14, 2026 - **Apply:** https://www.dice.com/job-detail/af438415-38b1-4ba2-b0b1-c5a87f139b02 ## About the Role * 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. ## Description 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. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [A Data Mesh needs Open Metadata](https://www.wearedevelopers.com/videos/505-a-data-mesh-needs-open-metadata) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [Beyond SQL Generation: How to Teach Agents What Your Database Actually Means](https://www.wearedevelopers.com/videos/100127-beyond-sql-generation-how-to-teach-agents-what-your-database-actually-means) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering) - [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria)