BI Engineer

at  Ridge Surveyors Limited

ABOUT US

Ridge is an award-winning multidisciplinary built environment consultancy, employing over 1100 people across 11 locations throughout the UK. Our vision is to help our clients to create better places for people to live, learn and work.
At Ridge, our people are the foundation of our success, and our greatest asset. They drive our vision and embody our values. Our people are what separate us from the competition and we never lose sight of this. We offer not just a job, but a journey. We believe in commitment, and the value of a stable, long-term career path. We challenge our people to be the best they can be and help them grow with training and support.
Due to the continued growth and associated success of Ridge, the Technology team is growing in capacity to meet demand & service across the company. We are looking for a talented BI Engineer to sit within the Ridge Technology team. You would join at an exciting time of growth in the wider company especially in the Technology team, where investment is being made to match the needs due to the success of the business.

ABOUT THE ROLE

The Data and Analytics team at Ridge was formed 12 months ago to meet growing demand for professionally managed data. We’ve created solid foundations of data management by setting up our data architecture and delivering value and insight, and have established strong relationships across the business, building awareness and trust in data across Ridge.
We’re now at a stage where we want to bring in a BI Engineer to expand our capacity and build the future of our team. As the business grows in data maturity through our engagement, we’re being presented with increasing number of requests, and need to balance that with the need to review, redesign and improve the maturity of our data architecture. After completing our set-up work and delivering quick wins earlier in 2024, we need a BI Engineer to support our work in enabling us to both continue delivering valuable work and ensuring that the foundations of our output grow sustainably, matching the high expectations of data in the business we’ve established. Additionally, to support the delivery of this direction of travel, we’re investing in growing the team’s skills and experience; partly through bringing in a BI Engineer, but also with a consistent focus on offering professional development, opportunities, and freedom to take on responsibility. We recognise that Ridge’s success has come through supporting our great people, and this is reflected in our Data and Analytics team.
Role and Responsibilities:

WHAT YOU NEED TO DO TO BE EFFECTIVE IN THIS ROLE

• Experience with data warehouse modelling, designed to accommodate future growth
• Developing schemas
• Creation of technical documentation, capturing development, processes & DW changes
• Expanding our data warehouse, incorporating new data sources, and building in best-practice warehouse design
• Working closely with the IT department to ensure that the data collection and storage are appropriate and suitable for BI purposes
• Staging & shaping data from multiple data sources into reporting and analytical solutions and integrations
• Developing and maintaining analytics solutions and perform data analysis
• Troubleshooting and resolving data-related problems
• Collaborating with colleagues in the Data and Analytics team to deliver dashboard reports
• Engaging with clients (usually but not limited to internal colleagues) to understand their needs, and designing and creating a suitable dashboard report
• Identifying and suggesting improvements in delivery of BI to the company
• Working with all internal departments to identify suitable metrics specific to their departmental operations and wider BI requests
• Identifying new sources of data to be used to grow BI capability
• Identifying new uses of existing data to provide insight to the company
  Experience and Skills Required:

THE SKILLS AND EXPERIENCE YOU NEED TO HAVE FOR THIS ROLE

• Knowledge/experience of Data Warehouse schema design, data modelling & data warehouse systems (Snowflake preferable but not essential)
• Experience on data visualisation software preferable (Power BI preferable but not essential)
• Strong working knowledge of SQL
• Practical experience in ELT processes & tools
• Analytical with a creative mind and attention to detail
• A good communicator, you listen carefully and use positive language to clearly present information, ideas and views, verbally, in writing and by using technology
• Experience in interpreting data to draw out insights
• Comfortable with independent work, and collaborating within the team
• Good communication with non-technical stakeholders to understand what is required and discuss technical work in an understandable way
• You work effectively with others by being co-operative, inclusive, supportive and understanding towards your colleagues and other stakeholders