> Markdown version of [/jobs/ext/2786074-data-analyst](https://www.wearedevelopers.com/jobs/ext/2786074-data-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Analyst - **Company:** Red Sky Personnel - **Location:** St Albans, UK - **Contract:** Permanent contract - **Skills:** Microsoft Word, Microsoft Excel, Microsoft Windows, Python (Programming Language), Microsoft OneNote, Pivot Tables, Windows PowerShell, Power BI, Microsoft SharePoint, SQL Databases, Systems Integration, Web Platforms, Data Storage Technologies, Microsoft Power Automate, Office365, Data Management, Tools for Reporting, Powerapps - **Published:** September 8, 2026 - **Apply:** https://www.collegerecruiter.com/job/2858064532-data-analyst ## About the Role * Experience using data management and reporting tools to collect, analyse and present information effectively. * Good working knowledge of Microsoft 365 applications, including Word, Excel, OneNote, Planner, OneDrive, Teams, SharePoint, Power Apps, Power BI and Power Automate. * Ability to develop and maintain basic automated workflows and integrate data across Microsoft 365 platforms. * Understanding of SharePoint Lists, data storage and information-sharing best practice. * Good knowledge of Excel functions, formulas, pivot tables and reporting techniques. * Basic PowerShell skills to support administration and automation activities. * Understanding of data privacy, security and governance principles. * Strong troubleshooting and problem-solving skills, with the ability to resolve system and data-related issues. * Strong communication and collaboration skills, with the ability to build effective working relationships at all levels., * Recognised certification in one or more of the following: Power Apps, Power Automate, Power BI, SharePoint, Python or SQL. * Knowledge and understanding of Python. * Experience within civil engineering, infrastructure, construction, utilities or another project-led environment. ## Description * Design and implement tools to streamline HSEQ data capture, analysis and reporting. * Automate data-heavy processes to reduce administrative workload and improve efficiency. * Develop balanced scorecards and Power BI dashboards providing live, integrated views of business performance, including inspections, waste management, interventions and audit data. * Support and monitor the deployment of new digital platforms, ensuring effective integration with existing systems. * Oversee quarterly verification of carbon data required for external audits and carbon-reduction reporting. * Implement systems for plant idling data capture and telematics, integrating information into unified business dashboards. * Design controlled tests to assess the impact of social value initiatives, including community messaging and public sentiment. * Use data insights to enhance social value activity and support stronger public relations outcomes. * Compare tender assumptions and outputs against actual project performance to identify profitability drivers and opportunities to improve future tenders. * Model future work programmes and analyse historic project performance to support operational planning and identify potential gaps. * Develop automated reports and trackers covering retention, debt, WIP and cash position, providing timely performance information and action reminders to commercial teams. * Create efficiency models from solution reviews, test them through delivery and present findings through Power BI reporting. * Compile data and site information from operational reporting into monthly client reports for discipline leads. * Support the comprehensive capture of Research & Development activity to maximise eligible innovation-related tax opportunities. * Help establish structured testing regimes to assess cause and effect, effort versus reward and the effectiveness of different techniques. ## Related Videos - [Replacing Excel with SAP APIs & Python validation](https://www.wearedevelopers.com/videos/1944-replacing-excel-with-sap-apis-python-validation) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) - [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Software Engineer Salary London](https://www.wearedevelopers.com/magazine/252-software-engineer-salary-london) - [Software Engineer Salary in The UK](https://www.wearedevelopers.com/magazine/231-software-engineer-salary-in-the-uk)