About the Role
Director, Data Science Operations sought by Merastar Insurance Company to analyze, estimate, and define data transformation requirements for loading data into EDW, Snowflake, Postgres, and S3. This role involves creating ETL architecture, designing data movement flows, developing database code, and strategizing analytics data solutions and AI model support.
Responsibilities
- Analyze, estimate & define data transformation requirements to load data into EDW, Snowflake, Postgres, S3.
- Create ETL architecture & design flows to illustrate data movement from production to analytics environments.
- Design & develop database code software.
- Analyze projects & 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.
Requirements
- Bachelor's degree, or foreign equivalent, in Computer Science, Engineering, Math, Physics or related field.
- 10 years of experience in the job offered or as a Database Architect or Data Warehousing Specialist.
- 10 years of experience with SQL and adaptive skills in multiple relational technologies (Redshift, Hive, SparkSQL etc.).
- 8 years of experience with Python data skills with Pandas, and XML/JSON parsing.
- 5 years of experience with AWS technologies: Redshift, Glue, DynamoDB, S3.
- 5 years of experience with streaming platforms such as Spark Streaming, Flink.
- 5 years of experience with workflow managers such as Airflow.
- 5 years of experience with at least one ETL tool such as Informatica, Pentaho, SAP, etc.
- 2 years of experience implementing at scale, messaging systems such as Amazon Kinesis or Apache Kafka.
- 2 years of experience with languages such as Java or Scala.
- Up to 5% short-term, domestic travel may be involved to attend industry conferences.
Skills
- SQL
- Redshift
- Hive
- SparkSQL
- Python
- Pandas
- XML/JSON parsing
- AWS
- Redshift
- Glue
- DynamoDB
- S3
- Spark Streaming
- Flink
- Airflow
- Informatica
- Pentaho
- SAP
- Amazon Kinesis
- Apache Kafka
- Java
- Scala
- Event oriented architectures
- Reactive architectures
Location
- Chicago, Illinois
- Remote-AK
- Remote-AL
- Remote-AR
- Remote-AZ
- Remote-CA
- Remote-CO
- Remote-CT
- Remote-DE
- Remote-FL
- Remote-GA
- Remote-HI
- Remote-IA
- Remote-ID
- Remote-IL
- Remote-IN
- Remote-KS
- Remote-KY
- Remote-LA
- Remote-MA
- Remote-MD
- Remote-ME
- Remote-MI
- Remote-MN
- Can work from anywhere in U.S.
Work Type
- 40 hrs./wk.
- Remote working benefits available
Experience Level
- 10 years experience
- 8 years experience
- 5 years experience
- 2 years experience
Education Level
- Bachelor's degree, or foreign equivalent, in Computer Science, Engineering, Math, Physics or related field.
Salary/Compensations
- $160,555 to $226,500
Benefits
- Medical
- Dental
- Vision
- PTO
- 401k
- Annual discretionary bonus
- 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.
About the Company
- The Kemper family of companies is one of the nation’s leading specialized insurers.
- With approximately $12 billion in assets, Kemper is improving the world of insurance by providing affordable and easy-to-use personalized solutions to individuals, families and businesses through its Kemper Auto and Kemper Life brands.
- Kemper serves over 4.6 million policies, is represented by approximately 24,200 agents and brokers, and has approximately 7,500 associates dedicated to meeting the ever-changing needs of its customers.
- Alliance United Insurance Company is not rated.
Equal Opportunity
- We value diversity and strive to be an employer of choice.
- An Equal Opportunity Employer, M/F/D/V
