Senior Data Modeler

Location(s)

Details

Kemper is one of the nations leading specialized insurers. Our success is a direct reflection of the talented and diverse people who make a positive difference in the lives of our customers every day. We believe a high-performing culture valuable opportunities for personal development and professional challenge and a healthy work-life balance can be highly motivating and productive. Kempers products and services are making a real difference to our customers who have unique and evolving needs. By joining our team you are helping to provide an experience to our stakeholders that delivers on our promises.

Position Summary:

We are seeking a highly skilled Senior Data Modeler to join our Data Engineering organization within a large enterprise-scale P&C and Life insurance this role you will lead the design and evolution of conceptual logical and physical data models that support underwriting claims policy administration billing actuarial finance and customer engagement domains. You will collaborate closely with data engineers data architects business SMEs and delivery teams to ensure data structures are robust scalable governed and analytics-ready.

This role is a key contributor to our enterprise data modernization journeyincluding cloud data platforms domain-oriented data ecosystems and advanced analytics/AI initiatives.

Position Responsibilities:

Data Modeling & Architecture

• Lead the design of enterprise-level conceptual logical and physical data models across P&C insurance domains.
• Translate complex business requirements into normalized dimensional and data vault models aligned with architectural standards.
• Design models supporting operational data stores (ODS) data lakes data warehouses and real-time/streaming data pipelines.
• Ensure data models follow industry best practices data governance standards and regulatory requirements (e.g. state/federal insurance regulations).

Collaboration & Delivery

• Work closely with Data Engineers to implement models in cloud-native environments (Snowflake/AWS).
• Partner with Business Analysts Product Owners Actuaries Underwriters and Claims SMEs to gather requirements and validate model designs.
• Support Enterprise Architecture and Data Governance in defining data standards naming conventions lineage and metadata.
• Review and optimize existing data models for scalability maintainability and performance.

Data Governance & Quality

• Ensure models align with enterprise data definitions master data management (MDM) and data quality rules.
• Collaborate with governance teams to maintain business glossaries taxonomies and data catalogs.
• Promote consistent data usage stewardship and compliance across the organization.

Documentation & Communication

• Produce clear standards-based model documentation and metadata.
• Present data model concepts to both technical and non-technical stakeholders.
• Mentor junior modelers and data engineers on modeling strategies and best practices.

Position Qualifications:

• Bachelors degree in Computer Science Information Systems Data Management or related field.
• 710 years of experience in data modeling within large complex environments.
• Proven expertise in:
  • Relational modeling (3NF)
  • Dimensional modeling (Kimball star/snowflake)
  • Data Vault 2.0 design
• Experience working within P&C insurance data domains (e.g. policy claims billing exposures reinsurance agent/producer).
• Strong proficiency with data modeling tools such as ERwin ER/Studio or Azure Data Modeling tools.
• Solid understanding of SQL data warehousing patterns cloud data platforms (Snowflake Databricks etc.) and AWS Ecosystem.
• Experience supporting data engineering pipelines and distributed data environments.

Preferred Qualifications:

• Familiarity with API data contracts event-driven modeling and streaming platforms (Kafka/Kinesis).
• Understanding of actuarial risk modeling regulatory reporting and financial analytics.
• Working knowledge of MDM and golden-record strategies.
• Cloud certifications (Snowflake AWS Azure or GCP) a plus.
• Sponsorship is not accepted for this opportunity.
• This position can be worked hybrid out of a local Kemper office including Chicago or Downers Grove IL. Remote working arrangements may be available to non-local candidates.
• The range for this position is $99000 to $164800. When determining candidate offers we consider experience skills education certifications and geographic location among other factors. This job is eligible for an annual discretionary bonus and Kemper benefits (Medical Dental Vision PTO 401k etc.)

Kemper is proud to be an equal opportunity employer. All applicants will be considered for employment without attention to race color religion sex sexual orientation gender identity national origin veteran disability status or any other status protected by the laws or regulations in the locations where we operate. We are committed to supporting diversity and equality across our organization and we work diligently to maintain a workplace free from discrimination.

Kemper does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Kemper and Kemper will not be obligated to pay a placement fee.

Kemper will never request personal information such as your social security number or banking information via text or Kemper does not use external messaging applications like WireApp or Skype to communicate with you receive such a message delete it.

#LI-JO1

#LI-Hybrid