Data Engineer II (Remote)

Inspira Financial Trust, LLC in; Oak Brook (IL); Remote; USD 80,000 - 110,000; Full time

Job summary

An innovative financial services firm is on the lookout for a skilled Data Engineer II to join their remote team. This role emphasizes collaboration with engineers and business stakeholders to build scalable data platform solutions that enhance internal analytics and customer reporting functionalities. The ideal candidate will have a strong foundation in SQL and Python, along with experience in cloud environments, particularly Google Cloud. Join a tight-knit group dedicated to continuous learning and improvement, where your contributions will significantly impact the data ecosystem and overall business outcomes.

Qualifications

• Proficiency in SQL and Python with experience in data transformations.
• Strong understanding of ETL processes and cloud data warehousing.

Responsibilities

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

Skills

SQL

Python

Data Transformation

ETL Pipelines

Problem-Solving

Communication Skills

Tools

Looker

Terraform

Google Cloud

Node.js

Job description

Data Engineer II (Remote) (Finance)

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.