Data Engineer II (Remote)

Inspira Financial Trust, LLC; Indianapolis (IN); Remote; USD 70,000 - 110,000; Full time

Job summary

An innovative firm is looking for a skilled Data Engineer to enhance their data ecosystem. This exciting role involves collaborating with a dedicated team to create scalable data platforms, develop ETL pipelines, and ensure data quality and reliability. The ideal candidate will thrive in a fast-paced environment, utilizing their expertise in SQL and Python while embracing opportunities for growth. Join a tight-knit group of lifelong learners committed to excellence, where your contributions will significantly impact both internal analytics and customer-facing reporting functionalities.

Qualifications

• Experience with setting up ETL pipelines and orchestration tools.
• Solid understanding of cloud data warehousing concepts.

Responsibilities

• Contribute to dimensional modeling and develop scalable data products.
• Write and optimize SQL queries for internal analytics and reporting.

Skills

SQL

Python

TypeScript

Node.js

Problem-solving

Communication

Tools

Terraform

Google Cloud

Job description

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.