Construction Data Analyst

Description

• Create strong and lean data model to ensure efficient data processing and optimal performance of Power BI dashboards, while supporting scalability and ease of maintenance
• Define and refine, in coordination with the Data Engineer, semantic data models, workflows, and governance practices.
• Collaborating with stakeholders to understand reporting requirements and translate them into clear brief
• Integrate and manage diverse data sources, ensuring high standards of data quality, consistency, and scalability
• Oversee the implementation of BI initiatives to support data-informed decision-making across department
• Designing, building, and maintaining interactive dashboards in Power BI to visualise business metrics and trends
• Extracting, transforming, and loading data from Snowflake into Power BI for analysis and reporting
• Champion data literacy initiatives, training stakeholders on effective data usage and storytelling
• Leveraging Power BI features to allow for the creation of interactive visuals that respond to user input and facilitate more meaningful data exploration
• Writing and optimising SQL queries to retrieve and manipulate data within Snowflake, ensuring data accuracy and efficiency
• Conducting data quality checks and liaising with the business to troubleshoot data inconsistencies
• Presenting findings and dashboard solutions to both technical and non-technical audiences, supporting data-driven decision-making
• Design, build, and maintain Power BI dashboards and reports that deliver real business impact
• Working with Business Sponsors and Data Owners to define, interpret, and simplify complex data requirements, ensuring solutions are aligned with business objectives
• Use DAX to create calculated measures and columns within Power BI dashboards, enabling advanced analytics and dynamic reporting. This includes implementing time intelligence functions, performing complex aggregations, and building custom KPIs to provide deeper insights into business performance
• Establish and promote data quality and operational excellence through best practices and process improvements.
• Help grow an internal data community to foster collaboration, innovation, and knowledge sharing

Requirements

• Strong Proficiency in Power BI (PL-300 Level Minimum – Certification not required but welcomed)
• Experience working within the Microsoft 365 (MS/O365) ecosystem is highly desirable.
• Natural community-builder – thrives on mentoring, sharing knowledge, and fostering innovation
• Ability to clearly document and present not only analytical findings but also the underlying processes and methodologies, ensuring transparency and reproducibility
• Strong communication skills – able to explain complex data concepts to non-technical stakeholders
• Experience in data quality management, data visualisation, and dashboard design/UX and optimisation. Candidates are expected to present their portfolios of dashboards created, showcasing their ability to visualize data and extract meaningful insights. This presentation should include examples of how their dashboards have driven decision-making and improved business processes
• A comprehensive understanding of construction data and topics is essential
• Degree in Mathematics, Statistics, Computer Science, or a related field
• Good SQL knowledge, and data modelling techniques.
• Familiarity in Snowflake is a plus
• Proven ability to collaborate across teams, understanding business needs and aligning data solutions accordingly

Benefits

• pension scheme
• private medical insurance
• BY Extra – opt into lifestyle benefits
• 26 days annual leave, increasing to 30 days
• Volunteering opportunities
• life insurance

Training + Development

Interview process

Visa Sponsorship

Security clearance