Data Modeler

Job Summary

The Data Modeler position works with the data management and data architecture teams to define risks and tradeoffs related to different design choices within databases utilized at F&G. The Data Modeler will have responsibility to model data for relational and/or dimensional models depending on the context of the project assigned. This role needs to be proficient in data modeling and query analysis tools (e.g., SSMS, Erwin Data Modeler, ER/Studio, etc.) and SQL.

Duties and Responsibilities

• Design and implement data modeling solutions using relational and/or dimensional databases based on need.
• Work closely with Data Architects to design databases or data warehouses using a mixture of conceptual, logical and physical data models.
• Assist with the development and maturing of data modeling standards, guidelines, processes, and procedure.
• Act as a steward of data modeling best practices within a community of practice; provide training for data modeling practitioners as needed.
• Conduct evaluations of existing project data systems, including constructing as-is data models (reverse engineer) and identifying foundational data model. Make recommendations for how data should be modeled based on the results of completed evaluations.
• Maintain basic understanding of all ACORD standards and responsible for engineering DDL

Experience and Education Requirements

• Associate’s/Bachelor's Degree with a preferred emphasis in technology, engineering or math related field or equivalent combination of education and experience.
• Strong proficiency and experience in Data modeling (Conceptual, Logical, Physical, 3nF, Dimensional) at both a project and enterprise level
• Experience working with Data Engineering and Data Analytics teams
• 0-3 years of relevant data modeling experience delivering data lake, data warehouse and reporting platforms.
• Experience and familiarity with ACORD/DTCC is a plus.
• Exposure to SQL Server, Oracle and/or Snowflake
• Financial Services or Insurance industry experience preferred

Knowledge, Skills & Abilities

• Understanding of principles and standard methodologies around Data Architecture
• Familiarity with ETL tools such as Informatica or Informatica Data Management Cloud
• Familiarity with insurance and financial service industry models and concepts.
• Experience crafting conformed dimensions that can be used across business untis with dimensional modeling tools such as Powerdesigner, Oracle Designer or Erwin
• Experience data modeling for columnar based sorage like Snowflake and/or similar platforms.
• Ability to write SQL to query data (ideally ANSI SQL)
• Ability to explain Data structures to a non-technical audience
• Knowledge of metadata management and related tooling (e.g., Informatica Data Management Cloud, Refrerence Data Management)
• Solid grasp of Database technologies, techniques, and trends
• Strong interpersonal communication skills, written and verbal
• Fast, adaptive learner Ability to manage multiple tasks and deadlines simultaneously
• Exhibits flexibility and tolerance for ambiguity with the ability to thrive in a rapidly changing business environment
• Results-oriented & Dedicated work ethic

Other Requirements

• Perform other functions, duties and projects as assigned
• Regular and punctual attendance
• Minimal travel required (less than 10%)

Additional Information

Work Environments

F&G believes in an employee-centric flexible environment, which is why we offer the ability for in-office, hybrid and remote work arrangements. During the hiring process, you'll work with your leader to decide what works best for your role.

F&G complies with federal and state disability laws and makes reasonable accommodations for applicants and candidates with disabilities, unless such accommodation would cause an undue hardship for F&G. If reasonable accommodation is needed to participate in the job application or interview process, please contact [email protected].

Join our employee-centric hybrid work environment: F&G Careers

About F&G

Since 1959, Fidelity & Guaranty Life Insurance Company (F&G) has offered annuity and life insurance products to those who are seeking security in retirement and protection during life’s unexpected events.

As a national Top Workplace1, an Iowa Top Workplace2 and a proud equal opportunity employer, F&G team members are empowered, collaborative, dynamic and authentic. We believe that by embracing these values, we will continue to build and strengthen the company while continuing to be a great place to work.

1Top Workplaces USA 2022 – 2023

2Des Moines Register Top Workplaces 2018 – 2022

Notice for all Applicants who are California residents under the California Privacy Rights Act. Please click here to review the policy.