Part-time REMOTE Data Engineer/Analyst

Job Title: Database Programmer/Analyst

Location (On-site, Remote, or Hybrid?): Philadelphia, PA (Primarily remote, but at least one on-site meeting )preferred

Contract Duration: 3 Months, 20 hours per week

The resource(s) covered under this SO will support the:

Citizens Police Oversight Commission Internal Database Development Project - This project will entail the implementation and ongoing maintenance of data pipelines into and out of a PostgreSQL database.

Position overview / Statement of Work

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

Company DescriptionTechLink Systems is a national provider of staffing services with offices all over the USA as well as development and support centers globally. We are a MBE (NMSDC), WBE (WBENC), and WOSB certified minority business that has been awarded 2017 TAPFIN Premier Partner, 2016 Manpower Excellence Award, 2016 TAPFIN Elite Partner, are a Known Tier Supplier for Agile 1, and have been ranked as a Top Women and Minority Owned Company since 2004 by several businesses including Philadelphia Business Journal, Diversity Business, Inc 5000, Inc 500, San Francisco Business Times, Diversity2000, and Los Angeles Business Journal.

We serve the contract staffing, direct hire, staff augmentation, recruitment, HR management, and project outsourcing needs of clients nationwide. Striving to create personal relationships with clients, TechLink Systems becomes a virtual extension of clients’ own in-house capabilities to help achieve new levels of growth, productivity, and competitiveness.

We also have national recruiting