OPAL Data Conversion, Analytics, and Reporting Lead

The OPAL Data Conversion Analytics and Reporting Lead is responsible for managing a team that handles data conversion data analytics and reporting functions for the OPAL ERP and DW/BI project. The team focuses on converting financial grants procurement and supply chain data as well as developing analytics and reporting in collaboration with the business teams.

This is an exempt position that will transition from project work to maintenance and support after the project is completed.

Essential Functions

Throughout the OPAL ERP and DW/BI project the OPAL Data Conversion Analytics and Reporting Lead will:

• Lead team to readily identify incomplete incorrect inaccurate or irrelevant parts of the finance grants supply chain and reporting data and then replace modify or delete the dirty or coarse data.
• Lead team to research and analyze existing finance grants supply chain and reporting data.
• Lead conversion team to design and map finance grants supply chain and reporting data from the old environment to the new environment.
• Lead conversion team to reconcile the conversion of finance grants supply chain and reporting data to make sure data is complete and accurate.
• Lead team to stage finance grants supply chain and reporting data that is gathered and prepared for conversion.
• Document and track conversion matrix and templates outputs and conversion scripts.
• Participate in regression testing efforts.
• Conduct analysis perform normalization operations and assure data quality.
• Create report and data analytics models.
• Interpret data analysis results.
• Develop actionable insights and present recommendations for use across the stakeholder and leadership.
• Review and approve reports and data analysis

After the OPAL ERP and DW/BI project has been deployed the OPAL Data Conversion Analytics and Reporting Lead will lead enhancement and new development efforts.

Qualifications :

• Completion of a Bachelors or Masters degree with coursework in accounting finance operations management IT business administration or a related field or equivalent experience;
• 7-10 years of professional experience with data conversion analytics and reporting including financial and grants data conversion analytics and reporting; and procurement and supply chain data conversion; and data conversion analytics and reporting.
• Experience with implementing ERP and/or DW/BI solutions strongly preferred.

Competencies Knowledge Skills and Abilities

• Able to work through the process of detecting and correcting (or removing) corrupt or inaccurate records from a record set table or database.
• Readily identifies incomplete incorrect inaccurate or irrelevant parts of the data and then replaces modifies or deletes the dirty or coarse data.
• Knowledgeable about current state dataset/table/field layouts processes and technologies.
• Knowledge of Systems Development Life Cycle from a data conversion perspective.

• Experience with report requests generation maintenance processes and technologies.
• Experience with query development writing and implementation.
• Experience across reporting for financials grants supply chain and procurement.
• Extensive BI and Data Warehouse experience required.
• Strong verbal and written communication skills with ability to create documentation and procedures clearly and concisely.
• Strong meeting facilitation and presentation skills.
• Ability to work well with individuals at all levels within and outside the organization.
• Ability to work well under pressure and multi-tasking in a fast-paced organization.
• Extensive supervising coaching inter-personal and collaborating skills and overseeing high-quality and timely deliverable creation.

• Strong problem solving and analytic skills.

.

Additional Information :

Salary: $110000-$128000

Salary cannot exceed $128000

Were interested in hiring the best possible candidate for the role. We recognize that experience education and qualifications can be attained in a variety of ways and that many skillsets are transferable. If you feel youre a good fit please dont hesitate to apply.

Please include:

• Resume
• A cover letter explaining why youre passionate about participating in the design of the City of Philadelphias digital presence.
• At least three samples of work relevant to the position.

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.

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 or send an email to faqpchr @. For more information go to: Human Relations Website:
Work :

No

Employment Type :

Full-time