Enterprise Resource Planning (ERP) Data Analytics and Reporting Analyst

City of Philadelphia; Philadelphia (Philadelphia County); On-site; USD 80,000 - 90,000; Full time

Benefits offered by this job

25% tuition discount program for City employees

Comprehensive health coverage

Paid vacation, sick leave, and holidays

Generous retirement savings options

Job summary

The City of Philadelphia is seeking an ERP Data Analytics and Reporting Analyst to manage report development and implementation for the OPAL ERP project. The ideal candidate will have a degree in information systems or a related field and 3-5 years of experience with ERP systems. Responsibilities include gathering requirements, creating reports, and analyzing data. The position offers a salary range of $80,000 to $90,000 along with comprehensive health coverage and retirement savings options.

Qualifications

• 3-5 years of experience with ERP systems and report development.
• Experience with ERP and/or DW/BI implementations strongly preferred.
• Must be a City of Philadelphia resident within six months of hire.

Responsibilities

• Gather and document requirements for ERP data and reports.
• Prepare and test reporting configurations.
• Create new reports and retrofit existing reports.

Skills

Finance and Grants / Supply Chain (SCM) and Procurement BI/DW applications

Query development

Problem-solving skills

Analytical skills

Strong verbal communication skills

Strong written communication skills

Meeting facilitation skills

Education

Bachelor’s or Master’s degree in information systems or related field

Tools

ERP systems

DW/BI systems

Job description

Overview

The Office of Innovation & Technology (OIT) is the central IT agency for the City of Philadelphia, headed by the Chief Information Officer (CIO). OIT oversees all major information and communications technology initiatives, increasing the effectiveness of the City’s technology infrastructure and ensuring data security continuity. OIT supports accountable, efficient, and effective government across all city departments, boards, commissions, and agencies.

In partnership with the Office of the Chief Administrative Officer (CAO) and the Office of the Director of Finance, OIT is undertaking a major citywide project to modernize core financial, grants, procurement, and supply chain business processes. The project, titled OPAL ERP and DW/BI, will replace the existing General Ledger and Procurement systems and enable the City to realize benefits such as reduced transaction processing time, better access to information for reporting and analysis, and easier onboarding of employees into these functions.

Job Description

The Enterprise Resource Planning (ERP) Data Analytics and Reporting Analyst will interact daily with the project team, managing the development and implementation of assigned reports and related responsibilities. This is a permanent exempt position that will transition to maintenance and support after project completion (in 3‑4 years).

Essential Functions

During Implementation

• Gather and document requirements for ERP data and reports.
• Prepare and test reporting configurations to validate the design setup.
• Create and deploy the business process and system user procedures.
• Write and update technical specifications.
• Create new reports and retrofit existing reports.
• Meet the delivery schedule.
• Execute and document unit test cases.
• Provide weekly status reports to development leads.

Post Implementation

• Identify, resolve, and report on ERP data and reporting issues and document enhancements requests.
• Analyze, define, and design new release reporting functionality to meet current or new business processes and requirements.
• Document business process revisions and application configuration training content.
• Create and deploy new process and system changes to end users.
• Participate in regression testing efforts.
• Seek opportunities to optimize business reporting, such as new processes to meet future requirements or leverage delivered system functionality and technology.
• Participate in bug‑fix and regression testing efforts.

Qualifications

• 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, third‑party applications, and related report development and deployment.
• Experience with ERP and/or DW/BI implementations strongly preferred.
• Must be a City of Philadelphia resident within six months of hire.
• City of Philadelphia residence requirement effective May 22, 2023.

Competencies, Knowledge, Skills, and Abilities

• Experience with Finance and Grants / Supply Chain (SCM) and Procurement business intelligence (BI)/data warehouse (DW) applications and report generation packages.
• Experience with query development, writing, and implementation.
• Strong problem‑solving and analytical skills.
• Strong verbal and written communication skills with the 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, as well as documenting user procedures.

Additional Information

Salary Range: $80,000 – $90,000. Salary cannot exceed $90,000.

Benefits

• Public Service Loan Forgiveness Program qualified employer: 25% tuition discount program for City employees (and sometimes spouses and dependents).
• Comprehensive health coverage for employees and eligible dependents.
• Wellness program offering eligibility into the discounted medical plan.
• Paid vacation, sick leave, and holidays.
• Generous retirement savings options.
• Vaccination policy: vaccinations are no longer required for new employees that work in non‑medical, non‑emergency or patient‑facing positions. Employees in patient‑facing roles (e.g., nurses, doctors, emergency medical personnel) must be fully vaccinated.

Equal Opportunity Employer Statement

The City of Philadelphia is an Equal Opportunity employer and does not permit discrimination based on race, ethnicity, color, sex, sexual orientation, gender identity, religion, national origin, ancestry, age, disability, marital status, source of income, familial status, genetic information, or domestic or sexual violence victim status. If you believe you were discriminated against, call the Philadelphia Commission on Human Relations at 215‑686‑4670 or send an email to [e-mail]. For more information, go to: Human Relations Website.