CareerPlan

Junior Business Intelligence Engineer

Cincinnati, OhioFull-time2026-09-28 → 2026-11-13
Based in United States

Core

Design, build, and maintain scalable data pipelines and production-ready data products to serve as the enterprise system of record for reporting and downstream applications.

Role type

Junior Business Intelligence Engineer (Data Engineering)

Builds

Production-grade data pipelines, shared data models, and reusable data products

Domain

Healthcare / Clinical Research / Data Engineering

Required skills

Python, SQL, relational databases, data warehousing, ETL/ELT patterns, data modeling, Git, automated testing, CI/CD

Preferred skills

Cloud data platforms (Azure, Snowflake), orchestration tools (Airflow, dbt, Databricks), Infrastructure as Code (Terraform, Bicep), dimensional modeling

Technologies

Python, SQL, Azure, Snowflake, Airflow, dbt, Databricks, Git, Terraform

Responsibilities

Design and build scalable batch and event-driven data pipelines; Ingest and integrate data from enterprise applications, databases, files, APIs, and cloud platforms; Develop reusable, well-documented data products and analytical models; Implement automated data quality checks, reconciliation controls, schema validation, and monitoring; Partner with stakeholders to define data contracts and acceptance criteria; Optimize pipeline performance, reliability, and cost; Write clean, tested, documented code and participate in peer reviews; Investigate pipeline failures and perform root-cause analysis.

Seniority

Junior, hands-on IC