Description

You will own the implementation and maintenance of data pipelines into and out of PostgreSQL.

This role is remote.

Responsibilities

• Develop and maintain Python scripts to retrieve data from APIs and external sources, loading 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 data validation and transformation to address formatting, consistency, and completeness issues.
• Document data sources, processing logic, and manual execution steps.

Required Skills

• 10+ years of 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 to collaborate with colleagues and partners.

Preferred Skills

• Experience working with Metabase or comparable BI/dashboarding tools.
• Familiarity with REST APIs and common authentication methods.

Key Skills

Education

Any Graduate