At a Glance
- Tasks: Transform and analyse data using Power BI to drive impactful decisions.
- Company: Leading public sector organisation focused on compliance and risk management.
- Benefits: Competitive pay, opportunity for remote work, and valuable experience in a dynamic environment.
- Other info: Initial 3-month contract with potential for growth in a fast-paced project.
- Why this job: Make a real difference by supporting regulatory compliance and improving services through data insights.
- Qualifications: Experience with Power BI, data cleansing, and strong analytical skills required.
The predicted salary is between 31500 - 38500 £ per year.
A leading public sector organisation is seeking an experienced Power BI Data Analyst to support a key data and compliance initiative. Driven by the introduction of new legislation, this project will help the organisation proactively identify, manage and mitigate risks across its existing estate.
This is an opportunity to deliver meaningful outcomes that support regulatory compliance, improve services and enable data-driven decision-making within a large and complex environment.
As a Power BI Data Analyst, you will join an initial 3-month contract to review, cleanse and consolidate data currently held across multiple Excel spreadsheets.
Key responsibilities will include:
- Assessing and improving the quality, consistency and accuracy of existing datasets.
- Consolidating multiple Excel-based data sources into a structured analytical model.
- Designing and developing Power BI dashboards and reporting solutions for operational and senior stakeholders.
- Creating a comprehensive reporting and case management solution.
- Producing reporting covering inspections, risk assessments, customer communications, remedial works and more.
- Analysing historical data to identify trends and patterns.
- Developing predictive analytics and risk-based models.
- Delivering actionable insights that support proactive intervention and compliance activities.
What You'll Need to Succeed:
- Strong commercial experience developing solutions in Power BI.
- Advanced data cleansing, transformation and data modelling expertise.
- Excellent knowledge of Power Query, DAX and advanced Excel.
- Experience consolidating fragmented datasets into a trusted analytical model.
- Experience developing predictive, trend-based or risk-scoring analytics.
- Strong stakeholder engagement and requirements gathering skills.
- The ability to work independently and deliver outcomes in a fast-paced project environment.
Desirable experience includes:
- SQL and database analysis experience.
- Geospatial analysis, heat mapping or hotspot visualisation expertise.
- Knowledge of data governance and data quality best practice.
- Experience supporting regulatory or compliance-driven programmes.
If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV, or call us now. If this job isn't quite right for you, but you are looking for a new position, please contact us for a confidential discussion about your career.
Data Analyst in Edinburgh employer: Hays
Join a well-established ecological consultancy in Kent that prioritises work-life balance and professional development. With a collaborative team culture and a commitment to delivering high-quality ecological advice, this company offers meaningful career progression opportunities for ecologists. Enjoy flexible working arrangements and the chance to work on diverse projects across the South East and beyond.
StudySmarter Expert Advice🤫
We think this is how you could land Data Analyst in Edinburgh
✨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 Hays!
✨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 Data Analyst at Hays.
✨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 Hays.
✨Apply Directly through Our Website
When you find a suitable opening like Data Analyst at Hays, 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 Data Analyst in Edinburgh
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 Hays, 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 Hays. 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 Hays
✨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 Hays!
✨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.
