Data Architect – Sales & Marketing Technology

TIAA

Data Architect responsible for designing and implementing Snowflake data architecture for Nuveen's sales and marketing operations. Collaborating with business stakeholders and data engineering teams to optimize data governance and performance.

Posted 6/23/2026full-timeChicago • Illinois • 🇺🇸 United StatesMid-LevelSenior💰 $118,000 - $149,000 per yearWebsite

Tech Stack

Tools & technologies

CloudSitecoreTableauVault

About the role

Key responsibilities & impact

Owns the end-to-end data architecture of the Snowflake platform, including conceptual, logical, and physical data models that represent asset management sales and marketing operations across intermediary and institutional channels, product hierarchies, territory and coverage structures, AUM and flows, and client/prospect engagement.
Designs, builds, and curates reusable data products within Snowflake that serve as authoritative sources for downstream systems including Salesforce, Sitecore, and Tableau, ensuring contracts, SLAs, and consumption patterns are well defined.
Establishes and enforces data governance standards on the Snowflake platform, including data domain ownership, naming conventions, metadata, lineage, access controls, masking and row-level security, and compliance with regulatory requirements relevant to asset management (e.g., SEC, FINRA, GDPR, CCPA).
Collaborates with business stakeholders in sales, marketing, distribution strategy, and product to gather requirements and translate them into scalable data models and data products that support both intermediary channel analytics (sales activity, redemptions, gross/net flows by firm and advisor) and institutional analytics (consultant influence, mandate pipeline, RFP activity, relationship coverage).
Partners with data engineering teams on ingestion patterns, transformation frameworks (e.g., dbt), orchestration, and CI/CD practices to ensure efficient, well-tested, and observable data pipelines feeding Snowflake.
Develops and maintains dimensional models, star and snowflake schemas, data vault structures, and semantic layers that power business intelligence in Tableau, personalization in Sitecore, and operational use cases in Salesforce Sales and Marketing Clouds.
Supports integration of data from multiple structured and unstructured sources, including third-party intermediary data providers (e.g., Broadridge, Salesforce Asset Management Cloud feeds, DST, SS&C), institutional data sources, market and benchmark data, CRM, marketing automation, and digital engagement platforms.
Conducts data profiling and quality analysis to identify gaps, redundancies, and integrity issues, and drives remediation through model and pipeline improvements.
Monitors and tunes Snowflake for performance, scalability, and cost efficiency, applying best practices around warehouse sizing, clustering, materialized views, caching, and workload isolation.
Communicates data architecture designs, trade-offs, and roadmaps to technical and non-technical audiences, including senior leadership and cross-functional business partners.
Provides guidance and mentorship to data modelers, engineers, and analysts on cloud data architecture, modeling techniques, and asset management domain concepts.

Requirements

What you’ll need

5+ years of experience in data architecture, data modeling, or a related data discipline, with at least 3 years directly supporting asset management, wealth management, or broader financial services distribution functions.
Hands-on experience architecting solutions on Snowflake, including security and access frameworks (RBAC, row-/column-level security), data sharing, Snowpark, streams and tasks, performance tuning, and cost governance.
Demonstrated proficiency in conceptual, logical, and physical data modeling techniques, including dimensional modeling, entity-relationship modeling, and data vault methodologies, with experience building semantic layers for BI consumption.
Experience designing and operating data products with clear ownership, contracts, documentation, and consumer SLAs, ideally within a data mesh or domain-oriented architecture.
Strong understanding of how the asset management industry operates across both intermediary channels (warehouses, IBDs, RIAs, banks, DCIO) and institutional channels (consultants, plan sponsors, endowments, foundations, insurance general accounts), including AUM/flows analytics, sales crediting, territory and coverage models, product structures (mutual funds, ETFs, SMAs, CITs, alternatives, model portfolios), and intermediary data sources such as Broadridge.

Benefits

Comp & perks

Health insurance
401(k) matching
Flexible work hours
Paid time off
Remote work options

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data architecturedata modelingdimensional modelingentity-relationship modelingdata vault methodologiesperformance tuningdata governancedata profilingdata integrationcloud data architecture

Soft Skills

communicationcollaborationmentorshipproblem-solvingstakeholder engagement