Data Warehouse Engineer London, England
Ridge Surveyors Limited
Full Time
London, England
32000 - 37000 GBP ANNUAL Today
Job description
Overview:
Ridge is an award-winning multidisciplinary construction consultancy, employing over 1000 people across 12 locations throughout the UK.
The Technology team at Ridge is growing its capacity to meet BI demand across the company as part of the continued growth and success. We are looking for a talented Data Warehouse Engineer to sit within the newly formed Data and Analytics team specialising in data warehouse development and database administration. 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 our expansion. The Data Warehouse Engineer will be responsible for primarily enabling dashboard creation through development of the Data Warehouse, with a secondary objective of creation of dashboards. Being at the beginning of the Data and Analytics team’s growth, your output will form a central part of the development of data usage at Ridge and will support all colleagues in changing the way data is used by all teams.
Your work will help Ridge leverage data and identify opportunities for improvement, spot trends, as well as recognise potential issues and offer solutions, providing valuable insight into the driving forces behind every aspect of the business. In addition, you will help/advise in identifying ways we can innovate new services or insight to our clients.
The role will work closely and in collaboration with the business stakeholders, users, project managers and Business Analysts, to support the company’s technology services, with a focus on supporting BI and analytics solutions through the development and management of our data warehouse, turning data into knowledge.
The role will be responsible for the development and maintenance of data warehouses & associated ELT processes within Ridge. As such, the role will be a mixture of development / project work & ongoing support tickets. The role will also play a key part in helping to define the data architecture and potential systems to support the ongoing business agenda.
In addition, the role will help support data quality, analytics and BI solutions across the wider estate alongside BI Analysts. Working closely with BA’s and in some cases directly with business stakeholders, understanding business requirements and use cases, translating these into solutions through the configuration and development of solutions to automate and integrate data and information.
Role and Responsibilities:
Ridge has climbed to 14th position in the Building Magazine Top 150 Consultants, whilst continuing to rise within the Top 50 Architects, Engineers, Project Managers, and Surveyors lists – with us in the top 10 surveyors in the country. Showcasing our continued success!
Location: Leeds / London / Oxford / Birmingham / Manchester
Ridge is an award-winning multidisciplinary construction consultancy, employing over 1000 people across 12 locations throughout the UK.
The Technology team at Ridge is growing its capacity to meet BI demand across the company as part of the continued growth and success. We are looking for a talented Data Warehouse Engineer to sit within the newly formed Data and Analytics team specialising in data warehouse development and database administration. 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 our expansion. The Data Warehouse Engineer will be responsible for primarily enabling dashboard creation through development of the Data Warehouse, with a secondary objective of creation of dashboards. Being at the beginning of the Data and Analytics team’s growth, your output will form a central part of the development of data usage at Ridge and will support all colleagues in changing the way data is used by all teams.
Your work will help Ridge leverage data and identify opportunities for improvement, spot trends, as well as recognise potential issues and offer solutions, providing valuable insight into the driving forces behind every aspect of the business. In addition, you will help/advise in identifying ways we can innovate new services or insight to our clients.
The role will work closely and in collaboration with the business stakeholders, users, project managers and Business Analysts, to support the company’s technology services, with a focus on supporting BI and analytics solutions through the development and management of our data warehouse, turning data into knowledge.
The role will be responsible for the development and maintenance of data warehouses & associated ELT processes within Ridge. As such, the role will be a mixture of development / project work & ongoing support tickets. The role will also play a key part in helping to define the data architecture and potential systems to support the ongoing business agenda.
In addition, the role will help support data quality, analytics and BI solutions across the wider estate alongside BI Analysts. Working closely with BA’s and in some cases directly with business stakeholders, understanding business requirements and use cases, translating these into solutions through the configuration and development of solutions to automate and integrate data and information.
- Designing data warehouses, including relational & multidimensional database design and data architecture
- Working with colleagues in the Data and Analytics team, and wider Technology team, to develop and grow the service and products for the company
- Strong working knowledge of SQL (preferably including experience in MS Dataverse)
- Working knowledge of cloud computing (preferably Azure)
- Experience and understanding of data warehouse solutions (Snowflake preferable)
- Ability to write data extraction and loading routines to support data migrations during system implementations
- Developing and maintaining analytics solutions and perform data analysis
- Creation of technical documentation, capturing development, processes & DB changes
- Troubleshooting and resolving data-related problems
- Staging & shaping data from multiple data sources into reporting and analytical solutions and integrations
- Collaborate with other stakeholders/end users in the software development lifecycle
- Understanding of DevOps practices, Agile project methodologies, and application lifecycle management
- Identifying and suggesting improvements in delivery of BI to the company
- Working closely with the IT department to ensure that the data collection and storage are appropriate and suitable for BI purposes
- 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
- Degree in STEM subject (preferably Comp Sci or Equivalent)
- Knowledge/experience of Data Warehouse schema design, data modelling & data warehouse systems (Snowflake preferable)
- Strong experience in SQL
- Practical experience in ELT processes & tools (Kleene advantageous)
- Analytical with a creative mind and attention to detail
- You work effectively with others by being co-operative, inclusive, supportive and understanding towards your colleagues and other stakeholders
- An expert 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
- Good communication with non-technical stakeholders to understand what is required and discuss technical work in an understandable way
- Critically assess data outputs within its context
- Focus on detail in tasks to complete, while maintaining an understanding of where the value of this sits in a larger project
- Comfortable with independent work, and collaborating within the team
- Initiative to proactively tackle barriers, explore new solutions, and expand the range of work currently undertaken by the team
- Experience on data visualisation software preferable, ideally Power BI
What We Can Offer
This role offers you the chance to progress your career at a forward thinking, friendly company. Along with providing you with an opportunity to learn and develop skills and qualifications as part of a dynamic team, we also offer;
- Ability to contribute to the growth and development of the team, adding value to our growing business
- 25 days holiday - entitlements increase by 1 day per annum after 3, 5 and 8 years
- Private Healthcare
- Life Assurance
- Standard 6% Ridge Contribution - rising to 7% after 5 years, and 8% after 10 years
- Highly competitive salary
- Salary Sacrifice - Cycle to Work Scheme
- Buying and Selling Annual Leave
- Gym Membership Scheme
- Company car leasing scheme
When you join Ridge and Partners, you will be surrounded by professional people who are experts in their field. You will work with and be surrounded by mentors and a support network to help you to embrace new challenges, grow, develop your skills and experience to progress with your career.
Ridge has climbed to 14th position in the Building Magazine Top 150 Consultants, whilst continuing to rise within the Top 50 Architects, Engineers, Project Managers, and Surveyors lists – with us in the top 10 surveyors in the country. Showcasing our continued success!
Ridge Surveyors Limited
www.ridge.co.uk
Oxford, United Kingdom
$1 to $5 million (USD)
1 to 50 Employees
Company - Private
Construction
