BI DBA / SQL Developer (£40-50K)

Job description

BI DBA / SQL Developer (£40-50K)


If you love data and you want a really interesting challenge then we have something pretty unique as we embark our journey with our Local Authority. The Digital Cornwall programme brought together the existing Digital Improvement and Customer Access Programmes, to deliver across three core areas. 

  • A Digitally Ready Cornwall – where we aspire for every resident of Cornwall, who could use technology, to have the confidence and means to do so by 2021
  • Changing How We Work - to ensure every employee and our Members have the appropriate access to and confidence in using improved technology for themselves and customers 
  • Changing How We Deliver to the Customer - to ensure all our customers are able to access high quality services through the most effective channel to meet their needs.

This is one of the biggest things happening the local authority right now and is linked to other council agendas such as becoming carbon neutral by 2030. It will help realise the potential of data in Cornwall, bringing it together in a centralised data warehouse to provide invaluable insight both into what we do and how we do it, in turn this will inform and support the future of Cornwall. 


Cornwall is a unique county, we are 125 miles long with a population which is very diverse in terms of the location spread. Cornwall also has the most agricultural land of any UK county as well as the most hospital wards outside of London and Manchester. With 800 different data sources, there is a wealth of information which is a real gold mine. Public health alone has 78 data sources with 50 lines each, split by geography. All of that information comes into the council in various different formats and working with Headforwards, the council has big plans to transform the way this data is used. You can play a pivotal role in the future of Cornwall and its people by working to make this data open and available in a secure way, to the people who can use it to make a difference. 


You will support the initial integration of identified data sets ranging from internal sources systems to external data feeds into a cloud based relational enterprise data warehouse. Working with the business to identify and produce management information from this centralised data store using a range of data visualisation tools. The delivery is primarily supported by a Microsoft first approach. Considerations must be given to the initiation, formation and standardisation of best practices to support ETL procedures, data quality measurement, data retention, master data management and role management.


Why work for Headforwards?

We are a software development company with just over 100 people from 18 different countries and we like to have fun at work. We are agile with a very laid back feel, a relatively flat structure and small self-organising teams of 2-7 people. There's no pressure to work extra hours to churn out more and more code. At Headforwards, our culture and environment is dedicated to making people happy at work. We have lots of social activities and monthly learning sessions, talks and cross company communities of practice for various languages, tools and frameworks. This is a place where you can make a difference, work in a small team start-up feel but benefit from the support of a larger community of developers and like-minded people. We’ve been using snowflake but we are now using Volt 2.0 modelling and mapping technology which is only 2 weeks old as we write this! We work in teams dedicated to various clients and we work on global projects with cutting edge technologies, tools and techniques. We live in beautiful Cornwall, our offices are 5 miles from the beach. We want to make sure our people have a good work life balance so that they can enjoy all that Cornwall has to offer :) 


Requirements

More detail on the job

  • Supporting the delivery of a BI Architecture through test and learn to ensure the proposed technical and data architecture fulfils business needs
  • Creating and documenting ETL and DWH best practices within the DWH. Installing those best practices in the delivery roles e.g. IS technicians, data owners, data analysts, SQL users etc. through training and coaching, via side by side programming
  • Designing Data Quality, Data Retention and Master Data Management processes within the sprints
  • Support the creation of the centralised data dictionary
  • Supporting the creation of user groups and their governance, to ensure joiners, users and leavers are managed with an appropriate process and level of access
  • Ensuring the BI platform the ability to manage both anonymised and sensitive data in a controlled manner that supports GDPR
  • Setting best practices for the use and management of both structured and unstructured data.
  • Evolving the requirements specification template, through its use. To streamline the on-boarding of future data sources into the DWH, including the review of a readiness checklist to support data source for use in prioritisation 
  • Using the sprint to create a T-shirt sizing cost model for future data sources & BI requests
  • Whilst delivering the pilot consider how alternate data types and source will fit the model designed
  • Supporting the design and socialisation of Azure security models, to gain stakeholder comfort that all controls are in place to ensure no data leakage or vulnerability. This will cover both the data warehouse infrastructure and any data visualisation /strategic tools
  • The Digital Cornwall Programme will deliver a single strategic solution and will maximise usage of a data warehouse. It will create a sustainable BI & Data governance models through interaction with DC BI project board and BI Governance Group via submitted papers and project delivery support. This developer role will need to conform to the principles that assure these goals.

Essential Experience

  • Microsoft BI Tools including Azure Data Factory, Azure Data Storage, Azure DWH, SSIS, SSRS, SSAS, MDM, DQS, TSQL
  • Data structure 
  • Dimensional modelling
  • Data load processes
  • ETL error handing 
  • Team player
  • Softer skills to allow knowledge transfer to other team members and stakeholders
  • Ability to translate technical information for non-technical audiences

The closing date for this role is 31st August 2019. We recruit on a rolling basis and fill our vacancies as soon as we find people who fit our culture and meet the skills requirements. This means that whilst we have a closing date on all of our roles, we may offer the role to someone before the end date, so we recommend that you apply as soon as possible. 


For this role we can only accept applications from individuals who already have the right to work in the UK.  If you are in the UK on a Tier 2 General visa then we are able to take over the sponsorship of this.