Data Warehouse Developer
City of PhiladelphiaPhiladelphia, Pennsylvania, United States
Posted February 17, 2026
65000 - 75000 USD
Full Time
About the Company
The Office of Innovation & Technology (OIT) is the central IT agency for the City of Philadelphia and is led by the Chief Information Officer (CIO).
Job Description
The Data Warehouse Developer (DWD) supports information integration and delivery needs for the Department of Behavioral Health and Intellectual Disability Services (DBHIDS) as part of the enterprise data warehouse (EDW) team.
Requirements
- Developing data warehousing solutions consistent with the vision and direction of the department’s Data Governance Framework Strategic Plan.
- Designing, testing, implementing, and monitoring data integration programs to consume data from multiple sources, archive it, create load routines, and load it into an integrated data vault-based Kalido EDW implementation.
- Working closely with the business intelligence unit and internal customers across DBHIDS to optimize reports and analytics capability using the Qliksense business intelligence platform.
- Maintaining data lineage through source-to-target mapping documentation and documenting rules and procedures required to transform, process, and load data into the EDW or into reporting solutions.
Benefits
- Comprehensive health coverage for employees and their eligible dependents
- Wellness program
- Paid vacation, sick leave, and holidays
- Generous retirement savings options
- Student loan forgiveness program
- Free Commute on SEPTA
- Tuition Discounts and Scholarships
