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

About the role

The Service Delivery Center at EY’s Government & Public Sector practice is seeking a Data, Application & Automation Delivery Staff professional to join the AI & Data practice. In this role you will build, maintain, and enhance data platforms, databases, applications, codebases, reports, integrations, and automations that support client operations. You will work as part of an experienced technical delivery team, developing solution components, testing and documenting changes, investigating technical issues, and supporting reliable operation and continuous improvement of established systems.

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 defects, failed jobs, data issues, application problems, integration failures, and automation errors; assist with root‑cause analysis and corrective actions.
• 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 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

• 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.
• SQL, data‑analysis, and technical problem‑solving skills.
• Ability to test, troubleshoot, and document technical work with attention to detail.
• Familiarity with source‑control, testing, documentation, release, and issue‑management practices.
• Effective written and verbal communication; 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.
• Organizational skills to manage priorities, meet deadlines, and communicate progress, risks, or blockers.

Qualifications

• Must be able to obtain and maintain a Secret clearance or higher.
• Bachelor’s degree and a minimum of two years of related professional experience.
• 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 (queries, tables, data structures, 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.
• Exposure to Microsoft Power Platform solutions (Power Apps, Power Automate) and to Power BI, Tableau, or comparable BI/visualization platforms.
• Familiarity with applications, scripts, workflows, codebases, data pipelines, integrations, or scheduled processes.
• Experience with source control, testing, technical documentation, release practices, and structured issue tracking.
• Strong written and verbal communication skills; excellent English‑language proficiency.
• Flexibility to work effectively with nationally distributed teams and to be in‑person as needed (approximately 60% of the time).
• Preferred: Experience with Microsoft Dataverse, SharePoint, Power Pages, Power BI semantic models, or related Microsoft 365/Power Platform technologies.
• Preferred: Familiarity with cloud data technologies (Azure, AWS, Databricks, Snowflake) and API development, system integration, or event‑driven solutions.
• Preferred: Experience supporting applications, databases, data platforms, analytics environments, or automated business processes.
• Preferred: Knowledge of data migration, platform modernization, cloud transformation, monitoring, logging, and service‑quality metrics.
• Preferred: Awareness of data governance, metadata, lineage, access controls, retention, privacy, and secure data‑handling practices.
• Preferred: Experience developing solutions for government clients or in environments requiring formal security, documentation, change‑control, and approval processes.
• Relevant Microsoft, Power Platform, cloud, data, agile delivery, or software‑development certifications are a plus.

Benefits

• Future‑focused skill development and world‑class experiences.
• Flexible, hybrid work model with 40‑60% in‑person collaboration as needed.
• Comprehensive compensation and benefits package, including performance‑based rewards.
• Medical and dental coverage.
• Pension and 401(k) plans.
• Wide range of paid time‑off options, including flexible vacation, EY paid holidays, winter/summer breaks, personal/family care, and other leaves of absence.
• Diverse and inclusive culture of globally connected teams.

Pay

The base salary range for this position in the United States is $46,700 – $95,200. For the New York City Metro Area, Washington State, and California (excluding Sacramento) the range is $56,000 – $108,100. Individual salaries are determined by factors such as education, experience, knowledge, skills, and geography.

Schedule

The role follows EY’s hybrid model, with an expectation of 40‑60% in‑person engagement to support effective teaming and delivery. Flexible vacation policy allows you to determine the amount of vacation time you need based on personal circumstances.