Data Engineer II

Kansas City Life Insurance Company; Kansas City (MO); On-site; USD 90,000 - 120,000; Full time

Job summary

Kansas City Life Insurance Company is seeking an energetic IT professional to join our data engineering team in Kansas City. The role focuses on transforming data, building scalable ETL pipelines, and delivering reliable data models for business analysis.

The ideal candidate has a solid background in SQL databases, Python for ETL scripting, and experience with multiple DB technologies (SQL Server, MySQL, PostgreSQL, AWS RedShift, ElasticSearch).

Qualifications

• B.S./B.A. in Engineering, Computer Science, or equivalent work experience.
• 3+ years building processes for data transformation, metadata, and workload management.
• SQL proficiency with relational databases and query authoring.
• Experience with large disconnected datasets and multiple DB technologies.
• Experience in OO programming languages (Python, Java, C++, etc.).
• Strong documentation of data models and data accuracy measures.
• Excellent verbal and written communication and problem solving.

Responsibilities

• Transform data into analysable formats with scalable, secure pipelines.
• Develop high-performance ETL processes and data modeling prototypes.
• Create data set processes for modeling, mining and production.
• Assemble large, complex data sets meeting business requirements.
• Integrate new data tools into existing structures and improve processes.
• Document changes and ensure QA and change management compliance.

Skills

SQL

Python

ETL scripting

Data modeling

Data transformation

Communication

SOLID principles

Education

Bachelor's degree in Engineering or Computer Science

Tools

SQL Server

MySQL

PostgreSQL

AWS RedShift

ElasticSearch

Job description

Kansas City Life Insurance Company, a recognized leader in the insurance industry, is seeking an energetic, self-motivated individual to join our IT department. The ideal candidate would meet the following requirements:

QUALIFICATIONS/REQUIREMENTS:

• B.S. or B.A. degree in Engineering, Computer Science, or equivalent work experience
• At least 3 years of experience building processes that support data transformation, data structures, metadata, dependency and workload management
• Working SQL knowledge and at least 3 years of experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases
• A successful history of manipulating and processing large disconnected datasets
• Experience with multiple database technologies: SQL Server, MySQL, PostgreSQL, AWS (RedShift, ElasticSearch)
• Experience with object-oriented/object function scripting languages: Python, R, Java, C++, Scala, etc.
• Experience implementing and documenting data models and schema for new database structures and applications and implement measures to ensure data accuracy and accessibility
• Effective verbal and written communication skills
• Demonstrated understanding of technology and value to business
• Exceptional problem-solving skills
• At least 3 years of experience with Python for ETL scripting or similar high level programming languages preferred
• Experience in object-oriented programming and SOLID principles desired
• Regular and reliable attendance and punctuality is an essential function of this position.

DUTIES/RESPONSIBILITIES:

• Transform data into a format that can be easily analyzed, ensuring system scalability, security, performance and reliability
• High level understanding of Python is required to create, update and maintain our ETL data pipelines
• Build high-performance ETL processes, algorithms, prototypes for data modeling, mining, and production
• Develop data set processes for data modeling, mining and production
• Assemble large, complex data sets that meet functional / non-functional business requirements
• Integrate new data management technologies and software engineering tools into existing structures
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, and re-designing infrastructure for greater scalability
• Maintain proper documentation and adhere to change management processes as well as ongoing performance of quality assurance on all business-impacting processes

Kansas City Life Insurance Company offers a competitive salary and an excellent benefits package.

Kansas City Life Insurance Company

ATTN: Human Resources Department
3520 Broadway
P.O. Box 219139
Kansas City, MO 64121-9139
EOE/MFVH
e-mail: [e-mail]