Data Modeler - Snowflake

About the role

We're seeking a Snowflake Data Modeler to design and govern the analytical data foundations supporting our investment processes. 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.

Responsibilities

• 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, rolebased 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.

Qualifications

• 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).
• AIAware Modeling (Preferred)
• 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, multiasset preferred).
• Soft Skills
• 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.

Pay

$97,700 per year