Philadelphia International Airport (PHL) · 14 hours ago
OPAL Data Conversion, Analytics, and Reporting Lead job
Philadelphia, PA
Full-time
Onsite
Mid, Senior Level
$110K/yr - $128K/yr
7+ years expThe Philadelphia International Airport (PHL) is seeking an OPAL Data Conversion, Analytics, and Reporting Lead to manage a team responsible for data conversion, analytics, and reporting functions for the OPAL ERP and DW/BI project. This role involves overseeing the conversion of financial, grants, procurement, and supply chain data while developing analytics and reporting in collaboration with business teams.
Air Transportation
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
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
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
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
Philadelphia International Airport (PHL)
Philadelphia International Airport is owned and operated by the City of Philadelphia provides provide Airport news, information & fun stuff.
501-1000 employees
Funding
Current Stage
Late StageTotal Funding
unknownKey Investors
Federal Aviation Administration
2023-02-28Grant
Leadership Team
Atif Saeed, A.A.E., IAP
Chief Executive Officer
Camille Tomlin
Deputy Chief Technology Officer
Recent News
Business Insider
2025-11-07
The Philadelphia Inquirer
2025-11-05
The Philadelphia Inquirer
2025-10-09
Company data provided by crunchbase