Join to apply for the SQL Developer/Analyst role at Bromcom
3 weeks ago Be among the first 25 applicants
Join to apply for the SQL Developer/Analyst role at Bromcom
Get AI-powered advice on this job and more exclusive features.
Job Description
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 data to ensure its integrity, accuracy, and consistency, using data validation techniques.
Job Description
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 data to 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
Please note, in this role you will have access to sensitive data, the selected employee will be required to go through UK Security clearance after joining the company.
Bromcom is an equal opportunities employer.
Seniority level
* Seniority level
Mid-Senior level
Employment type
* Employment type
Full-time
Job function
* Job function
Information Technology
* Industries
Software Development
Referrals increase your chances of interviewing at Bromcom by 2x
Sign in to set job alerts for “SQL Developer” roles.
Graduate Software Developer - Fully Remote
Basildon, England, United Kingdom 1 week ago
London Area, United Kingdom £35.00-£40.00 17 hours ago
London, England, United Kingdom 1 day ago
London, England, United Kingdom 1 week ago
Baker Street, England, United Kingdom 1 week ago
London, England, United Kingdom 1 week ago
Graduate Software Engineer - Fully Remore Working
Dartford, England, United Kingdom 4 days ago
London, England, United Kingdom 2 days ago
Baker Street, England, United Kingdom 1 month ago
London, England, United Kingdom $40,000.00-$50,000.00 3 weeks ago
London, England, United Kingdom 1 week ago
London, England, United Kingdom 1 week ago
London, England, United Kingdom 1 week ago
City Of London, England, United Kingdom £400.00-£450.00 2 weeks ago
London, England, United Kingdom 2 weeks ago
London, England, United Kingdom 5 days ago
London, England, United Kingdom 4 days ago
Greater London, England, United Kingdom 2 weeks ago
London, England, United Kingdom 2 weeks ago
London, England, United Kingdom 1 week ago
Python Software Engineer – Analytics and AI
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr