IT SQL Developer - Proactive Appointments : Job Details

IT SQL Developer

Our client is looking for an experienced and motivated SQL Developer to work in the Solutions Engineering team within our IT department.  The role will work alongside the existing development and change management teams to continue to develop and enhance our operational database integrations, and data warehouse capabilities.

Working with the Head of Development, this exciting role will consult with key stakeholders and the Head of Data Transformation on their business intelligence requirements – together developing appropriate data structures to feed our visualisation platforms and drive innovative corporate strategy.

Increasingly, they are seeking to enrich and enhance our data capabilities by consuming external data feeds.  Experience of harnessing public or commercially available datasets and APIs to augment corporate data, would be beneficial.

As a SQL expert, you will assist in the development and maintenance of data integrations between operational data platforms.  In addition, supporting our Application Support and Application Production teams to troubleshoot production issues where required.

Necessary Skills/Experience

•             Expert in Microsoft SQL Server.

•             Proficient in writing complex SQL queries to retrieve and manipulate data.

•             Experience in creating and maintaining stored procedures and functions to optimize database performance.

•             Experience with SSIS for data integration and ETL (Extract, Transform, Load) processes.

•             Background in reporting and business intelligence tools, including SSRS.

•             Experience of working within a development environment.

•             Understanding of relational and dimensional data modelling.

•             Familiarity with consuming external data feeds and APIs.

•             Strong mathematical and statistical knowledge.

•             Excellent written and verbal communication skills.

•             Impeccable attention to detail.

•             Strong troubleshooting skills for production issues.

•             Adept at working with all types of stakeholders.

Further Desirable Skills 

•             Other database technologies (Oracle, MySQL, PostgreSQL, MongoDB)

•             REST APIs, Web Services

•             Simego / Ouvvi – data automation

•             .Net

•             Data visualisation tools (e.g. Tableau, Power BI)

•             Python

•             Dataiku

Desirable Experience 

•             Experience of supporting software tools such as Jira, and Service Now.

•             Formal IT qualification (A Level, HND/HNC/BTEC or degree).

•             Bachelor’s degree in computer science or a related field.

•             5+ years of experience in database architecture, or a related field.

•             MCSE/MCSA certifications preferred.

Due to the volume of applications received for positions, it will not be possible to respond to all applications and only applicants who are considered suitable for interview will be contacted. 

Proactive Appointments Limited operates as an employment agency and employment business and is an equal opportunities organisation

We take our obligations to protect your personal data very seriously.  Any information provided to us will be processed as detailed in our Privacy Notice, a copy of which can be found on our website http://proactive.it/privacy-notice/