At a Glance
- Tasks: Join our team as a Junior PostgreSQL Developer and optimise database structures for impactful data analysis.
- Company: Dynamic tech company focused on public sector data solutions.
- Benefits: Hybrid work model, training opportunities, and a supportive team environment.
- Other info: Upskilling journey available to enhance your technical expertise.
- Why this job: Make a real difference by bridging data analysis and engineering in a collaborative setting.
- Qualifications: Strong PostgreSQL skills and a passion for database development.
The predicted salary is between 30000 - 40000 £ per year.
Location: Hybrid (On-site London 2 days per week)
Role Overview
We 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 Responsibilities
- Data Mapping & Transformation: Focus on core database tasks, specifically writing clean, efficient queries to map and transform raw data into structured relational tables.
- ETL & 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 & Qualifications
Must-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 & Database Objects: Familiarity or exposure to writing procedural code (PL/pgSQL), stored procedures, functions, and triggers.
- Semi-Structured Data (NoSQL equivalent): Working knowledge of handling JSON/JSONB data types within PostgreSQL.
- Performance & Integration Awareness: Basic familiarity with indexing strategies, query execution plans (EXPLAIN), or connecting PostgreSQL to wider cloud environments (e.g., Azure integration or Foreign Data Wrappers).
Training & Development
If you bring strong PostgreSQL skills and an eagerness to specialize further in database engineering, that is enough to start. We provide a 3 to 6-month upskilling journey on our platform to help close any remaining technical gaps (such as advanced optimization, procedural coding, and database administration basics) in alignment with the role.
PostgreSQL Developer in London employer: CODEVERSE LIMITED
Join a forward-thinking company that values innovation and collaboration, where as a Junior PostgreSQL Developer, you will have the opportunity to work in a hybrid environment in London, fostering a culture of continuous learning and professional growth. With a strong emphasis on employee development, we offer tailored training programmes to enhance your skills in database engineering, ensuring you are well-equipped to contribute to impactful public sector data projects. Our supportive work culture encourages teamwork and creativity, making it an excellent place for those seeking meaningful and rewarding employment.
