Data Engineer II

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

Job summary

Kansas City Life Insurance Company is seeking a data engineer to focus on data transformation, ETL pipeline development, and database management. This role offers the chance to work with a variety of database technologies and requires a strong programming background in Python, SQL, and data modeling.

The ideal candidate will possess excellent communication skills, problem-solving abilities, and experience with large datasets. Join a team committed to creating effective data solutions while adhering to best practices in documentation and change management.

Qualifications

• 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.
• Effective verbal and written communication skills.

Responsibilities

• Transform data into a format that can be easily analyzed.
• Build high-performance ETL processes and algorithms.
• Identify, design, and implement internal process improvements.

Skills

Data transformation

Python for ETL

SQL knowledge

Problem-solving

Communication skills

Education

B.S. or B.A. in Engineering or Computer Science

Tools

SQL Server

MySQL

PostgreSQL

AWS RedShift

ElasticSearch

Job description

Qualifications

• 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
• At least 3 years of experience with Python for ETL scripting or similar high level programming languages preferred
• 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 implementing 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
• Experience in object-oriented programming and SOLID principles desired.

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 is committed to equal employment opportunities for all individuals regardless of race, religion, color, sex, age, national origin, disability, or genetic information.

Regular and reliable attendance and punctuality is an essential function of this position.