Database Programmer / Analyst

Title: Database Programmer / Analyst
Location: Philadelphia, PA 19107 (Has to attend Monthly PI Meetings Onsite) 
Duration: 3 Months, PART TIME 20 hours per week

NEED CANDIDATES FROM NEIGHBOUR STATES WITH DL COPY

Internal Database Development Project - This project will entail the implementation and ongoing maintenance of data pipelines into and out of a PostgreSQL database.

Position overview / Statement of Work:
The Database Programmer / Analyst will support the 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.
• Document data sources, processing logic, and manual execution steps.
• Troubleshoot data flow issues and support downstream users as needed.

Skills/experience of the assigned staff:
• Demonstrated experience writing SQL for PostgreSQL or similar relational databases.
• Experience with Python scripting for data processing and API interaction.
• Familiarity with moving data between systems (ingestion, transformation, extraction).
• Experience supporting reporting or analytics tools (e.g., BI platforms or statistical software).
• Ability to write clear documentation and maintain organized codebases.
• Comfort working in a manual, script-driven execution environment.
• Strong interpersonal skills, including the ability to work on teams and collaborate with colleagues, partners, and members of the public.

Highly Desired/Preferred:
• Experience working with Metabase or comparable BI/dashboarding tools.
• Experience supporting or collaborating with R-based analytics workflows.
• Familiarity with REST APIs and common authentication methods.
• Experience maintaining small-to-medium data pipelines over time.
• Prior work in environments with limited automation or evolving data practices.