Senior Snowflake Data Modeler - AWS & Analytics

Empower; United States; Remote; USD 90,000 - 130,000; Full time

Job summary

Empower is seeking an experienced Data Modeler to design, develop, and maintain scalable data models across data warehouses, marts, and BI environments. You will work with Snowflake and AWS, translating business requirements into robust models for analytics and reporting.

Collaborate across data engineering, BI, and analytics teams to ensure data quality, governance, and efficient data consumption while adhering to modeling standards and best practices.

Qualifications

• Hands-on experience designing conceptual, logical, and physical data models.
• Strong understanding of dimensional modeling and relational design.
• Proficiency with Snowflake and SQL.
• Experience with data warehouses, data marts, and semantic layers.
• Familiarity with SDLC/Agile and JIRA for delivery.
• Knowledge of metadata management, data lineage, and data governance.

Responsibilities

• Design, develop, and maintain conceptual, logical, and physical data models.
• Develop and optimize dimensional and relational data models within Snowflake.
• Translate requirements into defined data entities, attributes, and relationships.
• Apply data warehousing and dimensional modeling principles for reporting and analytics.
• Collaborate with engineers, BI developers, and stakeholders to scale data models.
• Ensure alignment with ETL/ELT, source data structures, and data integration needs.
• Review models for quality, performance, and maintainability; define standards.
• Support metadata management, data governance, and data quality initiatives.
• Create and maintain data model documentation; participate in reviews.

Skills

Data modeling

Data warehousing

SQL

Dimensional modeling

ER modeling

Data governance

Data quality

Data lineage

Communication skills

SDLC & Agile

Education

Bachelor's degree in Computer Science or related field

Tools

ERwin

ER/Studio

Snowflake

JIRA

AWS

Job description

Empower is seeking an experienced Data Modeler to design, develop, and maintain scalable data models across data warehouses, marts, and BI environments. You will work with Snowflake and AWS, translating business requirements into robust models for analytics and reporting.

Collaborate across data engineering, BI, and analytics teams to ensure data quality, governance, and efficient data consumption while adhering to modeling standards and best practices.