Job Title: Database Programmer/Analyst
Duration: 3 months
Location: Philadelphia, PA
Interview: 2 round of interview (Virtually is acceptable, but in person is preferred)
Note: Remote Primarily remote, but atleast one on-site meeting preferred
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
Document data sources, processing logic, and manual execution steps
Troubleshoot data flow issues and support downstream users as needed
Skills/experience of the assigned staff:
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 methods
Experience maintaining small-to-medium data pipelines over time
Prior work in environments with limited automation or evolving data practices
Never miss an opportunity! Create an alert based on the job you applied for.