ERP Test Planning Analyst

In partnership with the Office of the Chief Administrative Officer (CAO) and the Office of the Director of Finance, the Office of Innovation and Technology (OIT) is undertaking a major Citywide project to modernize core financial, grants, procurement, and supply chain business processes. This project (Optimize Procurement and Accounting Logistics Enterprise Resource Planning and Data Warehouse/Business Intelligence Tool, or “OPAL ERP and DW/BI project”) will replace the existing General Ledger and Procurement systems (i.e. FAMIS, ADPICS, ACIS, PHLContracts, etc.) that support these business processes and will enable the City to realize benefits such as reducing transaction processing time and effort, providing better access to information for reporting and analysis, and making it easier to onboard new employees into these functions.

The Test Analyst supports a team responsible for managing testing activities for the OPAL ERP and DW/BI project. Key focus areas include financial and grants testing, as well as procurement and supply chain testing. This permanent exempt position will transition into ongoing maintenance and support work after the project’s completion.

The role involves analyzing and refining project requirements, collaborating with implementation consultants on system design, conducting initial user acceptance testing, training City personnel, supporting system integrations with other City applications, and assisting with the phased launch of the software. After deployment, the team will enter an optimization phase to assess performance and implement enhancements. Because the ERP operates as a Software-as-a-Service (SaaS) platform, the role will also require continuous support, testing, and training for new functionality released every 3 to 6 months.

Essential Functions

Throughout the OPAL ERP and DW/BI project, the Test Analyst will:

• Develop and support detailed test plans and strategies.
• Coordinate with development teams to ensure thorough testing of modules and applications.
• Work with functional and OIT counterparts to develop testing workflows, system, integration, user acceptance, and readiness deployment phases.
• Identify, log, and track defects.
• Debug and resolve software issues.
• Oversee quality assurance efforts.
• Ensure defined standards and processes for software or product testing.
• Provide feedback and recommendations on software usability and functionality.
• Participate in design reviews and provide input on requirements, product design, and potential problems.
• Train the team in software testing best practice.
• Ensure compliance with general programming best practices, accepted web standards, and those set forth by upstream sources.
• Provide guidance and support to team members.

• Completion of a Bachelor’s or Master’s degree in information systems, computer engineering, or a related field or equivalent experience;
• Technical expertise with data reporting tools and programming languages such as SQL, R, or Python;3-5 years of experience with ERP systems, 3rd Party Applications and related integrations.
• Experience with implementing ERP and/or DW/BI solutions strongly preferred

Competencies, Knowledge, Skills and Abilities

• Experience supporting system, integration, user acceptance, and dress rehearsal script development.
• Knowledgeable about software testing tools, processes and methodologies.
• Able to work through the process of detecting and correcting flawed process steps.
• Knowledgeable about current state workflows and how these processes will work in the new environment.
• Knowledgeable of Systems Development Life Cycle (SDLC).
• Strong problem solving and analytic skills.
• Some experience formulating test script scenarios: system, integration, user acceptance, and dress rehearsal scripts.

Please note: Applications will not be considered without a cover letter. Did you know?

• We are a Public Service Loan Forgiveness Program qualified employer : 25% tuition discount program for City employees (and sometimes spouses and dependents as well) in partnership with area colleges and universities

• We offer 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

*The successful candidate must be a city of Philadelphia resident within six months of hire Effective May 22, 2023, vaccinations are no longer required for new employees that work in non-medical, non-emergency or patient facing positions with the City of Philadelphia. As a result, only employees in positions providing services that are patient-facing medical care (ex: Nurses, doctors, emergency medical personnel), must be fully vaccinated.

With a workforce of over 25,000 people, and opportunities in more than 1,000 different job categories, the City of Philadelphia is the fifth largest city in the United States and one of the largest employers in Southeastern Pennsylvania. As an employer, the City of Philadelphia operates through the guiding principles of service, integrity, respect, accountability, collaboration, diversity and inclusion. Through these principles, we strive to effectively deliver services, to resolve the challenges facing our city, and to make Philadelphia a place where all our residents have the opportunity to reach their potential.

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 for the City of Philadelphia - increasing the effectiveness of the information technology infrastructure, where the services provided are advanced, optimized, and responsive to the needs of the City of Philadelphia’s businesses, residents, and visitors. OIT responsibilities include: identifying the most effective approach for implementing new information technology directions throughout city government; improving the value of the city’s technology assets and the return on the city’s technology investments; ensuring data security continuity; planning for continuing operations in the event of disruption of information technology or communications services; and supporting accountable, efficient and effective government across every city department, board, commission and agency.