SQL Developer
JN Bentley
Skipton, North Yorkshire, UK
1h ago

Job Description

MMBC is a region of Mott MacDonald, offering our clients full feasibility, design and construction services throughout the UK.

JN Bentley are successfully working alongside companies such as; National Grid, Rolls Royce, Yorkshire Water, Welsh Water, Severn Trent Water, Anglian Water, Environment Agency, United Utilities, Northumbrian Water and the Coal authority which has allowed us to progress as a leader in the construction and civil engineering sectors whilst developing and maintaining an excellent reputation with our clients.

We are looking for a SQL Developer to join our expanding Database team.

The successful candidate will be responsible for developing new systems, integration with 3rd party systems and maintaining existing applications.

A logical, process orientated person with a wide skill set for translating business requirements into solutions. They will be passionate about how data can bring improvements and assist in decision-making across a business.

In the role, you will :

  • Analyse business requirements through collaboration with stakeholders, IT Management and the user community.
  • Engage with stakeholders on data extraction and manipulation tasks
  • Help write and optimise in-application SQL statements
  • Ensure performance, security and stability of databases
  • Provide support to users with regard to report errors, debugging and fixing the issues
  • Integrate new datasets into the data warehouse
  • Create and maintain SQL data feeds in / out of internal, partner and supplier systems
  • Migrate reports from Excel / VBA into SSRS
  • Develop SSIS packaged solutions
  • Net (C# / VB / Java / REST) development experience preferred to support app development, integration, reporting / data injection
  • Provide support towards the design and architecture of a new data warehouse
  • Candidate Specification

    You will have the following essential requirements / experience :

  • Experience working in a database developer role
  • Strong MS SQL experience creating stored procedures, queries, scripting, indexes
  • Skilled at writing and optimising large complicated SQL statements
  • Knowledge of best practices when dealing with relational databases
  • Experience of debugging and performance tuning existing SQL procedures
  • Proficient understanding of using code versioning tools (Git / SVN)
  • Excellent written and verbal communication skills
  • As the role involves handling sensitive data - trustworthiness and a good understanding of GDPR
  • In addition, the following skills / experience would be desirable :

  • Educated to degree level in a relevant IT subject matter
  • SQL certification to MTA but preferably MCSA level
  • Experience of : undertaking development work in C# creating SSIS packages creating and troubleshooting SSRS reports
  • Debugging VBA macros (linked to stored procedures for running reports)
  • Exposure to data warehouse development and maintenance
  • About JN Bentley

    JN Bentley part of the global engineering consultancy Mott MacDonald is a leading civil engineering and construction company, delivering design-and-build projects with clients in the water sector and beyond, across the UK.

    We directly employ over 1,300 people across 9 office locations and hundreds of construction sites nationwide. We have a turnover in excess of £300 million, delivered by our water utilities design and build business Mott MacDonald Bentley (MMB), our environmental design and build business Jeremy Benn Associates-Bentley (JBA-B) and directly by JN Bentley.

    At JN Bentley we believe that when we care about what we do, we do it better. Because we care about our people - keeping them safe, making sure they are happy, enjoy coming to work and feel valued - we are committed to creating a fun workplace, where people have a voice, are safe, reach their potential and prosper, and where the rewards are shared.

    Equality, diversity and inclusion

    JN Bentley Ltd is an equal opportunity employer and welcomes applications from all sectors of the community. We promote an open and transparent culture and a workplace where everyone feels included and is treated fairly and with respect.

    Agile working

    We are committed to providing a flexible and agile working environment that supports both our employees and the needs of the business.

    This role is likely to be predominantly home based, with opportunity for some office working.

    Job category (multi-select)

    Diana Collington

    Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form