At a Glance
- Tasks: Create impactful Power BI dashboards and provide actionable insights for transportation projects.
- Company: Join Fishbone Solutions, a growing consultancy in the UK rail and transportation sector.
- Benefits: Competitive salary, career development opportunities, and a collaborative work environment.
- Other info: Exciting chance to grow within a dynamic team and shape data usage across projects.
- Why this job: Make a real difference in project delivery while developing your data analytics skills.
- Qualifications: STEM degree or relevant experience; familiarity with Power BI, SQL, and data analysis.
The predicted salary is between 36000 - 60000 £ per year.
Due to continued growth, Fishbone Solutions is looking to strengthen its established team to support the delivery of both existing and new projects. We are seeking a Data Analyst to support the delivery of project management, engineering and assurance programmes, particularly within the UK rail and wider transportation industry.
As a Data Analyst, you will support the development of high-quality management information through the creation of Power BI dashboards and analytical solutions. You will work closely with clients and internal teams to understand business requirements, analyse data, and provide actionable insights that support effective project delivery.
The ideal candidate will be personable, comfortable communicating with stakeholders, and able to translate technical concepts into clear insights for non-technical audiences. As our portfolio of projects continues to grow and our data capabilities expand, this is an exciting opportunity to join a team that is actively developing new analytical solutions and supporting a wide range of projects across transportation, engineering, operations, and programme delivery. The successful candidate will have the chance to contribute to the growth of the team, help shape how data is used across our projects, and play a key role in developing and delivering impactful insights to our clients.
What can you expect from this job?
- Collaborate with clients and internal teams to understand data requirements and provide valuable insights using Power BI.
- Develop and maintain data models, dashboards and applications using Power BI, including the creation of DAX measures and calculations.
- Work with clients and stakeholders to gather, validate and refine reporting requirements, ensuring analytical outputs align with project objectives.
- Conduct data cleaning, transformation and preparation using tools such as Power Query, SQL and Excel to support business intelligence outputs.
- Use SQL to query, analyse and understand relational datasets, including navigating database schemas and relationships.
- Support data validation and quality assurance processes to ensure the reliability and integrity of reporting outputs.
- Communicate analytical findings and insights to clients in a clear and concise manner.
- Work both independently and collaboratively to deliver work packages to agreed quality, time and budget.
- Support the delivery of innovative analytical solutions within R&D programmes and client projects.
- Collaborate with a diverse engineering and project delivery team to develop analytical outputs that support project performance and decision-making.
- Continuously improve data analysis processes and techniques to increase efficiency and quality of work.
- Work closely with the Business Intelligence Manager to support the development of data analytics capabilities within Fishbone Solutions.
Qualifications required
- A STEM degree is preferred, but relevant equivalent experience will also be considered.
- Experience working in data analytics, business intelligence or reporting.
- Experience using Power BI for dashboard development and data modelling.
- Experience engaging with clients or stakeholders to gather and refine reporting requirements.
Technical expertise and skills required
- Experience developing dashboards and reports using Power BI.
- Strong understanding of DAX measures and calculations.
- Strong Excel skills, including formulas, structured datasets and analytical techniques.
- Working knowledge of SQL, including querying relational databases and understanding schema relationships.
- Knowledge of Python for data processing, automation or integration tasks is desirable.
- Understanding of data modelling, data transformation and reporting best practices.
- Ability to interpret complex datasets and translate findings into meaningful insights.
- Strong documentation and technical report writing skills.
- Confidence presenting analytical outputs to senior stakeholders and clients.
- Understanding of AI, machine learning or advanced analytics techniques would be beneficial but is not essential.
- Knowledge of the UK rail or wider transportation industry would be advantageous but is not essential.
Highly desirable
There is a strong opportunity within Fishbone Solutions to contribute to the growth of our data and analytics capability while supporting major infrastructure programmes. You will have the opportunity to work with experienced engineering and project teams, delivering insights that directly support client decision-making. We are actively seeking candidates with the drive and capability to contribute to this growth and support the continued development of our analytics services. In return, we offer a competitive package and benefits, alongside opportunities for career development and progression within a growing transportation and analytics consultancy.
Data Analyst employer: Fishbonesolutions
Fishbone Solutions is an excellent employer for Data Analysts, offering a dynamic work environment where you can contribute to impactful projects within the UK rail and transportation industry. With a focus on employee growth, we provide opportunities for career development, competitive benefits, and a collaborative culture that values innovation and teamwork. Join us to shape the future of data analytics while working alongside experienced professionals dedicated to delivering high-quality insights.
StudySmarter Expert Advice🤫
We think this is how you could land Data Analyst
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect with potential colleagues on LinkedIn. The more you engage, the better your chances of landing that Data Analyst role.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your Power BI dashboards and any analytical projects you've worked on. This will give you an edge when chatting with potential employers about your experience.
✨Tip Number 3
Prepare for interviews by brushing up on common data analysis questions and scenarios. Practice explaining complex concepts in simple terms, as you'll need to communicate effectively with non-technical stakeholders.
✨Tip Number 4
Don't forget to apply through our website! We love seeing candidates who are genuinely interested in joining our team at Fishbone Solutions. Your application could be the one that stands out!
We think you need these skills to ace Data Analyst
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Data Analyst role. Highlight your experience with Power BI, SQL, and any relevant projects you've worked on. We want to see how your skills align with what we're looking for!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about data analytics and how you can contribute to our team. Don't forget to mention your experience with stakeholders and translating technical concepts into clear insights.
Showcase Your Technical Skills:Be sure to highlight your technical expertise in DAX, Excel, and data modelling. We love seeing candidates who can demonstrate their ability to clean, transform, and analyse data effectively. Share specific examples of your work!
Apply Through Our Website:We encourage you to apply through our website for the best chance of getting noticed. It’s super easy, and we’ll be able to review your application quickly. Plus, it shows you're serious about joining our team!
How to prepare for a job interview at Fishbonesolutions
✨Know Your Tools Inside Out
Make sure you're well-versed in Power BI, SQL, and Excel. Brush up on DAX measures and calculations, as you'll likely be asked to demonstrate your technical skills. Familiarity with data cleaning and transformation tools will also give you an edge.
✨Understand the Business Context
Research Fishbone Solutions and their projects within the UK rail and transportation industry. Being able to discuss how your analytical skills can directly impact their work will show that you're not just a techie but someone who understands the bigger picture.
✨Prepare for Stakeholder Communication
Since the role involves communicating insights to non-technical audiences, practice explaining complex data concepts in simple terms. Think of examples from your past experiences where you've successfully communicated findings to clients or stakeholders.
✨Show Your Collaborative Spirit
This position requires working closely with various teams. Be ready to share examples of how you've collaborated in the past, whether it's through teamwork on projects or engaging with clients to refine requirements. Highlighting your interpersonal skills will make you stand out.
