Database Programmer Analyst-writing SQL for PostgreSQL- remote-3 mon-20 hrs week
Location
Pennsylvania
Posted
15 days ago
Salary
Not specified
Seniority
Mid Level
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 Categories
Related Job Pages
More Content Writer Jobs
Senior Editor
JobgetherWe use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team. We appreciate your interest and wish you the best! Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time. #LI-CL1 We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.
In this role, you will lead the creation and execution of newsletter content strategies designed to engage audiences, drive traffic, and support monetization initiatives. You will craft compelling, accurate, and on-brand stories across multiple digital platforms, including newsle...
Lead Proposal Writer specializing in federal government proposals for IT services
Jurisprudence Intern
SlateThe all-in-one creative suite for social media managers to edit video and images on desktop or mobile. 📱🖥️
Slate’s Jurisprudence section is seeking a paid spring editorial intern. This position is remote. You’ll be collaborating directly with our Jurisprudence team to produce legal coverage for the site, including writing articles on Supreme Court opinions. Write legal commentary on t...
AdvertisementAre you looking for an awesome new online teaching gig? JadeClass Education Singapore is hiring energetic, confident, and adaptable teachers for our on-line math program. In turn, we will provide you with the students, online-teaching tool...
