Sr. Data Modeler (RDBMS Modeling)

Job SummaryThe 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 ResponsibilitiesDesign 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 DDLExperience And Education RequirementsAssociate’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 levelExperience and familiarity with ACORD/DTCC is a plus.Experience with SQL Server, Oracle and/or Snowflake platformsFinancial Services or Insurance industry experience preferredExperience working with Data Engineering and Data Analytics teamsKnowledge, Skills & AbilitiesUnderstanding of principles and standard methodologies around Data ArchitectureFamiliarity with ETL tools such as Informatica or Informatica Data Management CloudFamilariity 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 ErwinExperience 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 audienceKnowledge of metadata management and related tooling (e.g., Informatica Data Management Cloud, Refrerence Data Management)Solid grasp of Database technologies, techniques, and trendsStrong interpersonal communication skills, written and verbalFast, adaptive learner Ability to manage multiple tasks and deadlines simultaneouslyExhibits flexibility and tolerance for ambiguity with the ability to thrive in a rapidly changing business environmentResults-oriented & Dedicated work ethicOther RequirementsPerform other functions, duties and projects as assignedRegular and punctual attendanceMinimal travel required (less than 10%)Additional InformationWork EnvironmentsF&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 CareersAbout F&GSince 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.