Technical Lead – Snowflake Data Warehouse & Migration

Highbrow Llc; Berkeley Heights (NJ); On-site; USD 77,000 - 128,000; Full time

Job summary

Deloitte seeks an experienced Data Engineer to design, build, and operate modern data products within the Data & Analytics Foundry for long-term, onsite client delivery under the Project Talent Model.

The role requires 4+ years in production data engineering with SQL, Python, Snowflake, and PySpark, plus cloud experience (AWS preferred). You will implement orchestration, optimize warehouse performance, and collaborate with multiple teams.

Qualifications

• 4+ years delivering production-grade data pipelines and curated datasets.
• 4+ years of hands-on SQL and Python with Snowflake and/or PySpark for scalable data processing.
• 4+ years designing batch and near-real-time data pipelines on cloud platforms (AWS preferred; Azure/GCP acceptable).
• Experience with data integration frameworks and orchestration tools.

Responsibilities

• Design, build, and support scalable batch and near-real-time data pipelines on AWS and Snowflake.
• Collaborate with product teams to translate requirements into well-defined datasets and data contracts.
• Implement orchestration and workflow automation with retries and backfills; optimize performance and cost.

Skills

SQL

Python

Snowflake

PySpark

AWS

Azure

GCP

ELT concepts

CI/CD

IaC

Education

Bachelor's degree in CS/IT/CE

Tools

Airflow

S3

Snowflake

Job description

Job Description

Are you an experienced, passionate pioneer in technology who wants to work in a collaborative environment? As an experienced Data Engineer, you will have the ability to share new ideas and collaborate on projects as a consultant without the extensive demands of travel. If so, consider an opportunity with Deloitte under our Project Talent Model. Project Talent Model (PTM) is a talent model that is tailored specifically for long-term, onsite client service delivery.
Recruiting for this role ends on Sep 30th, 2026.
Work you'll do/Responsibilities
As part of the Data & Analytics Foundry you will support numerous business product teams in designing, building, and operating modern data products and platforms across a scale delivery program (onshore/offshore). Your focus will be on delivering reliable, performant, and cost-effective data pipelines and curated datasets to enable analytics and downstream applications.
+ Design, build, and support scalable batch and near-real-time data pipelines on AWS.
+ Design robust ingestion patterns from source systems into S3 and into Snowflake.
+ Develop transformation layers and curated datasets in Snowflake, including dimensional/data product modeling for analytics and downstream applications.
+ Implement orchestration and workflow automation on AWS with retries, backfills, and idempotency.
+ Build reusable Python components for ingestion, validation, and transformations; apply standards through code reviews and testing.
+ Support Snowflake performance and cost optimization through warehouse sizing, concurrency patterns, query tuning, clustering/micro-partition considerations, and workload isolation.
+ Partner with stakeholders to translate requirements into well-defined datasets and data contracts.
+ Communicate regularly with Engagement Managers (Directors), project team members, and representatives from various functional and / or technical teams, including escalating any matters that require additional attention and consideration from engagement management
+ Independently and collaboratively lead client engagement workstreams focused on improvement, optimization, and transformation of processes including implementing leading practice workflows, addressing deficits in quality, and driving operational outcomes
The TeamAI & Data - AI & Engineering leverages cutting-edge engineering capabilities to build, deploy, and operate integrated/verticalized sector solutions in software, data, AI, network, and hybrid cloud infrastructure. These solutions are powered by engineering for business advantage, transforming mission-critical operations. We enable clients to stay ahead with the latest advancements by transforming engineering teams and modernizing technology & data platforms. Our delivery models are tailored to meet each client's unique requirements.
Required Qualifications
+ 4+ years of experience as a Data Engineer delivering production-grade data pipelines and curated datasets.
+ 4+ years of hands‑on experience with SQL and Python, including Snowflake and/or PySpark for scalable data processing and ELT.
+ 4+ years of experience designing, building, and supporting batch and near-real-time data pipelines on cloud platforms (AWS preferred; Azure/GCP acceptable).
+ Experience with data integration frameworks and orchestration tools.
+ Working knowledge of Lakehouse/warehouse architectures and ELT patterns.
+ Knowledge of DevOps principles: CI/CD pipelines, version control, Infrastructure-as-Code.
+ Ability to optimize data storage, partitioning, file formats (Delta, Parquet), and performance.
+ Understanding of data quality, data governance, and metadata management.
+ Bachelor's degree, preferably in Computer Science, Information Technology, Computer Engineering, or related IT discipline; or equivalent experience.
+ Limited immigration sponsorship may be available.
+ Ability to travel 10%, on average, based on the work you do and the clients and industries/sectors you serve.
Preferred- Agile delivery experience.- Analytical ability to manage multiple projects and prioritize tasks into manageable work products.- Can operate independently or with minimum supervision.- Excellent written and communication skills.- Ability to deliver technical demonstrations.
The wage range for this role takes into account the wide range of factors that are considered in making compensation decisions including but not limited to skill sets; experience and training; licensure and certifications; and other business and organizational needs. The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. At Deloitte, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is $76,725 to $127,875.
You may also be eligible to participate in a discretionary annual incentive program, subject to the rules governing the program, whereby an award, if any, depends on various factors, including, without limitation, individual and organizational performance.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law.