Ernst & Young

Ernst & Young

Provides consulting, assurance, and tax services

Data Engineer Intern - Multiple Teams

Summer 2027
$36.06 - $45.19/hr
Internship
Bachelor's, Master's
Chicago, IL, USA+1 more

More locations: New York, NY, USA

Hybrid

Hybrid work generally requires 40–60% in-person time, and candidates must live within commuting distance of the associated office.

No H1B Sponsorship

About the job

Requirements
  • A predicted undergraduate or graduate degree in Data Science, Computer Science, Information Systems, Business Analytics, Data Engineering, Management Information Systems, Accounting Information Systems, or a related field, supported by a strong academic record.
  • A cumulative college or university GPA of at least 3.0.
  • Working knowledge of SQL and data analysis concepts.
  • Knowledge of data extraction, transformation, and loading (ETL).
  • Knowledge of database querying and data manipulation.
  • Experience with Microsoft Excel and data visualization tools.
  • Familiarity with at least one programming language such as Python, R, or SQL.
  • Interest in cloud data platforms and enterprise technology solutions.
  • Interest in working in a team-led and leader-enabled hybrid model.
  • Access to reliable transportation to and from the EY office and client sites.
  • Ability and willingness to travel and work beyond standard hours when necessary.
  • Residence within a commutable distance of the office associated with the position.
  • Legal authorization to work in the United States without employer sponsorship, now and in the future.
Responsibilities
  • Document business requirements, data definitions, process flows, and technical specifications.
  • Support data collection, cleansing, validation, and transformation across multiple tax and finance data sources.
  • Work with structured and unstructured datasets to identify trends, data quality issues, risks, and opportunities.
  • Help design and implement data pipelines and automation solutions that improve operational efficiency.
  • Assist with data migration and integration activities involving enterprise resource planning, finance, and tax systems.
  • Perform data profiling, reconciliation, and quality analysis to ensure completeness and accuracy.
  • Support artificial intelligence and advanced analytics initiatives, including machine learning and generative artificial intelligence use cases.
  • Assist in developing dashboards, reports, and visualizations using business intelligence tools to support decision-making.
  • Collaborate with tax professionals, data engineers, solution architects, and business stakeholders.
  • Research emerging technologies and industry trends related to data and analytics, Microsoft Fabric, Azure Data Platform, Snowflake, Databricks, and artificial intelligence.
  • Prepare client-ready deliverables, presentations, and project documentation.
  • Take ownership of assigned workstreams and ensure timely completion of deliverables.
Desired Qualifications
  • A cumulative college or university GPA of at least 3.2.
  • Experience using Python for data analysis or automation.
  • Familiarity with Power BI, Tableau, or similar visualization tools.
  • Exposure to cloud platforms such as Microsoft Azure, Amazon Web Services, or Google Cloud.
  • Knowledge of Microsoft Fabric, Azure Data Factory, Databricks, Snowflake, Synapse, or related technologies.
  • Understanding of artificial intelligence, machine learning, or generative artificial intelligence concepts.
  • Experience with academic, internship, or research projects involving large datasets.
  • Knowledge of how to use firm-approved artificial intelligence tools in a business setting, including Microsoft Copilot.

About the company

EY (Ernst & Young) is a global professional services firm that provides consulting, assurance, tax, and transaction advisory services across industries such as energy, healthcare, financial services, and real estate. Its work centers on helping clients solve critical business challenges by offering high-value advisory support in areas like supply chain, cybersecurity, sustainability, and digital transformation; revenue comes from fees for consulting, audit, and advisory services. What sets EY apart is its breadth of services across multiple disciplines, deep industry knowledge, and emphasis on thought leadership and research to inform clients’ strategic decisions. The firm aims to help organizations improve operational efficiency, navigate regulatory environments, and stay ahead of market trends by delivering practical, evidence-based guidance and execution support.

Company Size

10,001+

Company Stage

N/A

Total Funding

N/A

Headquarters

London, United Kingdom

Founded

1991

Get referred to Ernst & Young

See people who can refer or advise you

Simplify Jobs

Simplify's Take

What believers are saying

  • EY.ai Agentic for Sales launched March 2, 2026 with Snowflake and Canva.
  • EY uses client-zero deployments, scaling Copilot across 400,000 people by May 2026.
  • EY’s 2026 AI assurance push monetizes client demand for governance, controls, and risk reviews.

What critics are saying

  • Sabah filed RM2.4 billion audit-negligence claims against EY on July 30, 2026.
  • EY set aside £188 million in March 2026 after NMC, Shell, and Made.com scrutiny.
  • Repeated audit failures can destroy trust, trigger client defections, and shrink the franchise permanently.

