Data Engineer

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 departments while maintaining integrity in data handling.

This Impact Description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities required of the Associate for this seat. Duties, responsibilities and activities may change at any time with or without notice. Associate must be able to perform the essential functions of the position satisfactorily and, if requested, reasonable accommodations will be made to enable Associates with disabilities to perform the essential functions of their job, absent undue hardship.

More about us:

Our Core Values

You live the following “ Lewer Core Values ” in your daily work:

I've Got This - Always takes care of business; assumes responsibility, supports accountability, leads by example.

Kaizen - Embodies constant improvement; always asks why and continuously improves our processes.

Results With Integrity - Commits to strong moral and ethical principles in the pursuit of excellence.

Good Vibes - Takes care of one another; works enthusiastically, treats others professionally and respectfully.

The Team

Lewer runs on the Entrepreneurial Operating System (EOS). That means as a member of this team, your manager is committed to:

• Giving clear directions.
• Providing the necessary tools.
• Acting with the greater good in mind.
• Delegating.
• Understanding your role and how you can help the company.
• Providing clear expectations.
• Communicating effectively.
• Running effective meetings.
• Meeting one-on-one with you quarterly or more, if needed.
• Rewarding and recognizing your performance.

It also means you are committed to the EOS life by doing what you love, with people you love. You make a huge difference, are compensated appropriately, and take time to pursue personal passions.

Your coworkers are a diverse group of professionals across all the business units of Lewer. They are highly skilled professionals who are passionate about their work and committed to achieving Lewer’s goals. They are collaborative and eager to work together to identify opportunities for improvement and find solutions to complex business challenges.

Benefits

Some benefits Lewer offers its Associates include:

• Employer-paid medical, dental & vision insurance
• Employer-paid short-term disability, long-term disability and life insurance
• $1,500 Employer HSA annual contribution
• 5% 401(k) match with 100% immediate vesting