Principal Data Modeling

Our vision for the future is based on the idea that transforming financial lives starts by giving our people the freedom to transform their own. We have a flexible work environment, and fluid career paths. We not only encourage but celebrate internal mobility. We also recognize the importance of purpose, well-being, and work-life balance. Within Empower and our communities, we work hard to create a welcoming and inclusive environment, and our associates dedicate thousands of hours to volunteering for causes that matter most to them. Chart your own path and grow your career while helping more customers achieve financial freedom. Empower Yourself. Design the enterprise-wide data modeling standards - conceptual, logical , & physical data models that power governed, performant, reusable data products on Snowflake. You’ll turn business concepts/CDEs (Critical Data Elements)and analytics needs into star schemas, vault/3NF structures, and semantic definitions that are consistent, documented, and easy to use. Wired into our catalog, lineage, quality checks, and access controls. ESSENTIAL FUNCTIONS: Model the business: Working with product & data owners to translate domain concepts and Critical Data Elements (CDEs) into clear conceptual & logical models; define conformed dimensions, own canonical entities and models across multiple business areas, and metric definitions aligned to glossary/ontology. Physical modeling on Snowflake: Implement star/snowflake schemas (and when appropriate, Data Vault/3NF) optimized for Snowflake’s micro-partitioning, materialized views, and search optimization; document SCD handling, surrogate keys, and partitioning/clustering choices. Data product contracts: Define data contracts (schemas, SLAs/SLOs, versioning, change policy) and ensure models are discoverable with complete metadata, lineage, and owners in the catalog. Governance-by-design: Embed classification/tags for CDEs/PII in models and propagate them through pipelines so tag-based masking/row-access policies can be enforced; provide evidence for attestations. Performance & reliability: Publish modeling/runbooks that hit BI latency targets (<10s where required) under concurrency, with guidance on warehouse strategy, result caching, and model refactoring. Quality & observability: Specify validation rules and profiling thresholds (freshness, volume, schema) tied to CDEs; wire tests into CI/CD and the stewardship workflow. Enablement & documentation: Create model diagrams, semantic definitions, and consumer guides; partner with stewards and analysts to drive adoption and deprecate redundant reports/data sets. Mentorship: Will mentor more junior data modelers as needed. How you’ll work: Model-as-code with Git-based CI/CD and tests; collaborate with stewards/owners; integrate with catalog/lineage; design for privacy/performance from day one—so governed data is easy (and safe) to use. QUALIFICATIONS: Bachelor's degree in information systems, Computer Science, Data/Information Management, or related field. Master's degree plus. 10+ years in data modeling/warehouse design; proven delivery of conceptual/logical/physical models consumed at scale. Hands-on Snowflake modeling (star/snowflake, 3NF/Vault where appropriate), plus performance patterns (materialized views, search optimization, clustering/micro-partition hygiene). Data contracts & CDEs: designing schemas/SLOs, versioning, and integrating models with glossary, lineage, and stewardship processes. Governance & privacy: applying object tags, aligning models to classification/retention, and enabling tag-based masking/row-access. Tooling: SQL; dbt or equivalent for model-as-code (tests, documentation, CI/CD); modeling/diagram tools; catalog/lineage platforms. Strong communication—able to reconcile competing narratives and converge on trusted, reusable semantics. Preferred Qualifications: Experience mapping business architecture/ontology to data models; metric layers/semantic models for BI Exposure to data fabric concepts (automation of tagging/metadata, policy propagation). Helpful: Snowflake SnowPro (Data Engineer/Architect), dbt certification, CDMP/DCAM familiarity. Normal office working conditions. This job description is not intended to be an exhaustive list of all duties, responsibilities and qualifications of the job. The employer has the right to revise this job description at any time. You will be evaluated in part based on your performance of the responsibilities and/or tasks listed in this job description. You may be required to perform other duties that are not included in this job description. The job description is not a contract for employment, and either you or the employer may terminate employment at any time, for any reason. We are an equal opportunity employer with a commitment to diversity. All individuals, regardless of personal characteristics, are encouraged to apply. All qualified applicants will receive consideration for employment without regard to age, race, color, national origin, ancestry, sex, sexual orientation, gender, gender identity, gender expression, marital status, pregnancy, religion, physical or mental disability, military or veteran status, genetic information, or any other status protected by applicable state or local law.