Database Programmer Analyst-experience writing SQL for PostgreSQL- remote
Location
Pennsylvania
Posted
11 days ago
Salary
Not specified
Job Description
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
Job Requirements
- 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 (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
Related Guides
Related Job Pages
More Backend Engineer Jobs
Mid-Level Full Stack Developer building web applications at Simpluris
We are looking for a versatile, growth-minded Mid-Level Full Stack Developer to join our development team on a one year contract. You’ll be a key player in building, scaling, and maintaining modern web applications. This role is perfect for someone who enjoys the logic of backend...
Head of GTM at BigFilter leading go-to-market strategy in cybersecurity.
This role involves developing high-performance and low-latency products to verify results and provide reliability for in-game play. Write Rust code, that's sophisticated, fast, and readable for complex, data science infrastructure Design core, backend software components, and cod...
