Director, Data Science Operations

Kemper

Director of Data Science Operations at Merastar Insurance Company analyzing and defining data transformations. Leading analytics projects, developing database software, and evaluating tech needs.

Posted 7/17/2026full-timeRemote • Illinois • 🇺🇸 United StatesLead💰 $160,555 - $226,500 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in ETL architecture, data transformation, and analytics solutions, with a strong focus on AWS technologies and relational databases. Proven leadership in managing data science projects and implementing scalable data solutions.

Highest-signal resume keywords

ETL Architecture DesignSQL ProficiencyPython Data SkillsAWS TechnologiesData Transformation Strategy

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLPythonETLData TransformationDatabase Code DevelopmentData WarehousingData AnalyticsXML ParsingJSON ParsingEvent Oriented Architectures

Soft Skills

LeadershipTeam ManagementStrategic Analysis

Tools & Technologies

SnowflakePostgresAWS RedshiftAWS GlueAWS DynamoDBS3Apache KafkaAmazon KinesisSpark StreamingAirflow

Industry Keywords

Data Warehousing SpecialistDatabase ArchitectAnalytics SolutionsAI Model SupportProof of Concept (POC)

Tech Stack

Tools & technologies

AirflowAmazon RedshiftApacheAWSDynamoDBETLInformaticaJavaKafkaPandasPostgresPythonScalaSparkSQL

About the role

Key responsibilities & impact

Analyze, estimate & define data transformation req. to load data into EDW, Snowflake, Postgres, S3 (enterprise production & custom-built analytics environment).
Create ETL architecture & design flows to illustrate data mvmt from production to analytics environments (new & legacy AWS analytics environments).
Design & develop database code software.
Analyze project & make strategy for analytics data solutions & AI model support & deployment.
ETL & analytics S3 storage projects.
Lead analytics/data science ETL projects.
Lead team.
Evaluate organization's tech. needs, create POCs for new implementation or tech. enhancement & recommend improvements.

Requirements

What you’ll need

Bach. degree, or foreign equiv., in Comp Sci, Eng’g, Math, Physics or related field.
10 yrs exp. in job offered or as Database Architect or Data Warehousing Specialist.
10 yrs exp w/ SQL & adapt skills in multiple relational tech. (Redshift, Hive, SparkSQL etc.); event oriented, Reactive architectures.
8 yrs exp w/ Python data skills w/ Pandas, & XML/JSON parsing.
5 yrs exp w/ AWS tech. Redshift, Glue, DynamoDB, S3; streaming platforms such as Spark Streaming, Flink & workflow mgrs such as Airflow; at least one ETL tool such as Informatica, Pentaho, SAP, etc.
2 yrs exp implementing at scale, messaging sys. such as Amazon Kinesis or Apache Kafka; languages such as Java or Scala.

Benefits

Comp & perks

Qualify for your choice of health and dental plans within your first month.
Save for your future with robust 401(k) match, Health Spending Accounts and various retirement plans.
Learn and Grow with our Tuition Assistance Program, paid certifications and continuing education programs.
Contribute to your community through United Way and volunteer programs.
Balance your life with generous paid time off and business casual dress.
Get employee discounts for shopping, dining and travel through Kemper Perks.