At a Glance
- Tasks: Join our team to analyse data and enhance decision-making through dashboards and reports.
- Company: Madison Berkeley partners with a leading REIT focused on strategic investment analysis.
- Benefits: Enjoy a dynamic work environment with opportunities for growth and skill development.
- Why this job: Kickstart your data career while making a real impact in a collaborative culture.
- Qualifications: Basic SQL, Power BI, and Excel skills; 0-2 years experience in data roles preferred.
- Other info: Ideal for proactive individuals passionate about data and strategic insights.
The predicted salary is between 28800 - 43200 £ per year.
Madison Berkeley is delighted to be partnered with a leading REIT seeking a proactive and detail-oriented Junior Data Analyst to join their Strategy and Investment Analysis team.
This role is ideal individuals early in their data career with a passion for data and an interest in helping drive strategic decisions through accessible, high-quality data and reporting. You will play a key role in maintaining and improving our existing suite of dashboards and analysis tools, while also contributing to the development of new dashboards and reporting processes to ensure data-driven decision-making across the business.
Key Responsibilities
• Conduct regular weekly and monthly checks to ensure dashboards remain accurate and up to date.
• Perform basic data analysis to identify trends, anomalies, and opportunities
• Refresh data feeds, ensuring timeliness and consistency in dashboard outputs
• Integrate diverse data sources into a SQL database and automate work processes.
• Maintain and update existing Excel reports, including internal and external KPI reports.
• Validate dashboard results against existing reports to ensure consistency and correctness.
• Develop and maintain dashboards and reports using BI tools while collaborating with stakeholders and applying AI and advanced analytics to enhance decision making.
Key Attributes
• Strong organisational skills with the ability to manage multiple tasks and deadlines.
• Exceptional attention to detail.
• A proactive approach to identifying issues, solving problems, and suggesting improvements.
• Good communication skills and the ability to collaborate effectively with colleagues at all levels.
• A genuine interest in data, analysis, and supporting strategic decision-making.
Essential Skills & Experience
• Experience using Power BI.
• Strong Excel and basic SQL skills
• Some exposure to data quality or validation tasks.
• 0–2 years of experience in a similar analyst or data-focused role.
We are currently experiencing very high demand for this role and will be responding only to applicants whose experience closely aligns with the job requirements.
Data Analyst employer: Madison Berkeley
Contact Detail:
Madison Berkeley Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analyst
✨Tip Number 1
Familiarise yourself with Power BI and Excel, as these are essential tools for the role. Consider creating a personal project or dashboard to showcase your skills, which can demonstrate your ability to handle data effectively.
✨Tip Number 2
Brush up on your SQL skills, especially focusing on how to integrate diverse data sources. You might want to practice writing queries that pull data from multiple tables, as this will be crucial for the role.
✨Tip Number 3
Network with professionals in the data analysis field, particularly those who work in real estate investment trusts (REITs). Engaging with them on platforms like LinkedIn can provide insights into the industry and potentially lead to referrals.
✨Tip Number 4
Prepare to discuss your problem-solving approach during interviews. Think of examples where you've identified issues and suggested improvements, as this aligns with the proactive mindset they are looking for in a candidate.
We think you need these skills to ace Data Analyst
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience and skills that align with the Data Analyst role. Emphasise your proficiency in Power BI, Excel, and any SQL knowledge you possess.
Craft a Compelling Cover Letter: Write a cover letter that showcases your passion for data and your proactive approach to problem-solving. Mention specific examples of how you've used data analysis in previous roles or projects.
Highlight Relevant Skills: In your application, clearly outline your organisational skills, attention to detail, and ability to manage multiple tasks. These attributes are crucial for the role and should be evident in your written application.
Showcase Your Interest in Data: Demonstrate your genuine interest in data and strategic decision-making. You can do this by discussing any relevant coursework, projects, or personal interests related to data analysis in your application.
How to prepare for a job interview at Madison Berkeley
✨Showcase Your Passion for Data
Make sure to express your genuine interest in data and how it drives strategic decisions. Share examples from your past experiences where you used data to influence outcomes or improve processes.
✨Demonstrate Attention to Detail
Since the role requires exceptional attention to detail, prepare to discuss specific instances where your meticulousness made a difference. Highlight any experience you have with data validation or quality checks.
✨Familiarise Yourself with Power BI
As Power BI is essential for this role, brush up on your skills and be ready to discuss any projects you've completed using this tool. If possible, bring along examples of dashboards you've created or worked on.
✨Prepare for Technical Questions
Expect questions related to SQL and Excel, as these are key skills for the position. Review basic SQL queries and Excel functions that are commonly used in data analysis to ensure you're well-prepared.