PostgreSQL Developer

Location: Hybrid (On-site London 2 days per week)Role OverviewWe are looking for a Junior PostgreSQL Developer to join our data streams. In this role, you will play a critical part in bridging the gap between data analysis and database engineering. You will collaborate closely with data analysts to design, optimize, and maintain the database structures required to drive our public sector data streams, with a heavy focus on backend database development.Core ResponsibilitiesData Mapping and Transformation: Focus on core database tasks, specifically writing clean, efficient queries to map and transform raw data into structured relational tables.ETL and Pipeline Development: Assist in developing database-level ETL (Extract, Transform, Load) processes, using PostgreSQL to clean, aggregate, and prepare data for analysis.Cross-Functional Collaboration: Collaborate closely within paired streams to ensure the database layer effectively supports analytical and reporting requirements.Skills and QualificationsMust-Have:Strong PostgreSQL Skills: This is the core, non-negotiable requirement. You must have strong, hands-on experience specifically writing and executing queries in PostgreSQL, including complex joins, subqueries, CTEs (Common Table Expressions), and window functions.Good-to-Have (Nice to Have):PL/pgSQL and Database Objects: Familiarity or exposure to writing procedural code (PL/pgSQL), stored procedures, functions, and triggers.Semi-Structured Data (NoSQL equivalent): Working ..... full job details .....