Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Analyse energy data and support invoicing processes using Python, SQL, and Excel.
- Company: Join the fastest-growing tech company in Yorkshire, UniHomes!
- Benefits: Enjoy a competitive salary, flexible work environment, and great perks like free breakfast and snacks.
- Why this job: Kickstart your career in data analytics and make a real impact in the energy sector.
- Qualifications: Strong analytical skills, experience with Python, and a passion for data.
- Other info: Be part of a supportive team culture with excellent growth opportunities.
The predicted salary is between 24000 - 28000 £ per year.
# Junior Data Analyst (Energy)### Data and Analytics## 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:**Manage monthly reporting on our supplier invoices:* 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.Contribute to wider projects and ad hoc reporting for Energy data. This will vary but examples of what this might include:* 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:**Essential:* 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.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**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.**Salary Salary: £28,000 – £32,000Type Full TimeLocation Sheffield This site requires JavaScript to be enabled. JavaScript is used on this site to improve user experience and enable functionality without JavaScript this site wont work as required. . Once JavaScript is enabled, this message will be removed. | #J-18808-Ljbffr
Junior Data Analyst (Energy) employer: UniHomes.co.uk
Contact Detail:
UniHomes.co.uk Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Junior Data Analyst (Energy)
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend local meetups, or join online forums. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Prepare for interviews by practising common questions and showcasing your skills. Use examples from your experience with Python, SQL, or Excel to demonstrate your analytical prowess. Remember, confidence is key!
✨Tip Number 3
Don’t just apply and forget! Follow up on your applications after a week or so. A quick email expressing your continued interest can set you apart from other candidates.
✨Tip Number 4
Make sure to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining our awesome team at UniHomes.
We think you need these skills to ace Junior Data Analyst (Energy)
Some tips for your application 🫡
Tailor Your Application: Make sure to customise your application for the Junior Data Analyst role. Highlight your skills in Python, SQL, Excel, and Tableau, and show how they relate to the responsibilities mentioned in the job description. We want to see how you can contribute to our team!
Show Off Your Communication Skills: Since strong communication is key for this role, don’t shy away from showcasing your ability to ask effective questions and provide insightful recommendations. Use clear and concise language in your application to demonstrate this skill right from the start.
Highlight Your Analytical Prowess: We’re looking for someone who can analyse complex data sets with attention to detail. Include examples of past experiences where you've successfully tackled data analysis tasks, especially if they involved energy data or finance-related projects.
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for this exciting opportunity. Plus, it shows you’re keen on joining our awesome team at UniHomes!
How to prepare for a job interview at UniHomes.co.uk
✨Know Your Data Tools
Make sure you brush up on your skills with Python, SQL, Excel, and Tableau before the interview. Be ready to discuss specific projects where you've used these tools, as this will show your practical experience and understanding of data analysis.
✨Understand the Energy Sector
Familiarise yourself with the basics of energy usage, especially in relation to gas and electric. Being able to speak knowledgeably about trends or recent developments in the energy sector can set you apart from other candidates.
✨Prepare for Scenario Questions
Think about how you would handle discrepancies in supplier invoices or how you might improve reporting processes. Prepare examples from your past experiences that demonstrate your problem-solving skills and attention to detail.
✨Show Your Communication Skills
Since strong communication is key for this role, practice articulating your thoughts clearly. Be prepared to explain complex data insights in a simple way, as you'll need to collaborate with various teams like Finance and Operations.