Data Analyst Sheffield City Centre, UK (fully office-based) Salary: £DOE This is a hugely exciting opportunity to join as the third member of UniHomes’ newly formed Data & Analytics team and play a pivotal role in establishing our centralised database and BI reporting. You’ll support stakeholders across our Sales, Marketing and Product teams with your commercially astute analysis, recommendations, and project management. This position is ideal for someone who enjoys working with multiple stakeholders in a dynamic office environment and is eager to help us establish scalable and automated data pipelines and BI reporting. It’s a very supportive, welcoming environment with tons of opportunities to learn and develop in your career. Key responsibilities: Complete a variety of project-based and ad hoc work. These projects and priorities will change over time, but may include these or similar: Build dashboards to enable our Marketing team to monitor supply and demand for student properties in different cities across the UK, and to effectively manage their campaigns across multiple platforms. Review the engagement of our agent clients with our client Analytics offering and make recommendations for how best we develop this product. Build a single customer view to enable our Marketing team to design campaigns for customers across our brands and across the customer lifecycle with greater operational efficiency. Support our Head of Sales in setting targets and phasing these over the year as student properties become available at different times of the year in each city. Support our Product team to design and implement A/B testing on the website then review the statistical significance of the outcome and make recommendations for next steps. Additionally, you will play a key role in establishing our centralised database and BI reporting: Write SQL files to transform data in our raw database into highly structured, business-ready tables that are well documented and peer reviewed. Take a very detail-oriented approach in identifying the correct fields and joins to use to match existing business reporting when establishing underlying tables. Consider the long-term needs of the business and various data structure options in determining new models as we iteratively build out the database. Build intuitive BI dashboards in Tableau, working closely with stakeholders to iteratively build out insights that support their ways of working. Enable individuals across the business to confidently use Tableau (or other relevant tools) to pull the insights they need, proactively arranging training and offering support. Skills and experience: Essential: High commercial acumen. A good understanding of the wider business model in your current and previous employer(s) and the relevance of that to your Analyst role, and in particular the key levers for the Sales, Marketing and Product teams. Demonstrable experience of delivering high impact projects and proactively providing commercially insightful recommendations to stakeholders. Significant experience with SQL. Demonstrating competence with building long queries across multiple tables using CTEs, UNIONs, LEFT JOINS, CASE statements, window functions etc. Significant experience with BI visualisation (we use Tableau). Building intuitive dashboards and ad-hoc reports and using more advanced reporting capabilities such as LOD functions, layered filtering. Exceptional communication skills. Build rapport with others to enable cross-functional initiatives and present confidently and with clarity. Desirable: Experience working with our other technical platforms: DBT (Data Build Tool), Excel, GA4 and Salesforce CRM (building reports, dashboards and working with operational teams on processes). Experience reporting on Marketing spend performance across various channels (for example Facebook and Snapchat). Experience setting up and managing centralised database reporting and BI reporting, and any experience with managing permissions and processes around these. Experience in the Utilities or Prop Tech sector. About us: UniHomes has been named the fastest-growing technology company in Yorkshire and the Northeast in the 2023 Deloitte UK Technology Fast 50. We are also incredibly proud to have been officially certified as a Great Place to Work® (GPTW®). Our industry-leading property search portal and utility management service enables our established and ever-increasing network of letting agent partners, to offer hassle-free all-inclusive accommodation to our growing and strong community of university students, who are actively seeking their perfect shared house. We are taking the market by storm, currently in over 60 university cities and towns across the UK, and we have huge ambitions for 2025. Founded by three Sheffield property entrepreneurs in 2015, we have experienced remarkable growth and now have a team of almost one hundred at our Sheffield City Centre office. With recent minority investment from LDC we are scaling up our teams ready to conquer new horizons. There couldn’t be a more exciting time to join us. We are a team driven and united by our core values: Lead the Way In it Together Customers Matter Keep it Simple Rise Above Challenges Make it Happen What do you get when you work here? With people and culture at the heart of our organisation, we are continually enhancing our employee offer and culture. We are incredibly proud to have been officially certified as a Great Place to Work® (GPTW®) and an accredited Living Wage employer - all our employees earn a fair living wage above the government minimum wage. Working in our stunning new office at New Era Square in the centre of Sheffield, you will get complimentary breakfast, hot & cold drinks, snacks, pool table, holidays, length of service days, voluntary day, enhanced pension scheme, pension salary sacrifice scheme, healthcare scheme, Employee Assistant Programme, sick pay, enhanced maternity & paternity pay, career progression, a commitment to personal and professional development, employee of the month award, refer a friend scheme, staff discounts, mental health and financial support, and company social events. At UniHomes we are committed to fostering an inclusive and diverse workplace where everyone can thrive and which values individuals for their unique perspectives. We welcome candidates from all backgrounds, regardless of age, disability, gender reassignment, marriage and civil partnership, pregnancy and maternity, race, religion or belief, sex, or sexual orientation. Please let us know if you require any reasonable adjustments to make the recruitment process more accessible to you. We do not accept CV submissions from recruitment agencies. Direct applications from individual candidates are encouraged. Thank you for your understanding. Powered by JazzHR