Data Engineer II

PowerToFly; Alabama; On-site; USD 80,000 - 128,000; Full time

Job summary

Deloitte is seeking an experienced Data Engineer to design and operate scalable data pipelines on AWS, ingest data into Snowflake, and build robust data transformations. You will develop Python components, optimize Snowflake performance, and partner with stakeholders to define data contracts.

The role is part of the AI & Data team under the Project Talent Model, focused on long-term, onsite client delivery with limited travel. A bachelor’s degree and 4+ years of relevant experience are required.

Qualifications

• 4+ years of experience 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.

Responsibilities

• 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 with dimensional/data product modeling.
• Implement orchestration and workflow automation on AWS with retries and idempotency.
• Build reusable Python components for ingestion, validation, and transformations; ensure code quality through reviews.
• Support Snowflake performance and cost optimization through warehouse sizing and tuning.
• Partner with stakeholders to translate requirements into datasets and data contracts.
• Communicate with Engagement Managers and teams; escalate when needed.
• Lead client engagement workstreams focused on improvement, optimization, and transformation.

Skills

Data pipeline design

SQL

Python

Cloud data pipelines

Data integration frameworks

Orchestration tools

Lakehouse architectures

ELT patterns

DevOps principles

Data quality governance

Metadata management

Agile delivery

Education

Bachelor's degree in CS/IT/CE or related field

Tools

Snowflake

PySpark

Delta Lake

Parquet

Airflow

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

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

AI & 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.