Data Modeler
Remote
F&G
F&G offers life insurance and annuities to help you plan and protect your future. We value collaboration, authenticity, dynamics and empowerment.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 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.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Architecture Data Analytics Data management Data warehouse DDL Engineering ETL Informatica Mathematics Oracle Privacy Security Snowflake SQL
Perks/benefits: Flex hours Insurance Team events
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Marketing Data Analyst jobs
- Open Data Science Manager jobs
- Open MLOps Engineer jobs
- Open Data Engineer II jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Manager jobs
- Open Principal Data Engineer jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Junior Data Scientist jobs
- Open Sr Data Engineer jobs
- Open Business Data Analyst jobs
- Open Data Analytics Engineer jobs
- Open Business Intelligence Developer jobs
- Open Product Data Analyst jobs
- Open Data Analyst Intern jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Big Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Principal Data Scientist jobs
- Open Azure Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Research Scientist jobs
- Open Data Product Manager jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open Business Intelligence-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Deep Learning-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open PyTorch-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open LLMs-related jobs
- Open Generative AI-related jobs
- Open CI/CD-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs