We are recruiting a new Business Intelligence Engineer position in the team to accommodate the delivery of our expanding workload in support of the broader growth of the business. Linked to the steady growth of the business, we are evolving our data architecture to offer a modern data service with new data sources coming online and redeveloping our data warehouse to align with our projected growth. The current team is small so the role will have exposure to colleagues across Ridge, including external clients, representing the Data and Analytics team. Therefore, the role has a broad scope of responsibility, requiring the individual to own projects themselves and delivering end-to-end solutions, with support and discussion shared across the team. Responsibilities: Integrating new data sources into the data warehouse, and building in best-practice warehouse design Staging & shaping data from multiple data sources into reporting and analytical schemas Experience with data warehouse modelling, designed to accommodate future growth Creation of technical documentation, capturing development, processes & DW changes Developing and testing data pipelines Collaborating with colleagues in the Data and Analytics team to deliver dashboard reports Engaging with clients (internal colleagues and external clients) to elicit requirements, understand how we can meet those needs with data, and translating their business needs into a technical solution Ongoing support of data analytics platforms Supporting the growth in the business’ data maturity, working on projects and requests in partnership in the Data and Analytics team, wider Technology team, and Ridge Requirements: Passion for data Proficiency in SQL Experience in data visualisation highly advantageous Experience managing personal workload and independently owning projects from start to completion Experience working efficiently through collaboratively discussing challenges and solutions with colleagues, making full use of the various skills and experience Confidence to autonomously solve problems, and awareness to highlight changes made and raise issues for discussion in the team Interest in enabling the business to improve how it operates through a professional application of data Beneficial but not essential to have experience in governance and security, and python Experience in MS Fabric is noteworthy but not expected About us We are Ridge, a Built Environment Consultancy. We help our clients transform the quality and sustainability of the built environment. Our 1,000 people bring a vast range of skills, delivering a professional mindset, gritty discipline and a genuine passion to every one of the thousands of projects they undertake each year. They’re the foundation of our success - they drive our vision, embody our values and separate us from the competition. Come and join us if you’re hungry to be part of an exceptional team - if you put quality first - if you’re motivated by ingenuity and if you’re always aspiring to be the very best. Your benefits The benefits package we have put together for you supports every aspect of your life. Annual leave A healthy holiday allowance that starts at 25 days pa, plus the option to buy, carry over or sell. Community spirit You can take three volunteering days each year to spend time on causes close to your heart. Mental health Mental Health First Aiders are here to support you, backed up by Unum’s Help@hand app. Financial benefits A path to peace of mind: life assurance, pension scheme and income protection. Physical wellbeing Your health is a priority for us too, so we offer medical insurance, private GP access and discounted gym membership. Flexible working Our flexible approach to hybrid working is there to suit you, your family and your team. Career development A pathway at Ridge that’s focused on your professional, personal or educational aspirations. Extra benefits Performance bonus, car allowance and more based on your role - and progression. Previous Next We believe that everyone performs their best when they feel like they belong and can be their true selves at work. As an equal opportunities’ employer, we will support you to ensure you have everything you need to be successful and achieve your best in your career at Ridge. If you’d like to discuss accessibility, accommodations or adjustments during your application and selection process, please contact us at workwithus@ridge.co.uk and we will work with you to ensure you feel included and supported. A polite note to Recruitment Agencies We enjoy great relationships with our agency partners within our framework, and fully believe in the value of a blended approach to finding the best talent. However, we are recruiting for this role directly and aren’t seeking support from agency partners at this time – any unsolicited CV introductions won’t be honoured, and we won’t grant candidate ownerships on any introduction that you make for roles that haven’t been briefed and released to you by our Talent Acquisition team. We are committed to nurturing strong partnerships within our agency framework, but there are occasions where we looking to enlist the help of others. If you would be interested in working with us in the future, please send a message to workwithus@ridge.co.uk, and we’ll reach out to you should there be an opportunity. A polite note to recruitment agencies We are recruiting for this role directly and aren’t seeking support from our agency partners. Any unsolicited CV introductions won’t be honoured, and we won’t grant candidate ownership on any introductions you make for roles that haven’t been briefed and released to you by our Talent Acquisition team. If you are a recruitment agency who doesn’t currently work with Ridge but would like to, please send a message to workwithus@ridge.co.uk, and we’ll reach out to you should there be an opportunity. Note to recruitment agencies We are recruiting for this role directly and aren’t seeking support from our agency partners. Any unsolicited CV introductions won’t be honoured, and we won’t grant candidate ownership on any introductions you make for roles that haven’t been briefed and released to you by our Talent Acquisition team. If you are a recruitment agency who doesn’t currently work with Ridge but would like to, please send a message to workwithus@ridge.co.uk, and we’ll reach out to you should there be an opportunity. Documents