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:

Engagement Type: Staff Augmentation (3–6 months)

Type: Contractor.

Location: This role is based in our New York City office and requires onsite presence approximately three days per week. Candidates must reside in or be able to commute from the NY Tri‑State Area (NY, NJ, CT).

Relocation: No relocation assistance is provided for this position.

Experience Level: Senior to Mid-Senior

The client is seeking an experienced Data Engineer for a 3–6 month staff augmentation engagement, with extension possibilities, to support existing data workflows, ensure continuity of delivery, and advance the client’s Snowflake and dbt infrastructure. able to meaningfully contribute at the high-level architectural plan of attack level, and then contribute directly with hands-on, performant python, pandas, numpy, and SQL engineering, delivering client-compatible, efficient, clean working code.

This role is ideal for a hands-on, senior-level data engineer with deep expertise in Snowflake, Python-based data pipelines, using pandas and numpy, 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:2. Python Data Pipeline Development3. dbt & Transformation Layer4. Analytics & Dashboard Workflow Support5. Cross-Team Collaboration & Knowledge Transfer

• Snowflake Engineering & Optimization
• Manage and enhance the client’s Snowflake data warehouse, focusing on structure, performance, and cost optimization.
• Design and implement complex SQL and python transformations, at the pandas/polars/numpy level, 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.
• 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 (pandas, polars, numpy) to automate data validation, ingestion, and reporting processes.
• 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.
• 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.
• 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:

• Data Warehouse: Snowflake (core platform; advanced optimization expected)
• Programming / Scripting: Python for data pipelines, automation, and ETL orchestration (pandas, polars, numpy)
• Data Transformation: dbt for model development, testing, and documentation
• Visualization: Tableau for dashboards and data source support
• Cloud Infrastructure: AWS stack: S3, Glue, Lambda, Step Functions, IAM
• Orchestration / CI‑CD: Airflow, dbt Cloud, GitHub Actions, or AWS‑native scheduling
• Version Control: Git, GitHub, GitLab
• Data Quality & Governance: dbt tests, Great Expectations (nice‑to‑have), documentation best practices
  
  

Ideal Profile:

• 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, especially at the pandas, polars, numpy, etc. level.
• 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.
  
  

Benefits:

• 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.