Athari

• Develop and maintain Python scripts to retrieve data from APIs and other external sources and load it into PostgreSQL • Write and maintain SQL queries, tables, and views to support reporting and analysis • Prepare and structure data for use in dashboards and advanced analytics • Perform basic data validation and transformation to address formatting, consistency, and completeness issues • Organize scripts, queries, and documentation to ensure maintainability and ease of handoff

Position overview / Statement of Work Pay rate -$60-$68.00 an hour The Database Programmer / Analyst will support the Philadelphia Citizens Police Oversight Commission (CPOC) Data Division with implementation and ongoing maintenance of data pipelines into and out of a PostgreSQL database. The role focuses on writing and maintaining scripts and queries that enable reliable data ingestion, extraction, and preparation for reporting and analysis. The position is hands-on and execution-oriented, emphasizing system organization, clarity, and repeatability rather than database administration, security, or advanced analytics. Work activities: ·       Develop and maintain Python scripts to retrieve data from APIs and other external sources and load it into PostgreSQL ·       Write and maintain SQL queries, tables, and views to support reporting and analysis ·       Prepare and structure data for use in dashboards and advanced analytics ·       Perform basic data validation and transformation to address formatting, consistency, and completeness issues ·       Organize scripts, queries, and documentation to ensure maintainability and ease of handoff

Position overview / Statement of Work Pay rate -$60-$68.00 an hour The Database Programmer / Analyst will support the Philadelphia Citizens Police Oversight Commission (CPOC) Data Division with implementation and ongoing maintenance of data pipelines into and out of a PostgreSQL database. The role focuses on writing and maintaining scripts and queries that enable reliable data ingestion, extraction, and preparation for reporting and analysis. The position is hands-on and execution-oriented, emphasizing system organization, clarity, and repeatability rather than database administration, security, or advanced analytics. Work activities: ·       Develop and maintain Python scripts to retrieve data from APIs and other external sources and load it into PostgreSQL ·       Write and maintain SQL queries, tables, and views to support reporting and analysis ·       Prepare and structure data for use in dashboards and advanced analytics ·       Perform basic data validation and transformation to address formatting, consistency, and completeness issues ·       Organize scripts, queries, and documentation to ensure maintainability and ease of handoff