Lead for ERP Data Analytics and Reporting

Company Description

Philadelphia, a city of top-tier talent, serves as a remarkable platform for career building. Its vibrant arts scene, rich history, and endeared culture captivate, and working here is even more rewarding. With a workforce exceeding 30,000 individuals, across more than 1,000 different job roles, the City of Philadelphia provides endless opportunities to make a difference.

The City of Philadelphia, as an employer, values inclusion, integrity, innovation, empowerment, and hard work. We offer a dynamic work environment, comprehensive health care and benefits, and experiences that foster growth and success. If you're intrigued by the prospect of working with a passionate team dedicated to Philadelphia's future, start here.

What we offer

• Impact - Your work matters to millions.
• Growth - Philadelphia is growing, grow along with it.
• Diversity & Inclusion - Build a career where everyone is welcomed.
• Benefits - We care about your well-being.

Agency Description

The Office of Innovation & Technology (OIT) is the central IT agency for the City of Philadelphia led by the Chief Information Officer (CIO). OIT oversees all significant information and communications technology initiatives - enhancing the efficacy of the city's technology infrastructure to deliver advanced, optimized, and prompt services to the city’s businesses, residents, and visitors. Responsibilities include formulating the most effective implementation approach for new technology, increasing returns on technology investments, ensuring data security continuity; and supporting efficient and accountable governance across every city department.

In collaboration with the Office of the Chief Administrative Officer (CAO) and the Office of the Director of Finance, OIT is initiating a major citywide project to modernize core financial, grant, procurement, and supply chain business processes. This project, OPAL ERP and DW/BI, replaces existing general ledger and procurement systems, which will reduce transaction processing time, enhance access to information for reporting and analysis, and facilitate easier onboarding of new employees into these functions.

Job Description

The Enterprise Resource Planning (ERP) Data Analytics and Reporting Lead will manage a team responsible for ERP data reporting for the OPAL ERP and DW/BI project. This permanent position includes overseeing the implementation of all analytics and reporting aspects of the ERP project, including BI and third-party applications, shifting to maintenance and support after project completion (in 3-4 years).

Essential Functions

During implementation:

• Clarify requirements and test with functional users.
• Validate development effort estimates.
• Review and approve technical specifications.
• Supervise developers’ work and delegate tasks.
• Ensure delivered code adheres to development standards.
• Confirm unit test results.
• Represent analytics and reporting during collaborations with functional and technical teams.
• Perform code review.

Post Implementation:

• Lead break fix and regression testing efforts.
• ERP Data Analytics and Reporting Lead will continue as part of the product team after project implementation.

Competencies, Knowledge, Skills and Abilities

• Ability to maintain data confidentiality.
• Strong problem-solving and analytic skills.
• Effective written and oral communication skills, including the ability to create user and project security documentation and procedures succinctly and clearly.
• Exceptional meeting facilitation and interviewing skills.
• Ability to work well at all organizational levels and with external parties.
• Ability to efficiently handle pressure in a fast-paced organization.
• Supervisory, coaching, and collaborative skills.
• Experience in leading a development team.

Work-Life

Generally, the working hours are 37.5 per week. Our team currently works in a hybrid model, with office visits required once every two weeks. However, these policies and requirements might change. This position has the option for daily office attendance, if preferred.

Qualifications

• 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.
• 2-5 years of team leadership experience.
• Experience with implementing ERP and/or DW/BI solutions is a strong preference.

Additional Information

TO APPLY: Interested candidates must submit a cover letter and resume.

Salary Range: $110,000

Discover the Perks of Being a City of Philadelphia Employee:

• Transportation: City employees enjoy FREE unlimited public transportation throughout the year via SEPTA’s Key Advantage program. This includes SEPTA buses, subways, trolleys, and regional rail for daily commute and more.
• Parental Benefits: The City offers its employees 6 weeks of paid parental leave.
• 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.
• Accelerate your student loan payoff - As a qualifying employer, City of Philadelphia offers student loan forgiveness programs.