Data Modeler — Analytics & Data Warehousing

Empower Retirement, LLC; Overland Park (KS); Hybrid; USD 79,000 - 112,000; Full time

Benefits offered by this job

Medical insurance

401(k) retirement plan

Tuition reimbursement

Casual environment

Generous PTO

Volunteer time off

Parental leave

BRGs

Job summary

Empower Retirement, LLC is seeking a Data Modeler in Overland Park, KS to design and maintain data models for analytics and reporting. You will translate business needs into structured data definitions and ensure model quality across data platforms.

The role emphasizes collaboration with data engineers, analysts, and architects, with opportunities to support data warehousing initiatives and data integration across systems.

Qualifications

• Bachelor’s degree in Information Systems, Computer Science, Business, or a related field.
• 2–4 years of experience in data modeling or analytics engineering.
• Knowledge of logical and physical data modeling concepts.
• Experience with SQL and data modeling tools (ER/Studio, ERwin).
• Familiarity with cloud data warehouses (PostgreSQL, Redshift, Athena, Snowflake).
• Strong analytical and communication skills.

Responsibilities

• Design and maintain logical and physical data models for ops, analytics, and reporting.
• Translate requirements into structured data definitions and model components.
• Apply naming conventions and maintain documentation, metadata, versioning.
• Create ERDs, data mappings, model definitions, and supporting docs.
• Perform data profiling and quality reviews to ensure accuracy.
• Support data warehouse development and data integration across systems.

Skills

SQL

Data modeling

Communication

Education

Bachelor’s degree in Information Systems, Computer Science, Business, or related field

Tools

ER/Studio

ERwin

PostgreSQL

Redshift

Athena

Snowflake

Job description

Empower Retirement, LLC is seeking a Data Modeler in Overland Park, KS to design and maintain data models for analytics and reporting. You will translate business needs into structured data definitions and ensure model quality across data platforms.

The role emphasizes collaboration with data engineers, analysts, and architects, with opportunities to support data warehousing initiatives and data integration across systems.