Data Engineer

The Lewer Companies•Overland Park, KS

11d•$90,000 - $100,000•Hybrid

About The Position

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.

Requirements

Degree in data science, information technology, data engineering, or a highly quantitative field, or equivalent practical experience.
2–4 years of experience in data analytics, software engineering, or data pipeline.
Proficiency in SQL.
Proficiency in Power BI.
Proficiency in data platforms (Azure/Microsoft Fabric).
Proficiency in scripting languages (Python).
Experience in data modeling and visualization best practices.
Experience with AI/ML concepts and tools.
Strong analytical thinking.
Clear communication skills.
Ability to collaborate across departments.
Ability to maintain integrity in data handling.

Responsibilities

Design, maintain, and document the Lewer Companies data architecture, ETL processes, and data flow.
Ensure business data is reliably collected, integrated, stored, backed up, scheduled, and monitored.
Support accurate reporting, analytics, and operational needs while maintaining data integrity, availability, and security.
Combine business intelligence with AI innovation to shape the future of data strategy.
Build scalable systems that extract data from a variety of sources (APIs, CRM tools, applications, web traffic).
Execute ETL/ELT processes (extract, transform, load) to clean, reform, aggregate, and structure raw data into readable formats.
Automate data workflows using orchestration tools to ensure continuous data delivery without manual intervention.
Design and maintain storage solutions like enterprise data warehouses, data lakes, and lake houses.
Optimize database performance by fine-tuning queries, managing data partitioning, and scaling the big data infrastructure.
Implement security protocols and access controls to safeguard data systems against unauthorized access, leaks, or breaches.
Enforce data quality standards by building monitoring systems that flag anomalies, corrupt data, or broken streams.
Protect the Lewer Companies through compliance with internal controls and regulatory requirements.
Support Technology and Analytics teams by structuring complex data sets required to train machine learning models and populate business dashboards.
Translate business requirements from stakeholders and executive leadership into robust, technical data models.