Principal Data Modeling

Empower Global Business Services India Private Limited; Bengaluru; On-site; INR 3,500,000 - 6,000,000; Full time

Job summary

Empower Global Business Services India Private Limited is seeking a Senior Data Modeler to design enterprise-wide data models on Snowflake, turning business concepts into conformed structures with robust metadata.

You will own conceptual, logical, and physical models, implement Data Vault/3NF where appropriate, and define data contracts, SLAs, lineage, and governance. Collaboration with product and data owners is key.

Qualifications

• Bachelor's degree in information systems, Computer Science, Data/Information Management, or related field.
• Master's degree or higher.
• 10+ years in data modeling and warehouse design, with scalable conceptual/logical/physical models.
• Hands-on Snowflake modeling (star/snowflake, 3NF) and performance tuning.
• Data contracts and CDEs: schemas, SLOs, versioning, and lineage integration.
• Governance and privacy: tagging, retention, and row-level access controls.
• Tooling: SQL; dbt or equivalent; modeling/diagram tools; catalog/lineage platforms.
• Strong communication to reconcile narratives and drive reusable semantics.

Responsibilities

• Translate domain concepts and CDEs into clear conceptual and logical models across business areas.
• Model Snowflake schemas and data vault/3NF where appropriate with partitioning and performance notes.
• Define data contracts with schemas, SLAs, versioning and change policy.
• Embed classification/tags for CDEs/PII and enforce policies in pipelines.
• Publish modeling runbooks to meet BI latency targets under concurrency.
• Specify validation rules and profiling thresholds; wire tests into CI/CD.
• Create model diagrams, semantic definitions, and consumer guides; drive adoption.
• Mentor junior data modelers.
• Model-as-code with Git-based CI/CD; collaborate with stewards and owners.

Skills

Data modelling

Communication

Education

Bachelor's degree in information systems, Computer Science, Data/Information Management, or related field

Master's degree

Tools

SQL

dbt

Snowflake

Modeling/diagram tools

Job description

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.

Remote and Hybrid Positions For remote and hybrid positions you will be required to provide reliable high-speed internet with a wired connection as well as a place in your home to work with limited disruption. You must have reliable connectivity from an internet service provider that is fiber, cable or DSL internet. Other necessary computer equipment will be provided. You may be required to work in the office if you do not have an adequate homework environment and the required internet connection.