Director, Data Science Operations

KemperNew York, NY
$160,555 - $226,500Remote

About The Position

Merastar Insurance Company is seeking a Director, Data Science Operations in Chicago, IL. This role involves analyzing and estimating data transformation requirements for loading data into EDW, Snowflake, Postgres, and S3. The position requires creating ETL architecture and data movement flows, designing and developing database code, and strategizing analytics data solutions and AI model support. Responsibilities include managing ETL and analytics S3 storage projects, leading analytics/data science ETL projects, and evaluating the organization's technology needs, including creating Proofs of Concept (POCs) and recommending improvements. Remote working benefits are available, and the role allows for working from anywhere in the U.S.

Requirements

  • 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.).
  • 10 yrs exp w/ Python data skills w/ Pandas, & XML/JSON parsing.
  • 5 yrs exp w/ AWS tech. Redshift, Glue, DynamoDB, S3.
  • 5 yrs exp w/ streaming platforms such as Spark Streaming, Flink & workflow mgrs such as Airflow.
  • 5 yrs exp w/ 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.
  • Experience with languages such as Java or Scala.

Nice To Haves

  • Event oriented, Reactive architectures.

Responsibilities

  • 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.
  • Manage 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.

Benefits

  • Medical
  • Dental
  • Vision
  • PTO
  • 401k
  • Annual discretionary bonus
  • Health Spending Accounts
  • Various retirement plans
  • Tuition Assistance Program
  • Paid certifications
  • Continuing education programs
  • Paid volunteer time
  • Employee discounts for shopping, dining and travel through Kemper Perks
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service