Snowflake Data Modeler for Enterprise Analytics

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

Job summary

Empower is seeking an experienced Data Modeler to design, develop, and maintain scalable data models across data warehouses, data marts, and BI environments, with a focus on Snowflake and AWS.

You will collaborate with data engineers, BI developers, analysts, and business stakeholders to translate requirements into clear data entities, attributes, relationships, and structures, while applying modeling standards and supporting data governance.

Qualifications

• 3+ years in data modeling, data warehousing, data engineering, or related data field.
• Bachelor’s degree in Computer Science or related field.
• Hands-on experience designing conceptual, logical, and physical data models.
• Strong understanding of dimensional modeling, relational database design, and ER modeling.
• Hands-on experience with Snowflake.
• Strong proficiency in SQL and relational databases.
• Experience with data modeling tools such as ERwin, ER/Studio, or similar platforms.
• Experience with data warehouses, data marts, semantic layers, and data consumption patterns.
• Experience with AWS cloud platforms and associated services.
• Knowledge of ETL/ELT methodologies and data integration concepts.
• Understanding of metadata management, data lineage, data governance, and data quality concepts.
• Understanding of data modeling standards, naming conventions, data definitions, and documentation practices.
• Experience with SDLC and Agile methodologies and Jira.

Responsibilities

• Design, develop, and maintain conceptual, logical, and physical data models for data warehouse, data mart, analytics, and reporting solutions.
• Develop and optimize dimensional and relational models within Snowflake.
• Translate business and technical requirements into data entities, attributes, relationships, and structures.
• Apply data warehouse and dimensional modeling principles to support reporting and analytics.
• Collaborate with data engineers, BI developers, analysts, and stakeholders to understand data requirements and develop scalable models.
• Partner with data engineering to align models with ETL/ELT processes and source data structures.
• Review existing data models and propose improvements for quality, performance, and maintainability.
• Define and apply data modeling standards, naming conventions, and reusable patterns across solutions.
• Support metadata management, data lineage, governance, and data quality initiatives.
• Create documentation for data models, entities, relationships, metadata, and data definitions.
• Participate in data model reviews and contribute to data architecture best practices.
• Support data solutions across Snowflake and AWS environments.
• Troubleshoot data-related issues with technical teams to identify root causes and solutions.
• Participate in SDLC and Agile development activities and use JIRA for work tracking.

Skills

SQL

Snowflake

Data modeling

ETL/ELT

JIRA

AWS

Data governance

Dimensional modeling

Education

Bachelor’s degree in Computer Science or related field

Tools

ERwin

ER/Studio

Snowflake tooling

Job description

Empower is seeking an experienced Data Modeler to design, develop, and maintain scalable data models across data warehouses, data marts, and BI environments, with a focus on Snowflake and AWS.

You will collaborate with data engineers, BI developers, analysts, and business stakeholders to translate requirements into clear data entities, attributes, relationships, and structures, while applying modeling standards and supporting data governance.