Sr. Data Modeler (RDBMS Modeling)

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