Junior BI DBA/SQL Developer

Salary: £28,000 - £30,000

Term: Fixed term contract - Permanent 

Location: Hybrid/ On-site

Close date: 16/12/2022

Apply online

If you love data and you want a really interesting challenge then we have something pretty unique as we embark on this exciting project.

We are working in partnership with our client to enhance and improve the way that they are able to respond to and deal with customer enquiries and problems. You’ll be working in an agile team, and we will consider both remote and local applicants as long as the successful candidate is willing to travel to the office once a month. Your involvement in this team will generate more efficient process and improve the experience for our client’s customers and employees.

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.

This is a fantastic opportunity for a Junior Developer to develop their skills and gain official certifications, as well as valuable industry experience for 12-18 months. After this period there will then be the opportunity to transition over to our client.

This is a Hybrid role with regular on-site visits required, therefore this person must be located within Cornwall or Devon.

Why work for Headforwards?

Our engineers work within small, agile, self-managed teams that emphasise best practice and believe quality is everyone’s responsibility. We favour collaborative development and leverage open-source tools and communities, whilst making sure to share their know-how back up stream. You’ll get to contribute and collaborate with other engineers on technical and architectural decisions. Enjoy end-to-end ownership from concept to deployment, including building and operating infrastructure, toolset and deployment pipelines. Develop your skills, work on cool projects with the latest tech, all whilst working with a talented, diverse and friendly group of people.

Company benefits:

  • Flexible hours and remote/hybrid working available
  • 25 days holiday per year, increasing each year up to 30 days (plus bank holidays)
  • Medical cashback scheme (which also offers discounts at gyms, cinemas, supermarkets etc)
  • Linkedin Learning licences, Pluralsight Learning access, and MS Certification opportunities
  • Company pension
  • Enhanced sick/ Maternity/ Paternity pay
  • And much more…

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

Essential skills/ experience

This is a junior position so we are looking for approx. 1 year experience (either commercial or private projects)

  • Knowledge of data load processes
  • Knowledge of data structures

Desirable skills/ experience

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

Unfortunately, for this particular vacancy, we are not able to offer visa sponsorship.

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.

No recruitment agencies please.

Headforwards™ is a Registered Trade Mark of Headforwards Solutions Ltd.
Registered Address: FibreHub, Trevenson Lane, Pool, Redruth, Cornwall, TR15 3GF, UK
Registered in England and Wales: 07576641 | VAT Registration Number: GB111515770