Database programmer Jobs in USA

Position Title:
Database Programmer/Analyst SO

Date:
February ,

End Date of Current Term of Contract:
December ,

This Service Order ( "SO”) is issued pursuant to Contract ( "Contract”) between the City of Philadelphia ( "City” or "CoP”) and [Vendor Name (blank until selected)].
This Service Order shall automatically terminate upon the earlier of: the termination or expiration of the Contract as it may be extended through renewal terms; the specified End Date set forth below; OR when Services have been performed under the SO totaling the Maximum Budget of $, set forth below.
Provider is responsible for tracking hours to ensure that the approved number is NOT exceeded.
Total hours used and total hours remaining must be reported weekly.
The City shall have no obligation to pay for Services under this SO in excess of the Maximum Budget, or for services performed after the termination or expiration of the Contract.
The resource(s) covered under this SO will support the:
Citizens Police Oversight Commission 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 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
• 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:
Required
• 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 (, 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

Expected duration:
Months, hours per week


Is this SO for a new position?
Yes

Is an onsite interview a must or is the hiring manager open to screening over a Skype (or other) video call for out of state candidates?
Remote is acceptable, but in person is preferred

How many interview rounds will be conducted for the position?


Is there a chance of extension in the duration of the assignment, beyond the budget/duration included in the SO?
Yes

Will the position require the candidate to be onsite completely or there is a possibility of working remotely (partially/completely)?
Primarily remote, but at least one on-site meeting preferred

Can a vendor suggest a different Resource Title based on the position and budget assigned to that position, if the position requires a niche skill?
Yes

By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at .