OPAL Data Conversion, Analytics, and Reporting Lead jobs in United States
cer-icon
Apply on Employer Site
company-logo

City of Philadelphia · 17 hours ago

OPAL Data Conversion, Analytics, and Reporting Lead

positionPhiladelphia, PA
timeFull-time
remoteOnsite
senioritySenior Level
money$110K/yr - $128K/yr
date7+ years exp

The City of Philadelphia's Office of Innovation & Technology (OIT) is seeking an OPAL Data Conversion, Analytics, and Reporting Lead to manage a team focused on data conversion, analytics, and reporting for the OPAL ERP and DW/BI project. The role involves overseeing the conversion of various data types and ensuring data quality throughout the project.

Law EnforcementNewsPublishing
check
H1B Sponsor Likelynote

Responsibilities

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

Qualification

Data conversionData analyticsERP implementationData Warehouse experienceFinancial data analysisProcurement data analysisSupply chain data analysisMeeting facilitationMulti-taskingCommunication skillsProblem solvingTeam leadership

Required

Completion of a Bachelor's or Master's 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
Extensive BI and Data Warehouse experience required
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
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

Preferred

Experience with implementing ERP and/or DW/BI solutions strongly preferred

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

twittertwittertwitter
Glassdoor3.7
company-logo
Philadelphia is the largest city in the Commonwealth of Pennsylvania, the fifth-most-populous city in the United States.
dateFounded in 1682
location
Philadelphia, Pennsylvania, USA
people-size10001+ employees
web-link
http://www.phila.gov/

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 Stage

Leadership Team

A
Alan Burstein
Chief Surveyor
linkedin
A
Alba Collazo-Irwin
Chief Deputy
linkedin

Recent News

The Philadelphia Inquirer
The time Philly almost didn’t have a Thanksgiving Day parade
2025-11-27
The Philadelphia Inquirer
Philadelphia’s pre-K program needs transparency, not a tax repeal
2025-11-12
The Philadelphia Inquirer
Greyhound bus terminal likely to reopen on Filbert Street after two years of tumult
2025-10-31
Company data provided by crunchbase