Data Engineer Job Overland Park Kansas USA,IT/Tech

Description

Who we are:

Since 1956, Lewer has served as an advocate for independent business owners who seek to protect what they’ve built and prepare for the future. In 1991, our student division was formed to protect people around the world.

Lewer offers a concierge approach to employee and student insurance by providing tailored benefit strategies designed to create healthier businesses, families, and individuals.

What you’ll do at Lewer:

Roles and Responsibilities

As the Data Engineer, you design, maintain, and document the Lewer Companies data architecture, ETL processes, and data flow. You ensure business data is reliably collected, integrated, stored, backed up, scheduled, and monitored to support accurate reporting, analytics, and operational needs while maintaining data integrity, availability, and security. You also combine business intelligence with AI innovation to shape the future of data strategy.

Your

Key Areas of Impact Organizational Intelligence:

You play a central role in cultivating a culture of evidence-based decision-making. Through data pipeline development and ELT/ETL management, you build scalable systems that extract data from a variety of sources (APIs, CRM tools, applications, web traffic) and execute ETL/ELT processes (extract, transform, load) to clean, reform, aggregate, and structure raw data into readable formats. Finally, you automate data workflows using orchestration tools to ensure continuous data delivery without manual intervention.

Infrastructure

& Data Architecture:

You design and maintain storage solutions like enterprise data warehouses, data lakes, and lake houses. You optimize database performance by fine-tuning queries, managing data partitioning, and scaling the big data infrastructure to minimize lag and bottlenecks.

Data Governance & Security:

You implement security protocols and access controls to safeguard data systems against unauthorized access, leaks, or breaches. You enforce data quality standards by building monitoring systems that flag anomalies, corrupt data, or broken streams before they disrupt downstream workflows. You protect the Lewer Companies through compliance with internal controls and regulatory requirements.

Cross-Functional Collaboration:

You support Technology and Analytics teams by structuring complex data sets required to train machine learning models and populate business dashboards. You translate business requirements from stakeholders and executive leadership into robust, technical data models, to improve company decision making.

The Work Environment, Physical Demands & Travel

Your work is conducted at the Lewer Administrative Offices, with eligibility to work from home in accordance with company policy. You must be able to remain in a stationary position 75% of the time, and be able to occasionally move about inside the office to access filing cabinets, office machinery, etc. You will operate a computer and other office productivity machinery, such as a phone, calculator, copy machine and computer printer 75% of the time.

You will need to be able to lift 25 lbs. Travel is not required for this seat.

Your qualifications:
Requirements

You may hold a degree in data science, information technology, data engineering, or a highly quantitative field. Equivalent practical experience of specialized bootcamps is also heavily weighted, with 2–4 years of experience in data analytics, software engineering, or data pipeline. You are proficient in SQL, Power BI, data platforms (Azure/Microsoft Fabric) and scripting languages (Python), with experience in data modeling and visualization best practices, and AI/ML concepts and tools.

You demonstrate strong analytical thinking, clear communication, and the ability to collaborate across…