Mid-level Data Engineer
Descrição da vaga
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.
Habilidades mencionadas
At Blue Orange Digital, we are at the forefront of data science and machine learning, pioneering innovative solutions to tackle the most complex and impactful challenges for businesses. Through groundbreaking technology, we are revolutionizing how organizations leverage their data. Our mission is to unleash the power of data for impact, building a world-class professional services team dedicated to this singular purpose. We empower our clients by implementing data-driven analytic techniques derived from statistical modeling and data science, helping them optimize and automate their businesses faster and more efficiently. Our team, comprised of passionate data engineers, PhDs, data scientists, and visualization experts, possesses the intellectual prowess and diverse perspectives that form the bedrock of our thought leadership in the ever-evolving datascape. Our vision extends beyond mere problem-solving; we strive to leave a lasting impact, one data-driven decision at a time. We believe that data-driven decision-making is the cornerstone of success, and we equip our team with the tools and expertise to unlock its full potential. At the heart of our mission is an unwavering commitment to talent. We cultivate a collaborative environment where exceptional individuals can thrive and grow, fostering a culture of knowledge sharing and continuous learning. Integrity and empathy are core values at Blue Orange Digital. We are committed to honesty, transparency, and ethical behavior in all our endeavors, striving to always do the right thing. We believe in understanding our clients' unique needs and challenges to provide personalized solutions. By working closely with our clients, we help them unlock the power of data and advanced analytics to generate new sources of value and modernize their data environments. Whether it's through predictive analytics, automation, or optimization with machine learning, we are dedicated to helping organizations implement data-driven analytic techniques and understand the implications of new technologies like artificial intelligence, big data, and the Internet of Things.
Candidate-se a esta vaga
Use the application link supplied with this listing to apply to Blue Orange Digital. Check the destination before entering personal information.