At a Glance
- Tasks: Support data models, dashboards, and performance reporting in a dynamic project environment.
- Company: Join a forward-thinking company focused on innovation and collaboration.
- Benefits: Enjoy competitive pay, flexible working, and tailored benefits for your lifestyle.
- Other info: Great opportunities for training and professional growth in a supportive culture.
- Why this job: Make an impact with data insights that drive effective decision-making.
- Qualifications: Experience with Power BI, data analysis, and project controls processes.
The predicted salary is between 35000 - 45000 £ per year.
In this role, you will support the development and maintenance of data models, dashboards, and performance reporting within the Project Controls function. Working closely with senior team members, you will contribute to producing high-quality insights that enable effective decision-making across the project. This position offers the opportunity to build deeper capability in Power BI, project controls processes, and data analysis within a fast-paced project environment.
Data Modelling & Dashboard Support
- Assist in developing and maintaining structured data models that underpin interactive dashboard visualisations.
- Support the delivery of dashboards that highlight performance trends and areas of concern through clear, actionable insights.
- Contribute to root cause analysis by preparing, organising, and validating data used in reporting outputs.
Project Controls Process Support
- Develop an understanding of construction project controls processes and help document business processes with digitalisation in mind.
- Work with senior team members to ensure reporting inputs adhere to agreed processes and quality standards.
Reporting & Performance Insights
- Support the preparation of periodic and ad-hoc reports, ensuring accuracy, consistency, and timely submission.
- Assist in compiling the monthly project review pack and ensuring information flows effectively to senior stakeholders.
- Help collate KPIs and progress data related to time, cost, risk, change, and quality.
Performance Measurement & Integration
- Contribute to the development and implementation of performance measurement systems, such as Earned Value Management (EVM), under guidance from senior team members.
- Help integrate schedule, cost, scope, quality, risk, and change data to create a holistic view of project health.
- Provide initial interpretation of monthly reporting outputs to support timely decision-making.
Continuous Improvement
- Participate in sharing lessons learned and identifying opportunities to improve reporting, tools, and data processes within the Project Controls community.
About you
- Demonstrable experience in transforming and organising data sets using Power Query or similar tools.
- Experience in developing structured data models incorporating fact and dimension tables, with the ability to define and manage relationships within Power BI.
- Competency in data manipulation and analysis, preferably with exposure to DAX for calculations and insights.
- Experience in creating or supporting the development of Power BI dashboards, with an understanding of how to translate data into meaningful visual insights.
- Strong skills in Advanced Excel, including formulas, pivot tables, visualisation techniques, and automation to support robust reporting and analysis.
- Knowledge of the Microsoft Power Platform (Power Apps, Power Automate, Power BI) to support workflow creation, data capture, and visualisation.
- Experience working within a Project Controls environment on large or complex construction or infrastructure programmes.
- Understanding of schedule, cost, and risk management principles.
- Previous involvement in a Project Controls team within a major project setting.
- Awareness of the transport, energy, infrastructure, or construction sectors, including familiarity with NEC contract environments.
Rewards & benefits
Enjoy competitive salaries, employee rewards and a brilliant range of benefits you can tailor to suit your own health, wellbeing, financial and lifestyle choices. Make the most of a myriad of opportunities for training and professional development to grow your skills and expertise. Combine a hybrid working culture and flexible holiday allowances to balance a great job and fulfilling personal life.
Security clearance
This role may require security clearance and offers of employment will be dependent on obtaining the relevant level of clearance. If this is necessary, it will be discussed with you at interview. The vetting process is delivered by United Kingdom Security Vetting (UKSV) and may require candidates to provide proof of residency in the UK of 5 years or longer.
Equality, diversity and inclusion
We are committed to creating a culture where everyone feels that they belong – a place where we can all be ourselves, thrive and develop to be the best we can be. As an Equal Opportunities Employer, we value applications from all backgrounds, cultures and ability.
Project Controls Data & Reporting Analyst in Birmingham employer: SNC-Lavalin
As a Project Controls Data & Reporting Analyst, you will thrive in a dynamic work environment that prioritises employee growth and development. Our company offers competitive salaries, a comprehensive benefits package, and a hybrid working culture that promotes work-life balance, all while fostering a culture of inclusivity and continuous improvement. Join us to enhance your skills in Power BI and data analysis, contributing to impactful projects in the construction and infrastructure sectors.
StudySmarter Expert Advice🤫
We think this is how you could land Project Controls Data & Reporting Analyst in Birmingham
✨Tip Number 1
Get to know the company and its projects inside out. Research their recent work, especially in project controls and data analysis. This will help you tailor your conversations and show that you're genuinely interested in what they do.
✨Tip Number 2
Practice your technical skills before the interview. Since a pre-screening technical test is part of the process, brush up on Power BI, DAX, and data modelling. We want you to feel confident and ready to showcase your abilities!
✨Tip Number 3
Prepare some insightful questions to ask during the interview. This shows that you're engaged and thinking critically about how you can contribute to their team. Think about how you can help improve reporting and data processes.
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets the attention it deserves. Plus, we love seeing candidates who take the initiative to connect with us directly.
We think you need these skills to ace Project Controls Data & Reporting Analyst in Birmingham
Some tips for your application 🫡
Tailor Your Application:Make sure to customise your CV and cover letter to highlight your experience with data modelling and Power BI. We want to see how your skills align with the role, so don’t hold back on showcasing your relevant projects!
Showcase Your Technical Skills:Since this role involves a lot of data manipulation and reporting, be sure to mention your proficiency in tools like Power Query and Advanced Excel. We love seeing examples of how you've used these tools to create impactful insights.
Be Clear and Concise:When writing your application, keep it straightforward and to the point. Use bullet points where possible to make it easy for us to see your key achievements and skills at a glance.
Apply Through Our Website:We encourage you to submit your application through our website. It’s the best way for us to receive your details and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at SNC-Lavalin
✨Know Your Data Tools
Make sure you brush up on your skills with Power BI, Power Query, and Advanced Excel. Be ready to discuss how you've used these tools in past projects, especially in creating dashboards or data models. Showing that you can transform and organise data sets will definitely impress the interviewers.
✨Understand Project Controls Processes
Familiarise yourself with construction project controls processes and be prepared to talk about them. Knowing how to document business processes with digitalisation in mind will show that you’re proactive and understand the role's requirements. Bring examples of how you've contributed to similar processes in previous roles.
✨Prepare for Technical Questions
Since there's a pre-screening technical test, practice common data analysis scenarios and reporting techniques. Brush up on DAX calculations and how to interpret performance metrics. Being able to demonstrate your analytical thinking during the interview will set you apart from other candidates.
✨Showcase Continuous Improvement Mindset
Be ready to discuss how you've identified opportunities for improvement in reporting or data processes in your past experiences. Highlight any lessons learned and how you’ve applied them to enhance project outcomes. This shows that you’re not just about maintaining the status quo but are keen on driving efficiency.
