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.
Skills Required
- 2-4 years of data engineering experience in a production environment
- Strong SQL skills, including multi-stage CTEs, window functions, and query optimization
- Working knowledge of dbt models, tests, sources, and basic macros
- Experience with Snowflake or a similar cloud data warehouse such as BigQuery, Redshift, or Databricks
- Comfort with dimensional modeling and layered medallion architectures
- Git and GitHub workflows, including branching, pull requests, and code review
- Strong written English and reliable asynchronous communication
- Availability for at least 20 hours per week, including four hours of overlap with US Eastern time Monday through Thursday
- Python for data validation or transformation logic
- Experience with dbt macros and Jinja templating
- Exposure to investment, financial, or alternative data
Blue Orange Digital Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Blue Orange Digital and has not been reviewed or approved by Blue Orange Digital.
-
Healthcare Strength — Health coverage is described as comprehensive across medical, dental, and vision in current job postings, with some descriptions indicating particularly strong plan generosity. This points to a solid core insurance foundation for U.S.-based roles.
-
Retirement Support — Current role descriptions consistently include a 401(k) with company match. This adds long‑term financial value to the overall package.
-
Leave & Time Off Breadth — Certain postings specify unlimited PTO along with paid parental and bereavement leave. This breadth of time‑off options supports flexibility for varied life events.
Blue Orange Digital Insights
What We Do
Blue Orange is a data science and machine learning consulting and development firm. We build modern data warehousing to support machine learning and AI. We help companies integrate these insights to drive data-driven decision making.
