Data Modeler

7 days ago

Des Moines, Iowa, United States Fidelity & Guaranty Life Insurance Company Full time
Job DescriptionJob Description

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%)

#LI-Remote

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

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.

  • Sr. Data Analyst

    7 days ago

    Des Moines, Iowa, United States Diverse Lynx Full time

    Role name: Developer/Analyst-Pension Risk Transfer Role Description: ? Over 6 years of proven track record in business system data analysis and progressive responsibilities? Proficient in working with financial accounting, Annuity insurance data, and Pension Risk Transfer (PRT) data? Strong command of SQL ? Awareness of Github, AWS Cloud Fundamentals, AWS...

  • Senior Data Architect

    2 months ago

    Des Moines, Iowa, United States JSM Consulting Full time

    Extensive background in data governance policies and standards Required 10Years Experience with data dictionaries data catalogs and/or other metadata management solutionsRequired 10Years Experience designing/architecting business intelligence/reporting platformsRequired 10Years Experience integrating data from multiple systems built using heterogeneous...

  • Senior Data Architect

    3 weeks ago

    Des Moines, Iowa, United States JSM Consulting Full time

    Extensive background in data governance policies and standards Required 10Years Experience with data dictionaries data catalogs and/or other metadata management solutionsRequired 10Years Experience designing/architecting business intelligence/reporting platformsRequired 10Years Experience integrating data from multiple systems built using heterogeneous...

  • Data Science Consultant

    7 days ago

    Des Moines, Iowa, United States Wellmark Full time

    Company DescriptionWhy Wellmark: We are a mutual insurance company owned by our policy holders across Iowa and South Dakota, and we've built our reputation on over 80 years' worth of trust. We are not motivated by profits. We are motivated by the well-being of our friends, family, and neighbors-our members. If you're passionate about joining an organization...

  • Data Engineer 2 or 3

    7 days ago

    Des Moines, Iowa, United States American Enterprise Group Full time

    JOB SUMMARY Wellabe is looking for a Data Engineer 2 or 3 to join our team. Responsibilities include analyzing, designing, building, and delivering data solutions for the organization. Position level will be determined based on skills, knowledge and experience. Position level will be determined based on skills, knowledge and experience.ESSENTIAL...

  • Senior Data Analyst

    7 days ago

    Des Moines, Iowa, United States Ryan Companies US Full time

    Company:With a heritage of over 80 years and growing presence through 16 offices, Ryan is dedicated to offering comprehensive commercial real estate solutions throughout the United States. Our approach is centered on collaboration and relationships, striving to create spaces that foster both individual well-being and business success. Join us to be part of a...

  • Sr Data

    1 week ago

    Des Moines, Iowa, United States Principal Financial Group Full time

    What You'll Do: Are you passionate about leveraging AI to help solve business problems? Are you an analytic problem solver who can drive solutions by thinking creatively, prioritizing, and innovating? We are looking for a Senior Data & Analytics Consultant to work closely with our Enterprise data science team. In this role, you will serve as a bridge between...

  • Sr Data Governance Analyst

    1 week ago

    Des Moines, Iowa, United States Principal Financial Group Full time

    What You'll Do: Were looking for a Sr Data Governance Analyst to join our Enterprise Data and Analytics team You'll be responsible for implementing and executing the AI Governance program across the enterprise. This will include introducing a consistent set of policies, standards, and practices to enable strategic, ethical, and responsible development,...

  • Senior Data Science Consultant

    7 days ago

    West Des Moines, Iowa, United States Wells Fargo Full time

    Why Join Wells Fargo:Take the first step in your professional journey with us. Wells Fargo is not just a top-ranked company on the 2023 LinkedIn list, we are also leading among financial services firms as the ideal place to advance your career in the U.S.At Wells Fargo, we are dedicated to helping our employees achieve their career goals. We take pride in...

  • Senior Data Science Consultant

    7 days ago

    West Des Moines, Iowa, United States Wells Fargo Full time

    Lead or participate in moderately complex initiatives and deliverables by utilizing data-driven, advanced analytical, statistical techniques, algorithms, or models to make actionable insights, trends, or recommendations. Review and analyze moderately Data Science, Analytics, Consultant, Data, Science, Excel, Technology, Banking

  • Data Analyst II

    7 days ago

    West Des Moines, Iowa, United States Aureon Full time

    ESSENTIAL FUNCTIONS:Collect, clean, and analyze data from various sources using SQL, Python, R, or other tools. Create dashboards, reports, and presentations using Tableau, Power BI, Excel, or other tools. Identify trends, patterns, and outliers in data and provide actionable insights and recommendations. Work with business users to understand their data...

  • Financial or Data Analyst

    3 weeks ago

    Des Moines, Iowa, United States Principal Financial Group Full time

    What You'll DoWe are in search of a Financial or Data Analyst to join our Pension Risk Transfer (PRT) team. As part of this role, you will play a crucial role in all aspects of Pension Risk Transfer. Here's what you'll be doing:Coding pricing model enhancements and supporting Individual Case pricing initiatives.Developing data and analytics work related to...

  • Financial or Data Analyst

    1 month ago

    Des Moines, Iowa, United States Principal Financial Group Full time

    What You'll DoWe are in search of a Financial or Data Analyst to join our Pension Risk Transfer (PRT) team. As part of this role, you will play a crucial role in all aspects of Pension Risk Transfer. Here's what you'll be doing:Coding pricing model enhancements and supporting Individual Case pricing initiatives.Developing data and analytics work related to...

  • Financial or Data Analyst

    4 weeks ago

    Des Moines, Iowa, United States Principal Financial Group Full time

    What You'll DoWe're looking for a Financial or Data Analyst to join our Pension Risk Transfer (PRT) team. In this role, you'll have the opportunity to impact our business in a meaningful way having a hand in all aspects for Pension Risk Transfer.Coding pricing model enhancements, and supporting Individual Case pricing initiativesDeveloping data and analytics...

  • Financial or Data Analyst

    3 weeks ago

    Des Moines, Iowa, United States Principal Financial Group Full time

    What You'll DoWe're looking for a Financial or Data Analyst to join our Pension Risk Transfer (PRT) team. In this role, you'll have the opportunity to impact our business in a meaningful way having a hand in all aspects for Pension Risk Transfer.Coding pricing model enhancements, and supporting Individual Case pricing initiativesDeveloping data and analytics...

  • Sales Data Analyst/Consultant

    1 week ago

    West Des Moines, Iowa, United States Athene Full time

    We are Athene. At Athene, we are driven to do more. We are a leading retirement services company that issues, reinsures and acquires retirement savings products designed for the increasing number of individuals and institutions seeking to fund retirement needs. We see every day as a new opportunity to measure ourselves against the best - and then we don't...

  • Data Engineer

    7 days ago

    West Des Moines, Iowa, United States Motion Recruitment Partners LLC Full time

    Data Engineer West Des Moines, IA Hybrid Contract $53.56/hr - $60.35/hr Outstanding long-term contract opportunity A well-known Financial Services Company is looking for a Database Engineer in West Des Moines, IA or Charlotte, NC (Hybrid). Work with the brightest minds at one of the largest financial institutions in the world. This is long-term contract...

  • Senior Provider Analyst

    7 days ago

    Des Moines, Iowa, United States Trinity Health Full time

    Employment Type:Full timeShift:Day ShiftDescription:POSITION PURPOSEMaintains and oversees the quarterly Specialty Physician Incentive Model calculations; accumulates necessary data for the model and analysis of the results. Responsible for biweekly review of Provider Compensation payroll data provided by Practice Managers and other key personnel, which...

  • Financial Analyst

    1 week ago

    Des Moines, Iowa, United States UnityPoint Health Full time

    OverviewSenior Financial Analyst position assists with financial planning and budgeting processes by developing financial models utilized to create financial plans and analyzing financial performance against those plans. This includes providing analytical consulting assistance to the administrative and managerial staff of the organization and being a...

  • Actuary

    1 day ago

    Des Moines, Iowa, United States Wellmark, Inc. Full time

    Company DescriptionWhy Wellmark: We are a mutual insurance company owned by our policy holders across Iowa and South Dakota, and we've built our reputation on over 80 years' worth of trust. We are not motivated by profits. We are motivated by the well-being of our friends, family, and neighbors-our members. If you're passionate about joining an organization...