Data Engineer II (Remote)

Inspira Financial; Chicago (IL); Hybrid; USD 91,000 - 111,000; Full time

Job summary

An innovative financial services company is looking for a mid-level Data Engineer to join their dynamic team. In this role, you will collaborate with engineers and business stakeholders to create scalable data platform solutions that enhance internal analytics and customer-facing reporting. This position emphasizes teamwork and a commitment to quality, ensuring that data integrity and reliability are prioritized. If you're eager to grow in a fast-paced environment and contribute to meaningful projects that impact millions, this opportunity is perfect for you.

Qualifications

• 3-5 years of experience in data engineering roles.
• Strong understanding of cloud data warehousing concepts.

Responsibilities

• Develop and maintain scalable data products and ETL pipelines.
• Optimize SQL queries for internal analytics and reporting.

Skills

SQL

Python

TypeScript

Node.js

Data Governance

Problem Solving

Communication Skills

Education

Bachelor's degree in Computer Science

Tools

Google Cloud

Terraform

Job description

Join Us!
Take the next step in your journey at Inspira Financial. You will help businesses and individuals thrive today, tomorrow, and into retirement. Become part of a company that is people-centric and client-obsessed in every interaction; a community of forward-thinking individuals focused on driving results to deliver our mission with an unwavering commitment to integrity. Join us as we strengthen and simplify the health and wealth journey -- relentlessly pursuing better outcomes for all.

We believe in finding the best talent! While some roles are based at one of our office locations, remote roles can sit in any of the following states: AL, AZ, FL, GA, IA, IL, IN, MI, MN, MO, NC, NE, PA, SC, TN, TX, UT, VA, and WV. Remote status and role locations are subject to change. Relocation is not provided.

Employees within a 90-minute radius of our Oak Brook, IL headquarters are required to adhere to the company in-office work guidelines of 4 days per month minimum from 10 am to 2 pm (1 of the 4 days must be a Monday or Friday). This requirement does not apply to support specialist positions.

Don't meet every single requirement? Here at Inspira Financial, we believe there is no "perfect" candidate and want to encourage applying even if all the requirements listed aren't met. Our goal is to build an authentic workplace by valuing diversity in our candidates. We work to ensure that our team reflects the diversity of the businesses and clients we serve. We are always looking to expand our growing team with dynamic and enthusiastic individuals. If you enjoy a collaborative, fun environment that champions career development, Inspira Financial is the place for you! We look forward to receiving your application! Check out this Inspira Financial video to learn more about our company!

Inspira Financial provides health, wealth, retirement, and benefits solutions that strengthen and simplify the health and wealth journey. With more than 7 million clients, representing over $62 billion in assets, Inspira works with thousands of employers, plan sponsors, recordkeepers, TPAs, and other institutional partners -- helping the people they care about plan, save, and invest for a brighter future. Inspira relentlessly pursues better outcomes for all with our automatic rollover services, health savings accounts, emergency savings funds, custody services, and more. Learn more at inspirafinancial.com.

We have been recognized for our remarkable growth on lists such as Crain's Fast 50 and Inc. 5000, and for our outstanding workplace culture and benefits with Built In's 2025 Best Places to Work and Gallagher's 2022 Best-In-Class Employer awards.

Job Summary & Responsibilities

We are seeking a talented Data Engineer to join our growing team. This role is responsible for collaborating with an experienced team of engineers and business stakeholders to create scalable data platform solutions to support both our internal business analytics and the customer-facing reporting functionality of our application. As a mid-level Data Engineer, you will take ownership of key components in our data ecosystem. Additionally, we value individuals who are team players, possess a keen eye for detail, and prioritize outcomes over outputs.

Our engineering teams are built on the principle of humans over code. We are a tight-knit group of lifelong learners in a constant quest to be a team that is greater than the sum of its parts. Come join us!

Duties & Responsibilities:

• Contribute to dimensional modeling and the development of scalable data products.
• Perform data transformations using SQL and Python based data frameworks.
• Developing and maintaining batch and streaming ETL pipelines.
• Write and optimize SQL queries for internal analytics and reporting.
• Create and maintain Looker explores and business reports.
• Write and maintain infrastructure as code using Terraform.
• Document data flows, Entity-Relationship Diagrams, and contribute to our data catalog.
• Improve data quality, reliability, and observability in our pipelines and datasets.
• Participate in peer-reviews of solution designs and code reviews.

Requirements:

• Proficiency with SQL, Python, experience with TypeScript or Node.js is a plus.
• Solid understanding of cloud data warehousing concepts (preferably in Google Cloud).
• Experience setting up ETL pipelines, and orchestration tools.
• Good understanding of data lakes.
• Familiarity with data governance concepts.
• Strong problem-solving and communication skills.
• Eagerness to learn and grow in a fast-paced data environment.
• Exposure to data privacy and compliance requirements is nice to have.
• Knowledge of data products and data mesh architectures.
• Nice to have, experience with MLOps and ML pipeline support.

Preferred Qualifications

• 3-5 years of experience in data engineering roles.
• Bachelor's degree in computer science or equivalent experience.

Compensation & Benefits

$91,000-$111,000 per year