Lead Business Intelligence Developer

Salary: Full time starting salary is normally in the range £45,585 to £54,395 with potential progression once in post to £61,198. Grade 8 

Closes: 25th  February 2023

The University has a requirement for a Lead Business Intelligence (BI) Developer who has significant skills and experience in Cloud data warehousing and systems analysis/design.

We are looking for a Data Warehouse Engineer with extensive experience of Cloud based platforms. The primary focus of this role will be the development of a Snowflake data warehouse environment and will include using multiple ETL tools and Tableau/Power BI for reporting and data visualisations.

As the ideal candidate you will be adept at working with large data sets to develop advanced, scalable Data Warehouse solutions from end-to-end. The University is still at the early stages of building a Snowflake Cloud based Data Warehouse hosted on MS Azure. The basic architecture has been established and various system components talk to each other but there is still a lot to do and this will be a huge opportunity for the right person to take ownership of the Data Platform and take it to the next level. You will be a hands-on Data Engineer who thrives on working in a varied and challenging environment and will use your technical knowledge to advice on how they are ingesting data, what they are ingesting and how they are using insights to drive key business decision making. 

Required Knowledge, Skills, Qualifications, Experience

• Educated to degree level or equivalent qualification plus substantial work experience in a relevant technical/scientific and/or management/supervisory role in a specialist area. A higher degree may also be held. Where no equivalent qualification is held a proven track record of extensive and substantial work experience in a series of progressively more demanding and relevant roles will be required.
• Proven technical specialist knowledge and understanding in a relevant technical area (specialists will require advanced technical expertise).
• Snowflake certified with relevant hands on experience.
• ETL tools – how to build data pipelines using cloud ETL Tools (Azure Data Factory an advantage) with advanced data ingestion techniques.
• Tableau/ Power BI experience of integration with a cloud warehouse.
• Data architecture and modelling experience (e.g. facts and dimensions, materialized views etc).
• Experience of modelling in Data build tool (DBT).
• Experience with the Python programming language or similar. 
• Experience with source control systems such as GIT. 
• Experience of working agile teams using methodologies such as Scrum or Kanban. 
• Experience of supporting junior developers.
• Experience of RESTful and GraphQL API integration.
• Experience of developing and using continuous integration and development. pipelines, with tools such as Azure DevOps, TeamCity or Jenkins.
• Data Warehouse Design - a demonstrable and broad understanding of best practices, common issues and how to solve them.
• Advanced skills in SQL.
• API experience with Change data capture capabilities in Snowflake.
• Ability to present findings in a structured, clear manner with actionable insights.
• Excellent oral and written communication skills for translating data insights into concise executive summaries and presentations.

Informal enquiries to Julian Kobylarz, email: [email protected]

To download the full job description and details of this position and submit an electronic application online please click on the above ‘Apply’ button.

Valuing excellence, sustaining investment
We value diversity and inclusion at the University of Birmingham & welcome applications from all sections of the community & are open to discussions around all forms of flexible working