Database Programmer/Analyst

Job Description

Job Summary: 

The Database Programmer/Analyst will be responsible for the implementation and maintenance of data pipelines into and out of a PostgreSQL database. The role involves writing and maintaining scripts and queries for reliable data ingestion, extraction, and preparation for reporting and analysis. This is a hands-on position focused on system organization, clarity, and repeatability. Location:Pennsylvania, United States Responsibilities:


- 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 maintain...