Mid-level Data Engineer

Company overview:

Blue Orange Digital is a boutique data & AI consultancy that delivers enterprise-grade results. We design and build modern data platforms, analytics, and ML/AI Agent solutions for mid‑market and enterprise clients across Private Equity, Financial Services, Healthcare, and Retail.

Our teams work with technologies like Databricks, Snowflake, dbt, and the broader Microsoft ecosystem to turn messy, real-world data into trustworthy, actionable insight.

We’re a builder‑led, client‑first culture that prizes ownership, clear communication, and shipping high‑impact work.

Note: Please submit your resume in English, as all application materials must be in English for review and consideration.

Position Overview

We are looking for a mid-level Data Engineer to join the data team of a growth equity firm. You will work in a large, production dbt project on Snowflake that powers firm-wide analytics and investment decisions. The project brings together CRM, market intelligence, and proprietary data sources, and it includes AI-powered models for entity tagging.

This is an execution-focused role: a senior engineer scopes the work, and you build, test, and maintain models. As you learn the codebase, you can take on more ownership.

What You Will Do

• Build and maintain staging and intermediate dbt models in a medallion architecture (600+ staging views, 160+ intermediate models, 120+ marts)

• Implement entity resolution logic (ID and bridge tables for companies, contacts, and deals) from designs set by senior engineers

• Implement and maintain AI-powered tagging models using Snowflake Cortex, and flag quality issues for review

• Write tests for every model you touch: schema validation, row counts, nullability, and uniqueness

• Maintain source-system bridges and lookup tables, and adapt models when upstream systems change

• Keep source YAML documentation current, including lineage, freshness expectations, and schema notes

• Monitor dbt Cloud jobs, debug failed runs, and investigate data inconsistencies, escalating when needed

• Submit clean, well-documented pull requests for senior review

What You Bring

• 2–4 years of data engineering experience in a production environment

• Solid SQL: multi-stage CTEs, window functions, and well-optimized queries

• Working knowledge of dbt: models, tests, sources, and basic macros

• Experience with Snowflake or a similar cloud data warehouse (BigQuery, Redshift, Databricks)

• Comfort with dimensional modeling and layered (medallion) architectures

• Git and GitHub workflows: branching, pull requests, and code review

• Strong written English and reliable async communication with a remote US-based team

• Availability at least 20 hours per week, with at least 4 hours of overlap with US Eastern time (Mon–Thu)

Nice to Haves

• Python for data validation or transformation logic

• dbt macros and Jinja templating

• Exposure to investment, financial, or alternative data

What We Offer

• Flexible part-time schedule, fully remote

• Hands-on work in a mature, production dbt and Snowflake codebase, including AI-powered models

• Mentorship from senior data engineers and a clear path to more ownership

• Builder culture where engineers lead and ship

• Work on diverse, challenging projects across industries

Benefits:

• Fully remote

• Flexible Schedule

• Unlimited Paid Time Off (PTO)

• Paid parental/bereavement leave

• Worldwide recognized clients to build skills for an excellent resume

• Top-notch team to learn and grow with

Background checks may be required for certain positions/projects.

Blue Orange Digital is an equal-opportunity employer.