At a Glance
- Tasks: Design and develop ETL processes to transform and integrate data from various sources.
- Company: Join a leading bank in London with a hybrid work model.
- Benefits: Competitive pay, flexible working, and opportunities for professional growth.
- Other info: Collaborate with diverse teams and tackle complex data challenges.
- Why this job: Make an impact by ensuring data quality and governance in a dynamic environment.
- Qualifications: Experience with PostgreSQL, Oracle, SQL Server, and strong Python skills required.
The predicted salary is between 54000 - 66000 £ per year.
Database Engineer / Developer
Location
London, UK (Hybrid)
Contract
Initial 6 months (Outside IR35)
The Role
We are partnering with a leading bank to find a Database Engineers / Developers to support data engineering and transformation initiatives across identity, privileged access and platform account data.
The role will focus on designing and developing robust ETL processes, integrating data from multiple sources, applying data quality and governance controls, and transforming Python-based data processing logic into scalable, production-ready solutions.
You will work across database, data engineering and reporting environments, collaborating with technical and security stakeholders to ensure data is accurate, governed and suitable for operational and analytical use.
Key Responsibilities
- Design and develop ETL processes to extract, transform and integrate data from multiple sources.
- Work with relational databases including Postgre SQL, Oracle and/or SQL Server.
- Develop data extraction, transformation and integration solutions across databases and flat-file sources including CSV, Excel and text files.
- Translate Python-based data processing and transformation logic into scalable, production-ready ETL solutions.
- Perform data cleansing, validation and reconciliation across complex datasets.
- Implement data quality and governance checks across identity, privileged access and platform account data.
- Support data warehousing, dimensional modelling and reporting solutions.
- Investigate data issues, identify discrepancies and work with stakeholders to resolve data quality problems.
- Develop and maintain technical documentation covering data flows, transformations, processes and controls.
- Collaborate with security, infrastructure, data and business teams to understand requirements and deliver reliable data solutions.
- Support reporting and dashboard development using Power BI and/or Tableau where required.
- Contribute to source control, release management and deployment processes.
Essential Skills & Experience
- Strong commercial experience working with Postgre SQL, Oracle and/or SQL Server.
- Strong experience designing and developing ETL processes.
- Proven experience extracting, transforming and integrating data from multiple sources, including databases and flat files.
- Experience working with data warehousing, dimensional modelling and reporting solutions.
- Strong Python experience, particularly for data processing, transformation and automation.
- Experience translating Python-based processing logic into scalable and production-ready ETL solutions.
- Strong understanding of data quality, validation, reconciliation and governance.
- Experience working with large or complex datasets where accuracy, completeness and consistency are critical.
- Strong analytical and problem-solving skills with excellent attention to detail.
Desirable Skills & Experience
- Experience developing Power BI and/or Tableau dashboards and reports.
- Familiarity with Cyber Ark and Privileged Access Management (PAM).
- Experience working with identity, access management or cybersecurity-related datasets.
- Knowledge of Git and source control practices.
- Experience with Azure Dev Ops and release management processes.
- Understanding of the Snowflake data platform.
- Experience working within financial services or other highly regulated environments.
- #J-18808-Ljbffr
Database Developer in London employer: Stott and May
Join our dynamic and rapidly expanding cyber security organisation, where you will play a pivotal role in shaping the Offensive Security Strategy as a Penetration Testing Lead. We foster a collaborative work culture that prioritises employee growth through mentorship and hands-on experience, while offering competitive benefits and a commitment to staying at the forefront of industry trends. Located in a vibrant area, we provide unique opportunities for professional development and engagement with cutting-edge technologies, making us an excellent employer for those seeking meaningful and rewarding careers in cybersecurity.
StudySmarter Expert Advice🤫
We think this is how you could land Database Developer in London
✨Get Social in the Data World
Join online communities like Stack Overflow or Reddit's r/Database to connect with others in database management. Share your insights and ask questions to get noticed by industry insiders who might know of temporary roles!
✨Showcase Your Skills
Create a small project using the database software you’re familiar with—maybe something fun like a personal book or music database. Having a project to demonstrate will make you stand out to companies like Stott and May when they see your hands-on approach!
✨Utilise Temporary Staffing Agencies
Many temp positions in database management are filled through staffing agencies. Get in touch with agencies that focus on tech roles, and let them know you're on the lookout for short-term opportunities. They can be a great bridge to finding your next gig.
✨Direct Applications are Key!
Don’t shy away from applying directly to Stott and May through our website. Temporary roles often get posted without fanfare, so check back frequently, and don’t hesitate to reach out if you see a position that fits your skills!
We think you need these skills to ace Database Developer in London
Some tips for your application 🫡
Highlight Your Technical Skills:In the world of database management, it’s essential to showcase your technical skills upfront. Make sure your CV includes relevant programming languages, database systems you’ve worked with, and any data modelling tools you’re familiar with. We want to see how your skills align with the needs of Stott and May.
Document Your Projects:If you have completed any database projects, don’t forget to mention them! Include specific examples that demonstrate your problem-solving abilities and your experience with data migration or optimisation. Having a portfolio or a section on your CV detailing these projects can really set you apart in a temporary role.
Express Your Flexibility:Since this is a temporary position, it’s key to highlight your adaptability in your cover letter. Let us know that you’re ready to jump into different tasks and tackle challenges as they arise at Stott and May. This shows that you’re not just looking for another job, but you’re excited about contributing to our team.
Keep it Concise:For a temporary role like this, keep your application concise and focused. Use bullet points to list your relevant experience and skills, making it easier for us to absorb the info quickly. Your aim should be to grab attention without overwhelming us with unnecessary details. And remember, submit your application through our website!
How to prepare for a job interview at Stott and May
✨Get Hands-On with Tools
In database management, it’s crucial to be familiar with the tools of the trade like SQL, NoSQL, or even data visualisation software. Make sure you’ve got some practical examples ready to discuss how you’ve used these tools, and maybe even try to whip up a sample database to share in a discussion. This shows you're not just theory, but can get stuck in.
✨Brush Up on Technical Questions
Expect some technical questions that dive deep into your problem-solving skills. Be prepared to tackle scenarios where you might need to optimise a database query or explain data normalisation. This is a key area for database management roles, and demonstrating your understanding here can set you apart from other candidates.
✨Show Your Flexibility and Adaptability
Since this is a temporary role, showcasing your flexibility is key. Be ready to discuss past experiences where you quickly adapted to new systems or tasks. Emphasise your eagerness to hit the ground running and how easily you can familiarise yourself with the company’s database systems. Companies love a candidate who can dive right in without unnecessary handholding!
✨Pitching Yourself and Your Availability
In a temporary role, your availability is crucial. Be upfront about your schedule and how you can commit to the temporary demands of the job. Plus, don’t forget to express your keen interest in learning and contributing to Stott and May—they’ll appreciate your enthusiasm for both the role and their team!
