Blue Orange Digital
Data Engineer
at
Blue Orange Digital
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.
Position Overview Engagement Type:
Staff Augmentation (3–6 months)
Type:
Contractor
Location:
New York City office – onsite approximately three days per week. Candidates must reside in or commute from the NY Tri‑State Area.
Relocation:
No relocation assistance provided
Experience Level:
Senior to Mid‑Senior
Responsibilities
Manage and enhance the client’s Snowflake data warehouse, focusing on structure, performance, and cost optimization.
Design and implement complex SQL and Python 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.
Develop and maintain Python‑based data pipelines integrated with AWS and Snowflake.
Use AWS components (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.
Build and maintain 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, business users, engineers, and data scientists to ensure data freshness and performance.
Participate in a one‑month knowledge transfer period with the existing team to understand architecture, pipelines, and operational processes.
Deliver thorough documentation and ensure smooth handoff post‑engagement.
Technical Environment
Data Warehouse: Snowflake (advanced optimization required)
Programming/Scripting: Python (pandas, polars, numpy) for data pipelines and automation
Data Transformation: dbt for model development, testing, and documentation
Visualization: Tableau for dashboards and data source support
Cloud Infrastructure: AWS (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 capable of writing complex joins, CTEs, window functions, and transformations efficiently
Proficient in Python for data manipulation, pipeline development, and integration with Snowflake/AWS (pandas, polars, numpy)
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 résumé
Top‑notch team to learn and grow with
Salary:
$11,458.33 – $16,041.60 per month (depending on experience)
Background checks may be required for certain positions/projects.
Blue Orange Digital is an equal‑opportunity employer.
#J-18808-Ljbffr
at
Blue Orange Digital
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.
Position Overview Engagement Type:
Staff Augmentation (3–6 months)
Type:
Contractor
Location:
New York City office – onsite approximately three days per week. Candidates must reside in or commute from the NY Tri‑State Area.
Relocation:
No relocation assistance provided
Experience Level:
Senior to Mid‑Senior
Responsibilities
Manage and enhance the client’s Snowflake data warehouse, focusing on structure, performance, and cost optimization.
Design and implement complex SQL and Python 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.
Develop and maintain Python‑based data pipelines integrated with AWS and Snowflake.
Use AWS components (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.
Build and maintain 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, business users, engineers, and data scientists to ensure data freshness and performance.
Participate in a one‑month knowledge transfer period with the existing team to understand architecture, pipelines, and operational processes.
Deliver thorough documentation and ensure smooth handoff post‑engagement.
Technical Environment
Data Warehouse: Snowflake (advanced optimization required)
Programming/Scripting: Python (pandas, polars, numpy) for data pipelines and automation
Data Transformation: dbt for model development, testing, and documentation
Visualization: Tableau for dashboards and data source support
Cloud Infrastructure: AWS (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 capable of writing complex joins, CTEs, window functions, and transformations efficiently
Proficient in Python for data manipulation, pipeline development, and integration with Snowflake/AWS (pandas, polars, numpy)
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 résumé
Top‑notch team to learn and grow with
Salary:
$11,458.33 – $16,041.60 per month (depending on experience)
Background checks may be required for certain positions/projects.
Blue Orange Digital is an equal‑opportunity employer.
#J-18808-Ljbffr