Blue Orange Digital · 11 hours ago
Data Engineer
Newark, US
Full-time
Hybrid
Mid, Senior Level
$11,458.33/mo - $16,041.67/mo
5+ years expBlue Orange Digital is a boutique data & AI consultancy that delivers enterprise-grade results. They are seeking an experienced Data Engineer with a Financial Services background to support existing data workflows and advance the client’s Snowflake and dbt infrastructure. The role involves managing Snowflake, developing Python data pipelines, and collaborating with teams to optimize data processes.
Artificial Intelligence (AI)Cloud ComputingBig DataSoftwareAnalyticsCloud Data ServicesData IntegrationData VisualizationMachine LearningPredictive Analytics
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 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 (approximately one 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
Qualification
Required
5–8+ years of professional experience as a Data Engineer, Analytics Engineer, or Senior Data Developer, with 1–3 years of experience (or more) in Financial Services
Strong expertise with Snowflake, including schema design, query optimization, and performance tuning
Advanced SQL skills, including complex joins, CTEs, window functions, and efficient transformations
Proficient in Python for data manipulation, pipeline development, and integration with Snowflake and AWS, particularly using pandas, polars, and numpy
Experience using dbt for transformation and documentation
Experience with Prefect for job scheduling and workflow management
Familiarity with Tableau for analytics support and data delivery
Experience 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 clearly defined outcomes
Preferred
Great Expectations (nice to have)
Experience with Airflow, dbt Cloud, GitHub Actions, or AWS-native scheduling
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
Company
Blue Orange Digital
Blue Orange is a data science and machine learning consulting and development firm.
51-200 employees
Funding
Current Stage
Growth StageTotal Funding
$0.7MKey Investors
Oliver Wyman
2022-04-13Corporate Round· $0.7M
Leadership Team
Josh Miramant
Founder/CEO
Colin Van Dyke
Chief Technology Officer
Recent News
Company data provided by crunchbase