City of Philadelphia · 1 month ago
Enterprise Resource Planning (ERP) Data Analytics and Reporting Analyst
Philadelphia, PA
Full-time
Onsite
Mid Level
$90K/yr - $90K/yr
3+ years expThe City of Philadelphia's Office of Innovation & Technology (OIT) is seeking an Enterprise Resource Planning (ERP) Data Analytics and Reporting Analyst. This role will involve managing the development and implementation of reports and responsibilities associated with the OPAL ERP and DW/BI project, aimed at modernizing the city's financial and procurement processes.
Law EnforcementNewsPublishing
Responsibilities
Gather and document the requirements for ERP data and reports
Prepare and test the reporting configurations to validate the design setup
Create and deploy the business process and systems user procedures
Write/update technical specifications
Create new reports and retrofit existing reports
Meet delivery schedule
Execute and document unit test cases
Provide weekly tasks and reports to development leads
Identify, resolve, and report on ERP data and reporting issues and document enhancements requests
Analyze, define, and design new release reporting functionality to determine relevance to meet the current or new business processes & requirements
Document the business process revisions and application configuration training content
Create and deploy new process,s and systems changes to the end users
Participate in regression testing efforts
Look for opportunities to optimize the business reporting such as new processes to meet future requirements or leverage delivered systems functionality and technology
Participate in break fix and regression testing efforts
Qualification
Required
Completion of a Bachelor's or Master's degree in information systems, computer engineering, or a related field or equivalent experience
3-5 years of experience with ERP systems, 3rd Party Applications and related reports development and deployment
Experience with query development, writing and implementation
Strong problem solving and analytic skillsets
Strong verbal and written communication skills with ability to create user and project security documentation and procedures, clearly and concisely
Strong meeting facilitation and interviewing skills
Ability to work well with individuals at all levels within and outside the organization
Experience documenting business processes, writing functional specifications, creating test scripts, and researching testing issues and documenting user procedures
Preferred
Experience with implementing ERP and/or DW/BI solutions strongly preferred
Experience with Finance and Grants / Supply Chain (SCM) and Procurement business intelligence (BI)/ data warehouse (DW) applications and report generation packages
Benefits
25% tuition discount program for City employees (and sometimes spouses and dependents as well) in partnership with area colleges and universities
Comprehensive health coverage for employees and their eligible dependents
Our wellness program offers eligibility into the discounted medical plan
Employees receive paid vacation, sick leave, and holidays
Generous retirement savings options are available
Company
City of Philadelphia
Philadelphia is the largest city in the Commonwealth of Pennsylvania, the fifth-most-populous city in the United States.
10001+ employees
H1B Sponsorship
City of Philadelphia has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (30)
2024 (13)
2023 (5)
2022 (15)
2021 (13)
2020 (8)
Funding
Current Stage
Late StageLeadership Team
A
Alan Burstein
Chief Surveyor
A
Alba Collazo-Irwin
Chief Deputy
Recent News
The Philadelphia Inquirer
2025-11-27
The Philadelphia Inquirer
2025-11-12
The Philadelphia Inquirer
2025-10-31
Company data provided by crunchbase