Data Analyst

Overview

Our small Canadian-born business was founded in 1978 and has become a global organization that now spans 120 locations across 20 countries. Our expansion has been rapid, but what matters most is the common belief that drives all 5,000 of our people to be a different type of real estate organization. We believe that the places in which we live, work and play have the power to make us happier and healthier, and we are united by a shared sense of purpose, to have a positive impact on people’s lives. In short, we are a global commercial real estate advisory firm with a simple aim: for real estate to play a leading role in creating vibrant buildings, cities and places that deliver long-lasting social value and economic impact.  

Why Work for Us:

We believe that our industry is changing, and we want our business to be a melting pot of curious minds, passionate hearts and strategic intelligence. Your gender, religion and race are all highly respected, but are less important to us than your ability to step up and change the game. We provide you with a place where you can do just that, with like-minded people. Collaboration is embedded in the way we work – our people have the autonomy to collaborate on client relationships, engage teams across the business, lead operations, work collectively on projects, participate in strategy and are ultimately responsible for our growth. Our distinctive Principal-led, privately-owned model puts us in the enviable position of being able to offer every employee the opportunity to own a share of our business and inspires and allows anyone to become a Principal. This role carries voting rights, so our people have a very real say in the future direction and operation of our business. This means that we are able to attract, engage and retain the best talent from the industry.  

As a Data Analyst for the Professional Advisory Business Group you will report into the group’s Chief Operating Officer and Managing Director. You will work closely with the Market Intelligence, Valuation, Healthcare, Student Accommodation, Leisure and Hotels team that is spread around the UK with a focus on data analysis, extraction, visualisation and monitoring to provide innovative solutions when presented with large data sets.

Leveraging your understanding and passion for data analytics, the successful candidate will take proactive ownership of key data sets from across the Professional Advisory Business Group and have a positive impact on internal workflow, process optimisation and real estate market knowledge.

Responsibilities

• Compile, analyse and take ownership of multiple internal data sets within the Professional Advisory Business Group and wider company using ETL processes and a strong understanding of SQL platforms.
• Design and build comprehensive models drawing from multiple data sets using excel, SAAS platforms and API’s.
• Research, compile and extract inflowing real estate market data, utilising a strong knowledge of visualisation tools.
• Produce deep dive data analysis into group KPI’s that positively influence the trajectory of the teams’ roadmap.
• Identify and close data gaps that will have a positive impact on workflow and process optimisation. 
• You can collaborate effectively with cross-functional teams, translating requirements into strong technical solutions.
• You can communicate concepts, ideas and solutions to stakeholders across seniority levels in person within the business group and the wider company.
• Work collaboratively with external stakeholders to reach effective solutions that will benefit the business group and the wider company.

Qualifications

• Degree qualified with strong quantitative/analytical ability and attention to detail.
• Excellent excel modelling skills. 
• Strong understanding and use of data visualisation tools. Previous use of Power BI is preferred.
• Ability to interpret and draw conclusions from data sets and present findings to stakeholders in an accessible way.
• Experience with extracting/transform/load (ETL) processes, SAAS platforms and API’s.
• Strong understanding and utilisation of SQL databases.
• Foundation knowledge of Python and/or R.
• Take a proactive approach to problem solving, taking full ownership across the lifespan of a project.
• Excellent communication skills with the ability to clearly explain concepts concisely to stakeholders within the business group and wider company.
• Ability to prioritise tasks and manage time effectively.

Equal Opportunities

At Avison Young, we’ve always put people at the heart of what we do.In the last few years, we’ve increased the diversity at our board, leadership and Principal levels. Avison Young stands out for our commitment to empowering women. In addition to increasing the number of women on our board and in our leadership ranks, our internal Women’s Network of more than 500 members come together for networking and learning, and advise the business on strategies for promoting access, opportunity and inclusion in our industry.Our global DEI steering committee shapes our strategy to continue to increase industry access for underrepresented groups and accelerating initiatives led by our employee resource groups, including our Women’s Network, Black Professionals and LGBTQ+ groups. In addition to leading global initiatives, the steering committee’s work examines our policies and practices, creating accountability for results and communicating progress to our executive leadership, our clients and our communities.Our culture is underpinned by our approach to diversity, inclusion, and well-being. We are committed to building an inclusive culture that:

• empowers all our employees to thrive,
• reflects all backgrounds and talents,
• allows individuals to be successful and feel a sense of belonging,
• and foster a workplace that is supported, inclusive and has a strong sense of community between colleagues.

Avison Young is an equal opportunity employer and is committed to treating all its employees and job applicants equitably. This includes implementing deliberate strategies that advance underrepresented communities in commercial real estate careers.As a Disability Confident Employer, we are committed to removing any obstacles to inclusion. If you need any adjustments to support your application or any part of the recruitment process, such as information in alternative formats or special requirements to access our buildings, or you are eligible under the Disability Confident Scheme please contact us at careers.uk@avisonyoung.com and we will do everything we can to help.

We are committed to inclusion in our hiring processes, and we want to give everyone a chance to show what they can bring to our organisation. If you are not sure that you have all the skills in the person specification, please still apply. We value passion and potential in our employees, so it would be great to hear from you and why you would suit this position.Some of our roles may be remote and some roles may be specific to our offices, but you will need to confirm you have the right to work in the UK.