Data Engineer - Government and Infrastructure, AI and Data

Government and Infrastructure – Technology Consulting - AI & Data - Data Engineer – Top Secret Clearance

From strategy to execution, the Government and Infrastructure practice of Ernst & Young provides a full range of consulting and audit services to help our Federal, State, Local and Education clients implement new ideas to help achieve their mission outcomes. We deliver real change and measurable results through our diverse, high-performing teams, quality work at the highest professional standards, operational know-how from across our global organization, and creative and bold ideas that drive innovation. We enable our government clients to achieve their mission of protecting the nation and serving the people; increasing public safety; improving healthcare for our military, veterans, and citizens; delivering essential public services; and helping those in need. EY is ready to help our government build a better working world.

​​​​EY delivers unparalleled service in big data, business intelligence, and digital analytics built on a blend of custom-developed methods related to customer analytics, data visualization, and optimization. We leverage best practices and a high degree of business acumen that has been compiled over years of experience to ensure the highest level of execution and satisfaction for our clients. At EY, our methods are not tied to any specific platforms but rather arrived at by analyzing business needs and making sure that the solutions delivered meet all client goals.

The opportunity

You will help our clients navigate the complex world of modern AI, data and analytics. We’ll look to you to provide our clients with a unique business perspective on how data science and analytics can transform and improve their entire organization – starting with key business issues they face. This is a high growth, high visibility area with plenty of opportunities to enhance your skillset and build your career.

Your key responsibilities

This role combines traditional business intelligence and reporting responsibilities with hands-on data integration, transformation, and data management activities. The successful candidate will work with stakeholders, analysts, and technical teams to design data solutions, build analytical products, and improve the accessibility, quality, and usability of enterprise data. Responsibilities blend analytical thinking, technical expertise, and client-facing consulting skills. You’ll be responsible for data analytics & business intelligence; Analyzing large datasets to identify trends, anomalies, and actionable insights.

Skills and attributes for success

• Experience developing dashboards, scorecards, and reports using Power BI
• Experience conducting ad hoc analyses supporting audits, operational assessments, and leadership inquiries. Data Engineering & Data Integration Design and maintain data extraction, transformation, and loading (ETL/ELT) processes
• History developing and optimizing SQL queries, views, and stored procedures; Integrate data from multiple enterprise systems and data sources
• Support of cloud-based data platforms and analytics environments
• Troubleshooting experience with data pipeline, data quality, and reporting issues
• Experience writing tests, participating in code reviews
• Seeking out information to learn about emerging methodologies and technologies
• Clarifying problems by driving to understand the true issue
• Experience collaborating, influencing, and building consensus through constructive relationships and effective listening
• Solving problems by incorporating data into decision making

To qualify for the role, you must have

• Must have a Bachelor's degree
• Must have an active Top Secret clearance
• 1-3 years of related experience with SQL Power BI Data modeling Data integration and transformation Data visualization Experience working with relational databases and large datasets
• Must be comfortable working in-person in the Washington, DC area

Ideally, you’ll also have

• Bachelor’s Degree or above in mathematics, information systems, statistics, computer science, or related disciplines
• Data Engineering Experience building ETL/ELT pipelines.
• Experience with Azure Data Factory, or similar technologies.
• Experience with Python for data processing and automation.
• Experience optimizing database and reporting performance. Microsoft Data Platform Azure SQL Azure Data Factory Statistical analysis and trend analysis.
• Data quality management. Dashboard development and KPI reporting. Self-service analytics solutions

Due to the nature of our work in the Government and Public Sector, work may be required to be completed at client, EY and/or contractor sites. Our goal is to assign professionals to projects within a commutable distance of their work location office.  In certain circumstances, travel may be required beyond your work location based on client and project needs. Candidates should be willing to travel 20 – 30% or more.

What we offer you
At EY, we harness our collective strength to empower you to shape your future with confidence through professional growth, personal fulfillment and an inclusive culture. Learn more at ey.com/us/careers.

• 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 is: 
• • New York City, Boston, and Washington DC Metro Areas, Washington State, and Southern California offices – $91,400 to $136,900
  • Bay Area California offices – $95,100 to $142,600
  • All other offices locations in the US, including Sacramento – $76,200 to $125,500 
• Individual salaries within these 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.
• 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.                                              

• To make the most of your application experience, please limit yourself to two applications within a six-month period.
• EY accepts applications for this position on an on-going basis.
• For those living in California, please click here for additional information.
• At EY, our values set the foundation for how we work and the behaviors we expect of our people. Any misrepresentation or falsification of information or lack of integrity at any point in the recruiting process may result in withdrawal of your candidacy, revocation of an offer or immediate termination of employment.

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.

All in to shape the future with confidence.

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 [email protected].