Database Programmer Analyst-experience writing SQL for PostgreSQL- remote
Salário Estimado
R$ 9.600,00 - R$ 10.880,00
Descrição da Vaga
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 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
Requisitos
- 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
- Familiarity with REST APIs and common authentication
Responsabilidades
- 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
- 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
Benefícios
Vagas Semelhantes
Desenvolvedor Full-Stack Python React
R$ 7k - 11k/mês
Descrição da vaga Buscamos um engenheiro apaixonado por construir produtos robustos, escaláveis e bem arquitetados — do backend ao frontend, com fluência em cloud. Você vai integrar um time de engenharia que constrói plataformas de alto volume, com APIs críticas, pipelines assíncronos e interfaces m...
Backend Software Engineer (Python / Node / Java / Go)
R$ 8k - 11k/mês
Required Skills: • AWS • Azure • +31 Remote Job Job Description This is a remote position. We are seeking a Backend Software Engineer to design and build scalable, high-performance APIs and services using Python, Node.js, Java, or Go. This role focuses on building reliable backend systems, improving...
R$ 7k - 11k/mês
the position EDB provides a data and AI platform that enables organizations to harness the full power of Postgres for transactional, analytical, and AI workloads across any cloud, anywhere. EDB empowers enterprises to control risk, manage costs and scale efficiently for a data and AI led world. Serv...
Back-end Developer (Python/Django & Web3)
R$ 9k - 14k/mês
Backend Engineer (Python \/ Django & Web3) - Remote. We are looking for an experienced Backend Engineer to build and scale the core systems of our Security Token Offering (STO) and digital asset platform. You will design secure, scalable, and high-performance backend services that power financial tr...
Informações
Análise de Vaga com IA
Estimativa salarial, match de tecnologias e análise de requisitos feitos com Inteligência Artificial
Powered by CodeCortex