Data Analyst role supporting technical disciplines in data-driven reporting across various projects for built environment consultancy. Utilizing Microsoft technologies for insights, reporting, and automation.
Responsibilities
Supporting a range of technical disciplines - including Building Surveyors, Fire Engineers, Clerk of Works and Designers - to deliver data-driven reporting across a range of projects.
Delivering data-driven insights, reporting, and automation using the latest Microsoft technology stack.
Extracting and loading data from multiple sources using SQL, Python, Microsoft Fabric Dataflows, and Pipelines.
Analyzing structured and semi-structured datasets to uncover patterns, trends, and actionable insights.
Developing and maintaining visually compelling reports and dashboards using Power BI, SSRS, and Excel.
Building, deploying, and maintaining a library of templated analytics and reporting solutions for internal and external stakeholders.
Collaborating with internal stakeholders in Service and IT to translate business requirements into actionable data solutions.
Requirements
Bachelor’s degree (or equivalent experience and related certifications) in Computer Science, Data Science, Information Systems, or a related field.
Strong proficiency in Microsoft technologies, especially Power BI, Excel, and Microsoft Fabric (including Data Factory, PySpark, OneLake) as well as DAX and Power Query.
Proficiency in SQL, data modelling, and data integration.
Familiarity with data analysis, statistical concepts, and data visualisation best practices.
Knowledge of Medallion Architecture principles
Microsoft Certifications related to Data Platform (DP-300, DP-600, DP-700, PL-300)
Transformation of data using Python
Knowledge of construction or built environment industry data and classification standards (e.g., COBie, IFC, Uniclass).
Experience with API integration and automation.
Experience with Copilot or similar AI-powered productivity tools.
Exposure to machine learning, predictive analytics, or AI-driven insights.
Benefits
Hybrid Working - Working patterns to support your work-life balance. As well as competitive maternity and paternity packages.
Well-Rewarded - A competitive salary and generous holiday entitlement. As well as the opportunity to purchase up to five extra days.
Focus On Wellbeing - We offer a number of health and wellness options, including gym membership and cycle to work schemes.
Healthcare Packages - Private healthcare insurance and medical support, including dental insurance and eyecare vouchers.
Personal Development - A continuous learning and development programme, including established APC and in-house mentoring schemes.
Additional Benefits - We offer a wide range of benefits including a season ticket loan and professional membership subscriptions.
Exceptional Exposure - You’ll have the opportunity to work on diverse projects across different sectors and regions.
Social Responsibility - We hold team and social events as well as charity fundraising and volunteering activities.
Associate Business Intelligence Analyst enhancing credit risk decision - making through analysis and reporting. Developing dashboards and preparing risk management reports for lending businesses.
Senior BI Specialist developing Power BI reports, dashboards, and KPI scorecards for Brillio. Collaborating with users to gather requirements and ensure data accuracy.
Senior Business Intelligence Analyst at TD supporting risk management and compliance initiatives. Delivering BI solutions and collaborating with stakeholders for informed decision - making.
Junior Teamlead BI Consultant leading Data & Cloud consulting projects in Switzerland. Managing responsibilities for enterprise clients and collaborating with international teams in the BI sector.
Intermediate BI Developer maintaining BI solutions and delivering BI development initiatives in managed services team. Collaborating with clients to enhance BI environments and ensure data quality.
BI Specialist designing and developing data integration and reporting solutions using Microsoft BI tools. Collaborating with stakeholders in Bangalore to deliver enterprise - level analytics and dashboards.
BI Specialist developing Power BI reports and dashboards for business intelligence solutions. Collaborating with clients and internal teams to deliver effective analytics.
Lead Developer for Business Intelligence at Transamerica, spearheading database solutions and analytics product development. Directing BI projects with a focus on data warehousing and visualization tools.
Commercial Excellence BI Analyst responsible for designing Power BI solutions and transforming data into insights for strategic business decisions. Collaborating with teams to enhance sales productivity and analytics.
Power BI Developer transforming complex data into actionable insights at Allucent. Collaborate with analysts to develop Power BI dashboards and reports for the biopharmaceutical industry.