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.
Details:
- Duration: 3–6 months
- Timeline: Targeting mid-November start (3–4 weeks from commitment)
- Ramp Period: ~1 month knowledge transfer with existing team member
- Location: On-site in the NY Tri-State Area (New York / New Jersey / Connecticut), ~3 days per week in the office
- Delivery Model: Staff Augmentation (embedded with internal data engineering team)
- Reporting To: Data Engineering Lead / Director of Data Operations
- Success Criteria: Clear, outcome-driven deliverables with strong communication and documentation
Position overview:
The client is seeking an experienced Data Engineer for a 3–6 month staff augmentation engagement to support existing data workflows, ensure continuity of delivery, and advance the client’s Snowflake and dbt infrastructure.
This role is ideal for a hands-on, senior-level data engineer with deep expertise in Snowflake, Python-based data pipelines, and complex SQL transformation logic. The engineer will collaborate with internal teams during a 1-month knowledge transfer period and then independently own defined deliverables.
The engagement combines data pipeline engineering, SQL transformation management, and dashboard workflow support within an AWS-centric cloud environment.
Responsibilities:
Snowflake Engineering & Optimization
- Manage and enhance the client’s Snowflake data warehouse, focusing on structure, performance, and cost optimization.
- Design and implement complex SQL transformations across multiple schemas and data domains.
- Analyze existing Snowflake setup and recommend improvements in storage structure, clustering, and performance tuning.
- Implement best practices around data partitioning, security, role-based access control, and query performance.
Python Data Pipeline Development
- Develop and maintain Python-based data pipelines integrated with AWS and Snowflake.
- Plug into an existing large, production-level codebase, contributing clean, tested, modular code.
- Leverage AWS components (e.g., S3, Lambda, Glue, Step Functions) to orchestrate end-to-end workflows.
- Write Python scripts and utilities to automate data validation, ingestion, and reporting processes.
dbt & Transformation Layer
- Implement and refine dbt models to transform raw data into analytics-ready structures.
- Define and enforce data testing, lineage tracking, and documentation through dbt best practices.
- Integrate dbt with CI/CD pipelines for automated testing and deployment.
- Collaborate with analysts to expose dbt-modeled data directly to Tableau and other BI tools.
Analytics & Dashboard Workflow Support
- Support Tableau dashboard workflows, maintaining and optimizing data sources and extracts.
- Work cross-functionally with analysts and business users to ensure data freshness and performance.
- Enhance self-service analytics by ensuring governed, well-modeled data sources.
Cross-Team Collaboration & Knowledge Transfer
- Participate in knowledge transfer (~1 month) with existing team members to understand architecture, pipelines, and operational processes.
- Work collaboratively with internal engineering, data science, and business analytics teams.
- Deliver thorough documentation and ensure smooth handoff post-engagement.
Technical Environment (Tools & Platforms):
Data Warehouse
- Snowflake (core platform; advanced optimization expected)
Programming / Scripting
- Python (used for data pipelines, automation, and ETL orchestration)
Data Transformation
- dbt (Data Build Tool) for model development, testing, and documentation
Visualization
- Tableau (dashboard development and data source support)
Cloud Infrastructure
- AWS stack including S3, Glue, Lambda, Step Functions, IAM
Orchestration / CI-CD
- Airflow, dbt Cloud, GitHub Actions, or AWS-native scheduling tools
Version Control
Data Quality & Governance
- dbt tests
- Great Expectations (nice-to-have)
Preferred qualifications:
- 5–8+ years of professional experience as a Data Engineer, Analytics Engineer, or Senior Data Developer.
- Strong expertise with Snowflake, including schema design, query optimization, and performance tuning.
- Advanced SQL developer — able to write complex joins, CTEs, window functions, and transformations efficiently.
- Proficient in Python for data manipulation, pipeline development, and integration with Snowflake/AWS.
- Experienced with dbt for transformation and documentation.
- Experienced with Prefect for job scheduling and workflow management.
- Familiar with Tableau for analytics support and data delivery.
- Experienced with Microsoft SQL Server.
- Comfortable integrating into a mature, existing codebase and collaborating in a fast-paced, cross-functional environment.
- Excellent communicator and problem-solver, able to operate independently with defined outcomes.
Key Deliverables:
- Maintain and optimize existing Snowflake-based pipelines for performance and cost efficiency.
- Deliver new Python data workflows integrated with AWS and Snowflake.
- Implement or enhance dbt transformation layer for analytics-ready datasets.
- Provide dashboard data source stability and support for Tableau users.
- Complete and document all work to ensure a smooth handoff at project conclusion.
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
Salary: $11,458.33 - $16,041.6 (monthly range, depending on experience)
Background checks may be required for certain positions/projects.
Blue Orange Digital is an equal-opportunity employer.
