- Junior
- Oficina en Sheffield
Junior Data Analyst (Energy)
Sheffield, South Yorkshire, United Kingdom
Salary: £28,000 - £32000
This is a hugely exciting entry-level opportunity to join as the fourth member of UniHomes’ newly formed Data & Analytics team. As Junior Energy Analyst you’ll become an expert on the Energy (Gas & Electric) usage of our customer base. You’ll work with our Energy Analyst and the Finance team to review our supplier invoices each month and ensure we have strong understanding of any discrepancies from our forecasts. You’ll assist with wider projects and ad hoc reporting for Energy data - applying skills in Python, Excel, SQL, and Tableau. It’s a very supportive, welcoming environment with tons of opportunities to learn and develop in your career.
Key responsibilities:
- Summarise the invoice and how it compares to our Forecasts and proactively provide reporting packs to Finance that enable them to understand any variances from the forecast.
- Complete additional in-depth analysis as needed to provide further understanding.
- Contribute to and lead regular meetings with Ops and other teams to discuss monthly KPIs related to invoicing and related actions for their teams.
- Proactively and continuously work to improve these processes – using your skillset in Python, SQL, Excel, and Tableau amongst other tools - to enable our Finance team to query and pay invoices each month most effectively.
- Building a Tableau dashboard to show how energy usage has varied in the last year from forecast and how this correlates with the weather.
- Calculating individual property usage and advising different teams including Legal, Operations and Sales to assist with specific customer or supplier queries.
- Updating SQL files within our data pipelines (DBT) to reflect the invoicing status and adding additional details to the final table outputs.
Skills and experience:
- Strong communication skills. Ask effective questions to understand the wider context and provide concise, insightful recommendations.
- Strong aptitude for analysing large highly complex data sets with high attention to detail to analyse row-level details, identify trends and segment data for greater clarity.
- Demonstrable experience of proactively building out automations and other processes to help increase efficiency and improve the use of Data.
- High numeracy - the role involves lots of Maths!
- Strong capability with Microsoft Excel – for example using pivot tables and multi-step formulas including IF, XLOOKUP, AVERAGEIFS. Ability to quickly review data in Excel and use visualisations and pivot tables to get an overview.
- Experience with Python. Demonstrable examples of applying Python to collate data, cleanse data, analyse and identify trends, write custom functions, and visualise data.
Desirable:
- Experience with SQL. Demonstrating competence with building queries across multiple tables using CTEs, UNIONs, LEFT JOINS, CASE statements etc.
- Experience working with BI tools (we use Tableau).
- Experience working with Finance teams and invoice management.
- Experiencing working with Energy data.
- Experience working with Salesforce.
- Experience working with DBT.
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.
