Government and Public Sector - Service Delivery Center - Data, Application and Automation Analyst

Government & Public Sector – Service Delivery Center – AI & Data – Data, Application & Automation Delivery – Analyst

From strategy to execution

The Government & Public Sector 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 and 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 knowledge from across our global organization, and creative and bold ideas that drive innovation. We enable our government clients to protect the nation and serve the public, increase public safety, improve healthcare for military members, veterans, and citizens, deliver essential public services, and help those in need. EY is ready to help our government build a better working world.

The opportunity

The Service Delivery Center is made up of high-performing, U.S.-based professionals who work closely with EY engagement teams to deliver project-based work and managed services to government clients. The Service Delivery Center is a core component of the Government & Public Sector practice.

We currently have an opportunity for a Data, Application & Automation Delivery Staff professional to join our growing AI & Data practice. In this role, you will help build, maintain, and enhance the data platforms, databases, applications, codebases, reports, integrations, and automations that support client operations.

Working as part of an experienced technical delivery team, you will develop assigned solution components, test and document changes, investigate technical issues, and support the reliable operation and continuous improvement of established systems. The work may include databases, data pipelines, reporting solutions, Power Apps, Power Automate flows, application code, APIs, scheduled processes, and system integrations.

Your primary focus will be hands-on technical delivery and the production of reliable, accurate, and maintainable solutions.

Your key responsibilities

• Develop, maintain, test, document, and improve assigned components of data platforms, databases, applications, codebases, integrations, analytics products, and business-process automations
• Work from defined functional, operational, and technical requirements to complete development and support tasks
• Develop and maintain Microsoft Power Platform solutions, including Power Apps, Power Automate flows, and related integrations
• Develop and enhance dashboards, reports, data models, and analytics products using Power BI, Tableau, or comparable technologies
• Write, test, and maintain SQL queries, scripts, stored procedures, data transformations, and other database components
• Support data extraction, ingestion, transformation, loading, validation, and integration processes
• Assist with the development and maintenance of data pipelines, scheduled jobs, automated processes, and application integrations
• Maintain and enhance existing applications, scripts, APIs, workflows, and reusable code components
• Connect databases, applications, cloud services, Microsoft 365 technologies, and external systems using approved integration methods
• Perform data validation and investigate data-quality issues, incomplete records, unexpected results, and processing failures
• Apply established development, testing, documentation, release, security, and change-management practices
• Participate in code reviews and incorporate technical feedback from Senior and Manager professionals
• Execute test cases, document results, and confirm that assigned changes meet defined requirements and acceptance criteria
• Troubleshoot defined defects, failed jobs, data issues, application problems, integration failures, and automation errors
• Assist with root-cause analysis and implementation of corrective actions under the guidance of more experienced team members
• Support application releases, platform changes, data migrations, software upgrades, and modernization activities
• Identify and communicate defects, risks, dependencies, recurring issues, and blockers that may affect assigned work
• Contribute ideas for reducing manual effort, improving existing workflows, increasing reliability, and creating reusable delivery components
• Prepare and maintain technical documentation, including data flows, configuration details, operating procedures, test evidence, release notes, and known-issue guidance
• Participate in internal, engagement-team, and client discussions to clarify requirements, review progress, demonstrate completed work, and understand operational issues
• Collaborate with developers, data engineers, analysts, platform specialists, and other engagement professionals
• Support compliance with applicable security, privacy, accessibility, data-governance, and client-specific delivery requirements
• Complete engagement-specific responsibilities in accordance with established scope, quality, schedule, service, security, and client requirements

Skills and attributes for success

• Interest in building and supporting data, application, analytics, and workflow-automation solutions
• Foundational understanding of databases, data integration, reporting, application development, or business-process automation
• Ability to translate defined requirements into working solution components, configurations, reports, queries, or automations
• Ability to understand existing technical environments and make changes according to established designs and standards
• SQL, data-analysis, and technical problem-solving skills
• Ability to test, troubleshoot, and document technical work
• Attention to detail and commitment to producing reliable, accurate, and maintainable work products
• Ability to follow source-control, testing, documentation, release, and issue-management practices
• Ability to investigate technical issues, document findings, and seek assistance when appropriate
• Ability to receive technical feedback and incorporate it into completed work
• Ability to organize assignments, manage priorities, meet deadlines, and communicate progress
• Effective written and verbal communication skills
• Ability to explain completed work, technical issues, and delivery status clearly
• Ability to work independently on defined tasks while collaborating effectively as part of a technical delivery team
• Curiosity, adaptability, and commitment to continuous technical and professional development

To qualify for the role, you must have

• Must be able to obtain and maintain a secret clearance or higher
• Must have a bachelor’s degree and a minimum of two years of related professional experience
• Must be comfortable working in-person as needed
• Relevant experience developing, maintaining, enhancing, or supporting data, application, analytics, or automation solutions through professional work, internships, academic projects, or comparable technical experience
• Experience with SQL and foundational relational-database concepts, including queries, tables, data structures, and data quality
• Coding or scripting experience using Python, JavaScript, PowerShell, R, or a comparable language
• Familiarity with data extraction, transformation, loading, ingestion, integration, and validation processes
• Experience with or exposure to Microsoft Power Platform solutions, including Power Apps and Power Automate
• Experience with or exposure to Microsoft Power BI, Tableau, or a comparable business-intelligence and data-visualization platform
• Familiarity with applications, scripts, workflows, codebases, data pipelines, integrations, or scheduled processes
• Familiarity with source control, testing, technical documentation, release practices, and structured issue tracking
• Strong written and verbal communication skills
• Flexibility and ability to work effectively with nationally distributed teams
• Ability to prioritize assignments, meet deadlines, follow up on open issues, and communicate risks or blockers
• Excellent English-language skills, both written and verbal

Consistent with EY’s collaborative working model, the role is expected to include 60% in-person engagement in support of effective teaming and delivery, subject to client and business requirements.

Ideally, you’ll also have

• Experience working with Microsoft Dataverse, SharePoint, Power Pages, Power BI semantic models, or related Microsoft 365 and Power Platform technologies
• Familiarity with cloud data technologies or platforms such as Microsoft Azure, Amazon Web Services, Databricks, Snowflake, or comparable technologies
• Familiarity with API development, system integration, scheduled processing, middleware, or event-driven solutions
• Experience supporting applications, databases, data platforms, analytics environments, or automated business processes
• Familiarity with data migration, platform modernization, application enhancement, or cloud transformation
• Familiarity with monitoring, logging, alerting, operational metrics, or service-quality measures
• Awareness of data governance, metadata, lineage, access controls, retention, privacy, and secure data-handling practices
• Experience developing solutions for government clients or within environments that require formal security, documentation, change-control, and approval processes
• Relevant Microsoft, Power Platform, cloud, data, agile delivery, or software-development certifications

What we look for

We are looking for delivery-focused professionals who take pride in building dependable technology and improving the systems clients rely on. You should be comfortable completing defined technical assignments, investigating problems, documenting your work, incorporating feedback, and collaborating with an experienced delivery team.

We value professionals who recognize that meaningful technical delivery includes both creating new capabilities and maintaining existing solutions. The successful candidate will bring attention to detail, a willingness to learn, and a continuous-improvement mindset to databases, applications, reports, workflows, integrations, and automation solutions.