What makes Ernst & Young unique

  • EY Canvas processes 1.4 trillion journal-entry lines across 160,000 global audits.
  • EY-Microsoft invested US$1b+ in May 2026 to industrialize enterprise AI delivery.
  • EY launched agentic audit AI on April 7, 2026, spanning Assurance and AI assurance.

Help us improve and share your feedback! Did you find this helpful?

Benefits

Professional Development Budget

Flexible Work Hours

Remote Work Options

Company News

PR Newswire
Sep 9th, 2026
US oil producers hit record output as capital spending drops 49% and reserve replacement falls

An Ernst & Young study found US oil and gas producers reached record production in 2025 while becoming more selective with investments. The analysis of 30 major exploration and production companies, representing 43% of US oil and gas output, showed oil production hit a study-period high, yet reserve additions from extensions and discoveries declined 11% year over year and failed to fully replace production volumes for the first time since 2021. Total capital expenditures fell 49% year over year, whilst M&A spending declined 70%. Exploration spending dropped 11% to $4.8 billion, representing only 3% of total capital expenditures. Natural gas showed stronger fundamentals, with production rising 18%, reserves increasing 14%, and discoveries up 21%.

Yahoo Finance
Aug 31st, 2026
EY commits $100M to bonuses rewarding human skills alongside AI adoption

Ernst & Young's US division is allocating $100 million this fiscal year to bonus payments rewarding employees who demonstrate adaptability, innovation, and judgement. Individual spot awards reach $500, whilst employees or teams making significant contributions can receive between $10,000 and $25,000, five times the previous programme's ceiling. The initiative also covers AI experimentation. "What we recognise signals what we value," said Ginnie Carlier, chief talent and culture officer for EY Americas. The bonuses form part of a broader strategy to reshape employee development across all career levels. Other professional services firms are pursuing similar approaches. KPMG restructured its audit internship this summer to emphasise critical thinking, whilst PwC US introduced training combining AI proficiency with human qualities like empathy. EY reported AI-related revenue grew 30% year-over-year in 2025.

Consultancy.eu
Aug 28th, 2026
EY-Parthenon acquires Dutch digital strategy consultancy SparkOptimus

EY-Parthenon has acquired SparkOptimus, a Dutch digital strategy consultancy founded in 2010. The Amsterdam-based firm employs around 50 consultants and specialises in AI transformation, digital business model redesign and technology-driven transformation. SparkOptimus founders Alexandra Jankovich and Tom Voskes, both former McKinsey consultants, said joining EY-Parthenon will create significant value for clients and staff whilst providing access to broader capabilities. The acquisition marks EY-Parthenon's first European deal since 2021. EY-Parthenon, established in 2014, is EY's strategy consulting and transactions advisory business with around 25,000 professionals globally. Mark Reich, Partner at EY-Parthenon Netherlands, said SparkOptimus' expertise will complement existing capabilities in the Dutch market. The deal closes on 1 September 2026. Financial terms were not disclosed.

Yahoo Finance
Aug 18th, 2026
KPMG and EY win $579M UK civil servants training contract despite consultancy spending pledge

The UK Government has awarded a contract worth up to £456 million to KPMG and EY to train civil servants, the Financial Times reported, citing government procurement tracker Tussell. Under the arrangement, the firms will train officials across various skills areas, including AI, between 2026 and 2028. KPMG's share is capped at £319 million, representing almost a quarter of its total UK advisory net sales from last year. EY's portion is worth £137 million, equivalent to around 13% of its UK consulting revenue. The deal is the largest single contract awarded to Big Four companies since Tussell started tracking records in 2012. The previous record was a £322 million deal between the Foreign Office and PricewaterhouseCoopers in 2012.

Business Insider
Jul 30th, 2026
EY's 'invisible' AI router cuts token costs by 60% by directing queries to cheaper models

EY has introduced an "invisible" AI router to manage internal AI spending, helping cut token consumption by up to 60% since its April rollout. The router sits behind specialised AI tools and directs employee queries to the most appropriate model for each task, rather than defaulting to the most powerful option. Token costs have become a growing concern as AI providers increasingly charge based on usage. EY's AI Pulse survey found that 82% of senior leaders at companies investing in AI were worried about token usage. The router has been deployed on department-specific platforms, including tax and risk functions, though not on the general Microsoft Copilot chatbot available to all staff. EY has also implemented token budgets based on employees' roles and departments. The firm's global consulting AI leader Dan Diasio said companies should focus AI investment on areas with the deepest impact rather than spreading resources thinly.