Tri-Force Consulting Services, Inc. - Database Programmer/Analyst

Database Developer is needed in Philadelphia, United States.

Client: Tri-Force Consulting Services, Inc.

Location: Philadelphia, PA, us

Contract: Freelance

Job Description

Title: Database Programmer/Analyst

Duration: 3 months

Location: Philadelphia, PA (Primarily remote, but at least one on-site meeting preferred)

Interview: 2 rounds of interviews (Virtual is acceptable, but in person is 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.

Requirements

Required Skills/Experience

• 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 Skills/Experience

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

Additional Information

“If you are: bright, motivated, skilled, a difference-maker, able to get things done, work with minimum direction, enthusiastic, a thinker, able to juggle and multi-task, communicate effectively, and lead, then we would like to hear from you. We need exceptionally capable people for this role for our client, so get back to us and tell us why you think you are a fit.”

About Us: Since 2000, Tri-Force Consulting Services (https://triforce-inc.com) has been an MBE/SDB certified IT Consulting firm in the Philadelphia region. Tri-Force specializes in IT staffing, software development (web and mobile apps), systems integration, data analytics, system automation, cybersecurity, and cloud technology solutions for government and commercial clients. Tri-Force works with clients to overcome obstacles such as increasing productivity, increasing efficiencies through automation, and lowering costs. Our clients benefit from our three distinguishing core values: integrity, diligence, and technological excellence. Tri-Force is a six-time winner among the fastest-growing companies in Philadelphia and a four-time winner on the Inc. 5000 list of the nation’s fastest-growing companies.