Data Engineer - Industrials & Energy Sector - Staff - Consulting - Location OPEN

At EY, we’re all in to shape your future with confidence. 

We’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go.  Join EY and help to build a better working world.

US Consulting - AI & Data - Data Engineer, Industrials & Energy Sector – Staff

The opportunity

EY is seeking Data Engineers who will ingest, build, and support large-scale data architectures that serve multiple downstream systems and business users.

Your key responsibilities

• Design, develop, optimize, and maintain data architecture and pipelines that adheres to ETL principles and business goals
• Develop and maintain scalable data pipelines, build out new integrations using AWS native technologies to support continuing increases in data source, volume, and complexity
• Define data requirements, gather and mine large scale of structured and unstructured data, and validate data by running various data tools in the Big Data Environment
• Support standardization, customization and ad hoc data analysis and develop the mechanisms to ingest, analyze, validate, normalize, and clean data
• Write unit/integration/performance test scripts and perform data analysis required to troubleshoot data related issues and assist in the resolution of data issues
• Implement processes and systems to drive data reconciliation and monitor data quality, ensuring production data is always accurate and available for key stakeholders, downstream systems, and business processes
• Lead the evaluation, implementation and deployment of emerging tools and processes for analytic data engineering to improve productivity
• Develop and deliver communication and education plans on analytic data engineering capabilities, standards, and processes
• Learn about machine learning, data science, computer vision, artificial intelligence, statistics, and/or applied mathematics
• Solve complex data problems to deliver insights that help achieve business objectives
• Implement statistical data quality procedures on new data sources by applying rigorous iterative data analytics

Skills and attributes for success

• Partner with Business Analytics and Solution Architects to develop technical architectures for strategic enterprise projects and initiatives
• Coordinate with Data Scientists to understand data requirements, and design solutions that enable advanced analytics, machine learning, and predictive modelling
• Support Data Scientists in data sourcing and preparation to visualize data and synthesize insights of commercial value
• Collaborate with AI/ML engineers to create data products for analytics and data scientist team members to improve productivity
• Foster a culture of sharing, re-use, design for scale stability, and operational efficiency of data and analytical solutions

To qualify for the role you must have

• Bachelor’s degree in Engineering, Computer Science, Data Science, or related field
• 1+ years of experience in software development, data science, data engineering, ETL, and analytics reporting development
• Exposure to designing, building, implementing, and maintaining data and system integrations using dimensional data modelling and development and optimization of ETL pipelines
• Proven track record of designing and implementing complex data solutions
• Demonstrated understanding and experience using:

• Data Engineering Programming Languages (i.e., Python)
• Distributed Data Technologies (e.g., Pyspark)
• Cloud platform deployment and tools (e.g., Kubernetes)
• Relational SQL databases
• DevOps and continuous integration
• AWS cloud services and technologies (i.e., Lambda, S3, DMS, Step Functions, Event Bridge, Cloud Watch, RDS)
• Databricks/ETL
• IICS/DMS
• GitHub
• Event Bridge, Tidal

• Strong organizational skills with the ability to manage multiple projects simultaneously and operate as a leading member across globally distributed teams to deliver high-quality services and solutions
• Understanding of database architecture and administration
• Processes high proficiency in code programming languages (e.g., SQL, Python, Pyspark, AWS services) to design, maintain, and optimize data architecture/pipelines that fit business goals
• Extracts, transforms, and loads data from multiple external/internal sources using Databricks Lakehouse/Data Lake concepts into a single, consistent source to serve business users and data visualization needs
• Utilizes the principles of continuous integration and delivery to automate the deployment of code changes to elevate environments, fostering enhanced code quality, test coverage, and automation of resilient test cases
• Excellent written and verbal communication skills, including storytelling and interacting effectively with multifunctional teams and other strategic partners
• Strong problem solving and troubleshooting skills
• Ability to work in a fast-paced environment and adapt to changing business priorities

Ideally, you’ll also have

• A passion for innovation and the strategic application of emerging technologies to solve real-world challenges
• The ability to foster an inclusive environment that values diverse perspectives and empowers team members

What we offer you
At EY, we’ll develop you with future-focused skills and equip you with world-class experiences. We’ll empower you in a flexible environment, and fuel you and your extraordinary talents in a diverse and inclusive culture of globally connected teams. Learn more.

• We offer a comprehensive compensation and benefits package where you’ll be rewarded based on your performance and recognized for the value you bring to the business.  The base salary range for this job in all geographic locations in the US is $75,400 to $124,300.  The base salary range for New York City Metro Area, Washington State and California (excluding Sacramento) is $90,500 to $141,200.  Individual salaries within those ranges are determined through a wide variety of factors including but not limited to education, experience, knowledge, skills and geography.  In addition, our Total Rewards package includes medical and dental coverage, pension and 401(k) plans, and a wide range of paid time off options.
• Join us in our team-led and leader-enabled hybrid model. Our expectation is for most people in external, client serving roles to work together in person 40-60% of the time over the course of an engagement, project or year.
• Under our flexible vacation policy, you’ll decide how much vacation time you need based on your own personal circumstances. You’ll also be granted time off for designated EY Paid Holidays, Winter/Summer breaks, Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being.

Are you ready to shape your future with confidence? Apply today. 
EY accepts applications for this position on an on-going basis.  

For those living in California, please click here for additional information.

EY focuses on high-ethical standards and integrity among its employees and expects all candidates to demonstrate these qualities.

EY  |  Building a better working world

EY is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets.

Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow.

EY teams work across a full spectrum of services in assurance, consulting, tax, strategy and transactions. Fueled by sector insights, a globally connected, multi-disciplinary network and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories.

EY provides equal employment opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity/expression, pregnancy, genetic information, national origin, protected veteran status, disability status, or any other legally protected basis, including arrest and conviction records, in accordance with applicable law.  

EY is committed to providing reasonable accommodation to qualified individuals with disabilities including veterans with disabilities. If you have a disability and either need assistance applying online or need to request an accommodation during any part of the application process,  please call 1-800-EY-HELP3, select Option 2 for candidate related inquiries, then select Option 1 for candidate queries and finally select Option 2 for candidates with an inquiry which will route you to EY’s Talent Shared Services Team (TSS) or email the TSS at ssc.customersupport@ey.com.