Government and Infrastructure - AI and Data - Data Engineer - Top Secret Clearance

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. 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 • D ata 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 determine