Data Engineer

Blue Orange Digital•Jersey City, NJ

3h•Hybrid

About The Position

The client is seeking an experienced Data Engineer with a Financial Services background 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. The ideal candidate is able to meaningfully contribute at a high-level architectural “plan of attack” level and also contribute directly with hands-on, performant Python, pandas, numpy, and SQL engineering, delivering client-compatible, efficient, clean, working code. Familiarity and experience with API and data source ingestion, data cleansing and transformations, time series analysis, and data modeling are critical success factors. This role is ideal for a hands-on, senior-level Data Engineer with deep expertise in Snowflake, Python-based data pipelines (pandas and numpy), and complex SQL transformation logic. The engineer will collaborate with internal teams during a one-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 financial services environment.

Requirements

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.