Data Modeler

Empower Retirement; Greenwood Village (CO); On-site; USD 79,000 - 112,000; Full time

Benefits offered by this job

401(k) matching

Tuition reimbursement

Paid time off

Parental leave

Volunteer time

Flexible work environment

Job summary

Empower Retirement in Greenwood Village, CO seeks a Data Modeler to design and maintain both logical and physical data models for analytics and reporting. You will translate business requirements into structured data definitions, entities, relationships, and model components, while applying enterprise standards and maintaining documentation.

You will collaborate with data engineers, analysts, architects and stakeholders to ensure data quality, lineage and availability across data warehouse

Qualifications

• Bachelor's degree in Information Systems, CS, Business or related field; 2–4 years in data modeling or analytics.
• Knowledge of logical/physical data modeling, dimensional modeling, and relational design.
• Experience with SQL and data modeling tools (ER/Studio, ERwin) and cloud data warehouses (PostgreSQL, Redshift, Athena, Snowflake).
• Strong analytical, problem-solving, and communication skills; ability to work independently and collaboratively.

Responsibilities

• Design and maintain logical and physical data models for analytics and reporting.
• Translate requirements into data definitions, entities, relationships, and model components.
• Apply data standards and maintain documentation, metadata, versioning, and change tracking.
• Create and maintain ERDs, data mappings, model definitions, and supporting docs.
• Perform data profiling and quality reviews to ensure accuracy and usability.
• Support data warehouse development and data integration across multiple systems.

Skills

SQL

Data modeling

Analytics

Communication

Education

Bachelor's degree in Information Systems/Computer Science/Business

Tools

ER/Studio

ERwin

PostgreSQL

Redshift

Athena

Snowflake

Job description

life insurance, parental leave, paid time off, tuition reimbursement, 401(k)

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.

***Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment visa at this time, including CPT/OPT.***

The Data Modeler will support the design, development, and maintenance of logical and physical data models that enable analytics, reporting, and operational data use cases. This role works with business and technical stakeholders to translate requirements into structured data solutions while applying established enterprise data modeling standards and practices. The Data Modeler contributes to data quality, consistency, and usability across systems while developing expertise in enterprise data modeling, data warehousing, data integration, and database technologies.

What you will do:

• Design and maintain logical and physical data models for operational, analytics, and reporting use cases, including dimensional, normalized, and relational models under guidance from senior team members.


• Translate business and technical requirements into structured data definitions, entities, relationships, and model components.


• Apply enterprise naming conventions, data standards, and modeling practices consistently across deliverables, and maintain model documentation, metadata, versioning, and change tracking.


• Create and maintain modeling artifacts, including entity relationship diagrams (ERDs), data mappings, model definitions, and supporting documentation.


• Perform data profiling, validation, and quality reviews to support model accuracy, consistency, and usability, and assist in troubleshooting data structure, lineage, mapping, and integration issues.


• Support data warehouse development and data integration initiatives across multiple systems while collaborating with data engineers, analysts, architects, and business stakeholders to clarify data requirements.

What you will bring:

• Bachelor's degree in Information Systems, Computer Science, Business, or a related field, with 2 to 4 years of experience in data modeling, database design, analytics engineering, or a related data discipline.


• Working knowledge of logical and physical data modeling concepts, dimensional modeling, and relational database design principles.


• Experience using SQL for querying, validation, and data analysis, along with experience using data modeling tools such as ER/Studio, ERwin, or similar platforms and familiarity with cloud database or warehouse technologies such as PostgreSQL, Redshift, Athena, Snowflake, or similar platforms.


• Strong analytical, problem-solving, and communication skills, with the ability to manage assigned work independently while collaborating effectively within a team environment.

This job operates in a professional office environment.

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 on 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, as per terms and conditions of your employment contract.

What we offer you

We offer an array of diverse and inclusive benefits regardless of where you are in your career. We believe that providing our employees with the means to lead healthy balanced lives results in the best possible work performance.

• Medical, dental, vision and life insurance


• Retirement savings - 401(k) plan with generous company matching contributions (up to 6%), financial advisory services, potential company discretionary contribution, and a broad investment lineup


• Tuition reimbursement up to $5,250/year


• Business-casual environment that includes the option to wear jeans


• Generous paid time off upon hire - including a paid time off program plus ten paid company holidays and three floating holidays each calendar year


• Paid volunteer time - 16 hours per calendar year


• Leave of absence programs - including paid parental leave, paid short- and long-term disability, and Family and Medical Leave (FMLA)


• Business Resource Groups (BRGs) - BRGs facilitate inclusion and collaboration across our business internally and throughout the communities where we live, work and play. BRGs are open to all.

Base Salary Range

$79,400.00 - $112,175.00

The salary range above shows the typical minimum to maximum base salary range for this position in the location listed. Non-sales positions have the opportunity to participate in a bonus program. Sales positions are eligible for sales incentives, and in some instances a bonus plan, whereby total compensation may far exceed base salary depending on individual performance. Actual compensation offered may vary from posted hiring range based upon geographic location, work experience, education, licensure requirements and/or skill level and will be finalized at the time of offer.

Equal opportunity employer * Drug-free workplace

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 (40 and over), 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.

***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 home work environment and the required internet connection.***

Job Posting End Date at 12:01 am on:

10-02-2026