Accounting & Finance Data Reporting and Automation Engineer - State, Local, And Higher Education

Position summary

Our Deloitte Finance Transformation team practices to help chief financial officers, controllers, and finance teams define and execute their finance and global business services agendas and strategies. You will work with leading-class teams and solutions, helping clients navigate challenging environments, market uncertainty, technology development, and regulatory considerations to unlock value. Your work may span strategy, operations, process design, and technology as we partner with clients to transform finance.

Work You’ll Do

As a Senior Consultant for General Business Finance Data Analytics & Insights team, you will be responsible for the design, build, and maintain automations that streamline accounting and finance processes for state, local, and higher education clients. You will work closely with client finance teams and our consultants to turn manual, error-prone work into reliable, auditable, and scalable workflows. You will also build the data pipelines, reporting tools, and control checks that help clients close faster, reconcile with confidence, and stay ready for audit.

• Design and build automations for recurring finance and accounting processes, such as bank reconciliations, accounts payable and receivable matching, journal entry preparation, accrual calculations, and month-end and year-end close checklists.
• Develop process automation and workflow solutions using tools such as Power Automate, UiPath, or similar platforms, with appropriate exception handling and human review points.
• Build and maintain data extraction, transformation, and loading (ETL) pipelines that pull data from ERP and other information systems, including Workday, Oracle, PeopleSoft, into reporting environments.
• Write SQL queries and scripts to validate data, identify anomalies, and support general ledger analysis, reconciliations, and chart of accounts clean-up.
• Design and maintain dashboards and recurring financial reports for controllers, treasurers, budget offices, and boards, including fund-level, grant-level, and capital asset reporting.
• Build automated control testing and monitoring routines aligned to the COSO framework, producing evidence that supports internal audit, external financial statement audits, state audits, and Single Audits under Uniform Guidance (2 CFR 200).
• Document automations thoroughly, including process maps, logic, data lineage, access controls, and runbooks, so that clients can maintain and audit them independently.
• Establish version control, testing, and change management practices for automations, and ensure they comply with client IT security and data governance policies.
• Train client staff on how to operate, monitor, and modify automations, and transition ownership to permanent teams at the end of an engagement.
• Evaluate client processes to identify automation opportunities, estimate return on investment, and recommend a prioritized roadmap.
• Support backfill and interim engagements where automations reduce workload for embedded consultants, and ensure those automations are documented for the returning staff member.

A successful candidate would possess these skills:

• Ability to work independently and collaborate as part of a team
• Effective written and verbal communication skills
• Meticulous attention to detail and quality of work product
• Ability to build and sustain professional relationships
• Ability to lead projects or workstreams
• Ability to manage and prioritize multiple tasks in a fast-paced and dynamic environment
• Strong interpersonal skills and professional demeanor
• Ability to meet deadlines
• Ability to provide clear guidance to others

The Team

Deloitte’s Government & Public Services (GPS) practice – our people, ideas, technology and outcomes – is designed for impact. Serving federal, state, & local government clients as well as public higher education institutions, our team of professionals brings fresh perspective to help clients anticipate disruption, reimagine the possible, and fulfill their mission promise.

The General Business Finance Data Analytics & Insights team helps finance organizations turn financial and operational data into reliable reporting and actionable insights.

Qualifications

Required:

• Bachelor’s degree in accounting, finance, information systems, computer science, data analytics, or a related field, or equivalent practical experience.
• 3+ years of experience in one or more of the following:
• Building finance or accounting automations using RPA, AI, or other workflow tools;
• Developing query-based reporting output, data validation, or ETL processes;
• Scripting in various languages for financial data analysis; or
• Implementing ERP, reporting, or data integration solutions for finance teams.
• Working knowledge of accounting fundamentals, including general ledger structures, reconciliations, journal entries, and the chart of accounts. Familiarity with fund accounting and GASB or FASB standards is preferred.
• Hands-on experience with automation and intelligence platforms or a business intelligence tools (Power BI, Tableau, or similar).
• Understanding of internal controls, COSO principles, and audit requirements, with the ability to design automations that produce audit-ready evidence.
• Familiarity with data governance, information security, and access controls in regulated environments.
• Ability to obtain/maintain and security clearances needed for the client and/or project.
• Ability to work independently across multiple client environments, manage competing priorities, and travel as needed.
• Must be legally authorized to work in the United States without the need for employer sponsorship, now or at any time in the future 

Preferred:

• Strong SQL skills, including joins, aggregations, window functions, and query optimization, with experience working against relational databases.
• Experience with ERP (such as SAP, Workday, Oracle, PeopleSoft) or other systems (for example Workiva, Balckline, One Stream, Anaplan, etc), is preferred.
• Experience supporting federal, state, local government, or higher education clients
• Experience with data warehousing or lakehouse architecture
• Experience with Extract, Transform, Load (ETL) orchestration tools
• Experience working in Agile delivery environments
• Experience using Git-based version control and continuous integration/continuous deployment pipelines
• Master’s degree in Computer Science, Accounting Information systems, Engineering, Data Science, Information Systems, Mathematics, or Statistics
• Strong documentation skills and the ability to explain technical solutions clearly to non-technical finance stakeholders.