Senior Data Modeler

Job Description

An insurance company is looking for an experienced Data Modeler with strong knowledge of insurance products and data modeling principles to join the Data Management team supporting the Actuarial Transformation initiatives. This role is critical for designing and maintaining enterprise data models that support business processes and analytics. The ideal candidate will combine technical expertise with business acumen to ensure models align with organizational goals and regulatory standards.

Experience working cross functionally with technical engineers and architects, as well as business stakeholders will be critical for a successful delivery. The team works core PST hours and this will be full-time 40 hours a week.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances.

If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to  learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy:

• Design and Develop Source-Agnostic Data Models:
• Create conceptual, logical, and physical data models for insurance-related products, ensuring scalability and compliance with enterprise standards.
• Translate Business Requirements:
• Work closely with actuaries, business analysts, and IT teams to convert complex insurance product requirements into robust data structures.
• Data Governance & Documentation:
• Maintain metadata, data dictionaries, and ER diagrams; ensure adherence to modeling best practices and naming conventions.
• Support Integration & Migration:
• Assist in onboarding new data sources, mapping legacy systems, and supporting ETL processes for actuarial and reporting platforms.
• Collaboration:
• Partner with cross-functional teams to validate models, troubleshoot issues, and optimize data model performance for reporting and analytics.

• Strong understanding of insurance products (Employee Benefits, Investments, Annuities, Life, Disability, etc.) and related business processes.
• Engage actively with business SMEs, drive conversations, document business products/processes and translate that knowledge into data models.
• Proficiency in data modeling concepts (normalization, dimensional modeling, ER diagrams) and single-source-of-truth concepts/repositories.
• Experience with relational databases (SQL Server, Oracle, or similar).
• Familiarity with data warehousing and ETL frameworks.
• Experience with ER Studio preferred (or similar tools like ERwin, Power Designer).
• Excellent communication, problem-solving ability, and capacity to work independently in a fast-paced environment. Familiarity with cloud-based data platforms (e.g., Azure, Databricks) is a plus.
• Knowledge of actuarial or financial products and data structures.
• Exposure to metadata management and data governance frameworks.