SQL Developer/Analyst - Bromcom

Skills

Communication Teamwork SQL Version Control Attention to detail Programming git SQL Server

Job Specifications

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

About the Company

Trusted by over 3.3 million users, Bromcom have been connecting the dots between data, people, and outcomes for the last 35 years. Our award-winning IT solutions have been developed and refined to give everyone in the education community the ability to harness the power of data. Whether you’re the CEO of a 50-school trust or a Learning Support Assistant, we equip you with all the information you need to maximise your output, and that of your student population. Secure cloud-based functionality provides you total access to... Know more