Sr. Data Modeler

1 month ago

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

Job Summary

The Sr. 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 Sr. Data Modeler will have responsiblity 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 pracitces 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 responsibe 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.
  • 4-7 years of experience working in a Database Administration role with a minimum of 3 years of relevant data modeling experience delivering data lake, data warehouse and reporting platforms.
  • Strong proficiency and experience in Data modeling (Conceptual, Logical, Physical, 3nF, Dimensional) at both a project and enterprise level
  • Experience and familiarity with ACORD/DTCC is a plus.
  • Experience with SQL Server, Oracle and/or Snowflake platforms
  • Financial Services or Insurance industry experience preferred
  • Experience working with Data Engineering and Data Analytics teams

Knowledge, Skills & Abilities

  • Understanding of principles and standard methodologies around Data Architecture
  • Familiarity with ETL tools such as Informatica or Informatica Data Management Cloud
  • Familariity 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 talentacquisition@fglife.com.

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.

  • Hydrologic Modeling Expert

    2 days ago

    Des Moines, Iowa, United States Houston Engineering, Inc. Full time

    Job SummaryWe are seeking a highly skilled Water Resources Engineer to join our team at Houston Engineering, Inc. in Des Moines, IA.Key ResponsibilitiesPerform hydrologic and hydraulic modeling of rural watersheds and riverine systems, and process GIS data to support modeling efforts.Support field investigations, including data collection and analysis, to...

  • Sr. Population Health Data Analyst

    2 months ago

    West Des Moines, United States The Iowa Clinic Full time

    Sr. Population Health Data Analyst Quality/Care Management West Des Moines, Iowa Apply Description The Iowa Clinic is looking for a Population Health Data Analyst to lead key strategic analytical projects for the organization, focused on population health, value-based contract, and clinically integrated network (CIN) strategies. This includes but is not...

  • Sr. Associate Actuary, ALM

    2 months ago

    Des Moines, United States Fidelity & Guaranty Life Insurance Company Full time

    Job DescriptionJob DescriptionJob SummaryThe Sr. Associate Actuary is responsible for leading the process for inforce asset projections and analyzing over multiple scenarios. The Asset Projection team assists with running asset projection models and owning the model output. This role is responsible for conducting projections, performing analysis, providing...

  • Sr. Treasury Analyst

    4 weeks ago

    Des Moines, United States Fidelity & Guaranty Life Insurance Company Full time

    Job DescriptionJob DescriptionThe Sr. Treasury Analyst – Treasury is responsible for supporting the day-to-day cash positioning of the company, including the timely and accurate accounting, managing and reporting of cash balances and movements in our various accounts. In addition this position will support the creation of our liquidity forecast and other...

  • Sr. ETL Developer

    1 month ago

    Des Moines, Iowa, United States Farm Bureau Financial Services Full time

    Sr. ETL Developer - InformaticaCan you work onsite at our office in Des Moines Iowa? Do you have experience developing and maintaining data loads and batch processes in Informatica? Can you maintain technical expertise to aid other information technology personnel? If so, this Sr ETL developer position could be a fit for youWork Authorization/Sponsorship:...

  • Data Scientist

    4 weeks ago

    Des Moines, United States Fidelity & Guaranty Life Insurance Company Full time

    Job DescriptionJob DescriptionF&G is looking to hire for a Data Scientist - Retail The Data Scientist position will provide leadership for data science initiatives and derive actionable insights from complex datasets. This position will play a key role in shaping advanced analytics, developing advanced analytical models, and mentoring team members. This...

  • Financial Data Manager

    2 months ago

    Des Moines, United States Comtech LLC Full time

    Job DescriptionJob DescriptionFinancial Data ManagerDes Moines IA (Onsite)12+ months ContractClient is looking for a highly motivated person specializing in Data Science, Analytics with a focus in Financial Data Management. OCIO is committed to utilizing modern technologies and methodologies in order to deliver secure, high-quality solutions to its business...

  • Financial Data Manager

    2 months ago

    Des Moines, United States Comtech LLC Full time

    Job DescriptionJob DescriptionFinancial Data ManagerDes Moines IA (Onsite)12+ months ContractClient is looking for a highly motivated person specializing in Data Science, Analytics with a focus in Financial Data Management. OCIO is committed to utilizing modern technologies and methodologies in order to deliver secure, high-quality solutions to its business...

  • Sr Sales Support Specialist

    1 month ago

    Des Moines, United States Motorola Solutions Full time

    Company Overview At Motorola Solutions, we're guided by a shared purpose - helping people be their best in the moments that matter - and we live up to our purpose every day by solving for safer. Because people can only be their best when they not only feel safe, but are safe. We're solving for safer by building the best possible technologies across every...

  • Sr. Java Developer

    7 days ago

    Des Moines, United States Strategic Staffing Solutions Full time

    Sr. Java Developer- W2 Only Location: Des Moines, IA Setting: Hybrid Contract: 12 months Pay rate: $75+/hr “Beware of scams. S3 never asks for money during its onboarding process.” Job Description: In this contingent resource assignment, you may: Consult on complex initiatives with broad impact and large-scale planning for...

  • Senior Data Architect

    3 months ago

    Des Moines, 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 solutions - Required 10Years Experience designing/architecting business intelligence/reporting platforms - Required 10Years Experience integrating data from multiple systems built using...

  • Senior Data Architect

    3 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...

  • Sr. Associate Actuary, Actuarial ALM

    3 months ago

    Des Moines, United States Fidelity & Guaranty Life Insurance Company Full time

    Job DescriptionJob DescriptionJob SummaryThe Sr. Associate Actuary supports the modeling required for various corporate reporting metrics, including the support of the Multi Year Plan, Cash Flow Testing, ALM, and other strategic initiatives within the company.OrganizationThis position reports to the AVP, Actuarial Asset Liability Modeling. This person will...

  • Data Science Consultant

    1 week ago

    Des Moines, United States Wellmark, Inc. Full time

    Job DescriptionJob DescriptionCompany 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...

  • Data Science Consultant

    1 month ago

    Des Moines, United States Wellmark, Inc. Full time

    Job DescriptionJob DescriptionCompany 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...

  • Data Science Associate

    1 month ago

    Des Moines, United States Wellmark, Inc. Full time

    Job DescriptionJob DescriptionCompany 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...

  • Sr BSA

    2 weeks ago

    West Des Moines, United States Athene Holding Ltd 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 Engineering Manager

    2 months ago

    Des Moines, Iowa, United States EMC Insurance Full time

    At EMC, you'll put your skills to good use as an important member of our team. You can count on gaining valuable experience while contributing to the company's success. EMC strives to hire and retain the best people by engaging, developing and rewarding employees.Essential Functions: Executes the enterprise data management roadmap and plans, tracks, and...

  • Sr. Financial Controls Advisor

    2 months ago

    Des Moines, United States Fidelity & Guaranty Life Insurance Company Full time

    Job DescriptionJob DescriptionJob SummaryThe Sr. Financial Controls Advisor partners with leaders and stakeholders across the company to provide dedicated financial risk and controls expertise. This position will be a trusted advisor to business areas to ensure the health and efficiency of the internal control environment. The position will also be...

  • Sr. Financial Controls Advisor

    15 hours ago

    Des Moines, United States Fidelity & Guaranty Life Business Services Full time

    Job Summary The Sr. Financial Controls Advisor partners with leaders and stakeholders across the company to provide dedicated financial risk and controls expertise. This position will be a trusted advisor to business areas to ensure the health and efficiency of the internal control environment. The position will also be responsible for making valuable...