At a Glance
- Tasks: Analyse energy data and support financial reporting with innovative tools.
- Company: Join the fastest-growing tech company in Yorkshire, UniHomes.
- Benefits: Enjoy a competitive salary, flexible work environment, and great perks.
- Other info: Be part of a supportive team with excellent growth opportunities.
- Why this job: Kickstart your career in data analytics and make a real impact.
- Qualifications: Strong analytical skills and experience with Python, Excel, and SQL.
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) in Sheffield employer: UniHomes.co.uk
UniHomes is an exceptional employer, offering a vibrant and supportive work culture in the heart of Sheffield. As a rapidly growing technology company, we provide extensive opportunities for personal and professional development, alongside a comprehensive benefits package that includes enhanced maternity and paternity pay, a commitment to employee well-being, and a focus on inclusivity. Join us at this exciting time as we continue to innovate and expand our services across the UK.
Contact Details:
UniHomes.co.uk Recruitment Team
StudySmarter Expert Advice🤫
We think this is how you could land Junior Data Analyst (Energy) in Sheffield
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like UniHomes.co.uk!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Junior Data Analyst (Energy) at UniHomes.co.uk.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like UniHomes.co.uk.
✨Apply Directly through Our Website
When you find a suitable opening like Junior Data Analyst (Energy) at UniHomes.co.uk, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Junior Data Analyst (Energy) in Sheffield
Strong Communication Skills
Data Analysis
Attention to Detail
Python
SQL
Microsoft Excel
Tableau
Numeracy
Automation Skills
Problem-Solving Skills
Experience with BI Tools
Experience with Energy Data
Experience with Invoice Management
Experience with Salesforce
Experience with DBT
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at UniHomes.co.uk, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at UniHomes.co.uk. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at UniHomes.co.uk
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at UniHomes.co.uk!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
