Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join our database team to design and manage SQL solutions for data migration projects.
- Company: Be part of a dynamic company focused on innovative data management solutions.
- Benefits: Enjoy flexible working options and opportunities for professional growth.
- Why this job: This role offers hands-on experience with SQL, teamwork, and the chance to make an impact.
- Qualifications: 3+ years of SQL development experience and strong attention to detail required.
- Other info: Work closely with non-technical teams to enhance data integrity and performance.
The predicted salary is between 36000 - 60000 £ per year.
Work within the database development team reporting to the Database and Migration teams manager.
-
Responsible for design, development and management of high quality, efficient and effective solutions in Microsoft SQL Server T-SQL and related tools to support and extend data migration projects.
-
Optimise database performance by identifying bottlenecks, fine-tuning queries, and implementing best practices to enhance the efficiency of internal systems and improve response times.
-
Analyse and cleanse production-level datato ensure its integrity, accuracy, and consistency, using data validation techniques.
Role Responsibility
-
Analyse data to support data cleansing and reconciliation activities.
-
Develop complex queries for data extraction, reporting, and analysis.
-
Work closely with non-technical stakeholders to define and interpret technical requirements.
-
Responsible for identifying issues with the data, data correction, and ensuring the accuracy of the data.
-
Perform data validation as part of an onboarding Migration process.
-
Help manage data conversion activities, ensuring that data structures are appropriately translated into the target format.
The Ideal Candidate
-
The ideal candidate will have substantial experience of SQL programming and an excellent knowledge of the techniques and the functionality and capabilities of MS SQL Server 2017 and above.
-
A strong background in data management and manipulation, code management and version control (GIT) is also important, as is having good attention to detail.
-
Capable of working through problems independently and liaising with team members to find quality solutions.
Your job will involve
-
Writing complex scripts for data manipulation and management report generation
-
Export/Import of data
-
Data conversion/migration
-
Data correction
-
Database object creation (Functions, Stored Procedures, Tables, etc)
-
Performance tuning of new and existing code
-
Analyse SQL code for potential flaws
-
Optimisation and maintenance of existing products
Desired Skills
-
3+ years of SQL Developer experience supporting MS SQL Server Database infrastructures in large-scale environment.
-
Excellent teamwork, communication, and documentation skills
-
Reasonable understanding of OS and Infrastructure / Network layer
#J-18808-Ljbffr
SQL Developer/Analyst employer: Bromcom Computers Plc
Contact Detail:
Bromcom Computers Plc Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land SQL Developer/Analyst
✨Tip Number 1
Familiarise yourself with the latest features of MS SQL Server 2017 and above. Being well-versed in the new functionalities can give you an edge during discussions with the team and show your commitment to staying updated in the field.
✨Tip Number 2
Brush up on your data validation techniques. Since the role involves ensuring data integrity, being able to discuss specific methods you've used in past projects will demonstrate your expertise and problem-solving skills.
✨Tip Number 3
Prepare to showcase your experience with performance tuning and optimisation. Be ready to share examples of how you've identified bottlenecks and improved query efficiency in previous roles, as this is a key responsibility of the position.
✨Tip Number 4
Highlight your teamwork and communication skills. Since you'll be working closely with non-technical stakeholders, being able to explain complex technical concepts in simple terms will be crucial, so think of examples where you've successfully done this before.
We think you need these skills to ace SQL Developer/Analyst
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your SQL programming experience and familiarity with MS SQL Server 2017 and above. Include specific examples of complex queries you've developed and any data management projects you've worked on.
Craft a Strong Cover Letter: In your cover letter, emphasise your ability to analyse and cleanse data, as well as your experience in performance tuning and database optimisation. Mention how you can work closely with non-technical stakeholders to meet their requirements.
Showcase Relevant Skills: Clearly list your skills related to SQL development, data manipulation, and version control (GIT). Highlight your attention to detail and problem-solving abilities, as these are crucial for the role.
Proofread Your Application: Before submitting, carefully proofread your application for any errors or inconsistencies. A polished application reflects your attention to detail, which is essential for a SQL Developer/Analyst.
How to prepare for a job interview at Bromcom Computers Plc
✨Showcase Your SQL Skills
Be prepared to demonstrate your SQL programming expertise. You might be asked to write complex queries or troubleshoot existing scripts during the interview, so brush up on your T-SQL skills and be ready to explain your thought process.
✨Understand Data Management Principles
Familiarise yourself with data management and manipulation techniques. Be ready to discuss your experience with data cleansing, validation, and reconciliation activities, as these are crucial for the role.
✨Communicate Effectively with Non-Technical Stakeholders
Since the role involves liaising with non-technical team members, practice explaining technical concepts in simple terms. This will show that you can bridge the gap between technical and non-technical audiences.
✨Prepare for Performance Tuning Questions
Expect questions about optimising database performance. Be ready to discuss your experience identifying bottlenecks and fine-tuning queries, as well as any best practices you've implemented to enhance efficiency.