Job Closed

This listing is no longer active.

Database Programmer Analyst-writing SQL for PostgreSQL- remote-3 mon-20 hrs week

Location

Pennsylvania

Posted

93 days ago

Salary

0

Seniority

Mid Level

English

Job Description

Database Programmer Analyst-writing SQL for PostgreSQL- remote-3 mon-20 hrs week

Athari

Position overview / Statement of Work Pay rate -$60-$68.00 an hour 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

Job Requirements

  • 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

Related Categories

Related Job Pages

More Content Writer Jobs

Jobgether logo

Senior Editor

Jobgether

We use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team. We appreciate your interest and wish you the best! Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time. #LI-CL1 We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.

Content Writer94 days ago
OtherRemoteH1B No Sponsor

In this role, you will lead the creation and execution of newsletter content strategies designed to engage audiences, drive traffic, and support monetization initiatives. You will craft compelling, accurate, and on-brand stories across multiple digital platforms, including newsletters, podcasts, and social media. This position requires creativity, editorial judgment, and the ability to work in a fast-paced, deadline-driven environment. You will collaborate closely with cross-functional teams, including Audience Development and Commerce, to optimize content performance and enhance reader experience. The role offers autonomy, impact, and the opportunity to shape newsletter initiatives that educate, inspire, and convert audiences. You will contribute directly to building meaningful connections with readers while supporting business objectives. Develop, write, and execute newsletter content strategies that engage readers and support monetization Collaborate with cross-functional teams to align content with audience insights, commerce goals, and platform initiatives Repurpose social and multimedia content to enhance newsletter offerings and extend reach Contribute to podcast content strategies, including supporting newsletters that promote episodes and listener engagement Monitor audience and performance data to refine content strategy and optimize engagement metrics Ensure content is accurate, on-brand, and meets editorial standards across all channels

United States
Job Closed
OtherRemoteTeam 1-10H1B No Sponsor

• Lead the proposal effort from solicitation review through final submission • Develop proposal schedules, compliance matrices, outlines, and content plans • Manage internal and external contributors to ensure deadlines and quality standards are met • Serve as the central point of accountability for proposal execution • Write and edit technical, management, and past performance volumes • Translate complex IT and cybersecurity concepts into clear, persuasive proposal language • Ensure all responses are compliant with solicitation instructions and evaluation criteria • Integrate inputs from SMEs, engineers, and partners into cohesive narratives • Conduct solutioning sessions and interviews with technical SMEs and engineers • Extract and shape technical content into evaluation-ready proposal language • Work closely with leadership to align proposals with company strategy and win themes • Perform compliance checks, color reviews, and final quality reviews • Ensure consistency in tone, messaging, and formatting across all volumes • Validate traceability to Section L/M (or equivalent) requirements

Virginia
Job Closed
Slate Auto logo

Jurisprudence Intern

Slate Auto

We built it. You make it. A radically simple, affordable and personalizable truck (or SUV, your call).

Content Writer95 days ago
OtherRemoteTeam 201-500H1B Sponsor

Slate’s Jurisprudence section is seeking a paid spring editorial intern. This position is remote. You’ll be collaborating directly with our Jurisprudence team to produce legal coverage for the site, including writing articles on Supreme Court opinions. Write legal commentary on the Supreme Court opinions released as part of the 25–26 term Brainstorm and produce “Opinionpalooza” articles for Slate’s end-of-term court coverage Work with and assist Mark Joseph Stern, Dahlia Lithwick, and Slate’s Jurisprudence team Assist in article framing and production for regular stories and Amicus transcripts Contribute to Slate’s legal coverage outside of the courts

United States
Job Closed
JadeClass Education logo

Online Math Teacher

JadeClass Education

Quality international education

Content Writer96 days ago
OtherRemoteTeam 51-200Since 2008H1B No Sponsor

Advertisement Are you looking for an awesome new online teaching gig? JadeClass Education Singapore is hiring energetic, confident, and adaptable teachers for our on-line math program. In turn, we will provide you with the students, online-teaching tools, structure, and resources that you will need to teach with confidence.   We are looking for top quality teachers who can commit to a fixed schedule of at least two classes a week, starting in July. We pay $75 for each 90-minute lesson (covering preparation and teaching time). The first time you teach each lesson, we might ask you to record a preview video (without students), for which we'll pay an extra $25.   If you are as excited about online education as we are, then we would love to hear from you!   School Description JadeClass Education Singapore provides enrichment education to bright students who already have a good command of the English language and plan on continuing their education abroad. We are a group of talented teachers who develop and deliver in-person and online classes in English and STEM. Our students range from 6–16 years old and are carefully screened for English level, behavior, and motivation. We focus on teaching concrete skills that help our students succeed in their learning endeavors.   Job Responsibilities ·         Deliver engaging, high-energy online math classes for up to eight students ·         Review materials and record lesson-prep as required to ensure quality ·         Complete a series of classes without absences or rescheduling Schedule Our lessons are typically scheduled during the following times, based on student and teacher availability: ·         Fall/Spring term          Fri                 18:00-21:00 (UTC +8) Sat                 08:30–20:30 (UTC+8) Sun                08:30–20:30 (UTC+8)   ·         Summer term:            Mon/Thurs           08:30–20:30 (UTC+8)                  Wed/Sat        08:30–20:30 (UTC+8) Course Description Our small-group, online math courses place a single teacher with 6-8 students. Classes meet online each week, on the ClassIn platform (classin.com) for 90-minutes. Lessons are based around coursework/PPTs developed by our in-house development team. Training and support will be provided. Technology Requirements - Fast and stable internet connection (~20mbps up and down) - Modern, reliable computer (~10,000+ on www.cpubenchmark.net/cpu_list.php)   Application Process If you are interested in applying, please send the following to us at teaching@jadeclass.com: ·         Your resume ·         A YouTube/Vimeo link to your introduction video telling us about your teaching background (we will not consider your application without this) ·         A screenshot of your device specifications ·         A link to your speedtest.net results ·         Where you found this position ·         The name of the position for which you wish to apply

United States
Job Closed