Database Programmer Analyst-Writing SQL For Postgresql- Remote-3 Mon-20 Hrs Week

AthariPhiladelphia, PA

Apply with Sonara

Automate your job search with Sonara.

Submit 10x as many applications with less effort than one manual application.¹

Reclaim your time by letting our AI handle the grunt work of job searching.

We continuously scan millions of openings to find your top matches.

Overview

Schedule

Full-time

Career level

Senior-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

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

Automate your job search with Sonara.

Submit 10x as many applications with less effort than one manual application.

Apply with Sonara Apply manually

FAQs About Database Programmer Analyst-Writing SQL For Postgresql- Remote-3 Mon-20 Hrs Week Jobs at Athari

What is the work location for this position at Athari?

This job at Athari is located in Philadelphia, PA, according to the details provided by the employer. Some roles may also include multiple work locations depending on the requirement.

What pay range can candidates expect for this role at Athari?

Candidates can expect pay range between $60–$68 for this role.

What employment applies to this position at Athari?

Athari lists this role as a Full-time position.

What experience level is required for this role at Athari?

Athari is looking for a candidate with "Senior-level" experience level.

What is the process to apply for this position at Athari?

You can apply for this role at Athari either through Sonara's automated application system, which helps you submit applications 10X faster with minimal effort, or by applying manually using the direct link on the job page.