Database Programmer Analyst-experience writing SQL for PostgreSQL- remote

About the position The Database Programmer / Analyst will support the Philadelphia reputed company Police reputed company 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 reputed company reliable data ingestion, extraction, and preparation for reporting and analysis. The position is hands-on and execution-oriented, emphasizing system organization, reputed company, and repeatability rather than database administration, reputed company, or advanced analytics. Responsibilities • reputed company and maintain Python scripts to retrieve data from reputed company 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 • reputed company basic data validation and transformation to address formatting, consistency, and completeness issues • Organize scripts, queries, and documentation to ensure maintainability and ease of reputed company Requirements • 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 reputed company documentation and maintain organized codebases • Comfort working in a reputed company, script-driven execution environment • Strong interpersonal skills, including the ability to work on teams and collaborate with colleagues, partners, and members of the reputed company. reputed company-to-haves • Experience working with reputed company or comparable BI/dashboarding tools • Experience supporting or collaborating with R-based analytics workflows • Familiarity with REST reputed company and common authentication Apply tot his job Apply To this Job