Overview
Senior Data Analyst – Home Based
Job Description
Costain’s Advisory and Digital Solutions directorate is undergoing a period of growth within the business. Our area of the business is key to the overall strategy of the organisation in meeting its strategic goals for 2025 and beyond.
Within the Data Insights team, we have a need for a lead technical expert in Power BI who can also contribute towards the strategic direction of Advisory and Costain as a whole. We work across Divisions in all sectors within Costain and we work with our Engineering and Operational colleagues to enable and drive delivery of our projects to our clients.
As an effective Senior Data Analyst you will manage data and information within specific projects. It will involve compiling, cleaning and transforming data from multiple raw sources into clearly presented and efficient visualisations, ensuring stakeholder engagement. support structured analysis and input into effective decision making.
You will develop Power BI reports and dashboards and help create, engage and support a data-driven culture across the project by building trust in quality project data. A part of this role it to provide constructive improvements whilst meeting the reporting needs of the project.
The role is home-based with some occasional travel to Costain offices and client project sites.
#LI-MR1
Responsibilities
- To enforce the project progress reporting cycle in respect of Data Collection, Validation, Reporting and Analysis.
- Build and continuously improve information visualisation on Power BI dashboards and tabular reports to ensure different audiences are presented with intelligence.
- To liaise with the Senior Leadership Team and Management Team to collate, assure and publish the weekly and month-end Progress Report.
- To support the Senior Leadership Team and Management Teams with ad-hoc reports and analysis as required.
- To work with the senior leadership in developing the performance maturity framework mapping all the discipline performance indicators to objectives and ensuring performance measurement is reliable and compliant to specification.
- To help develop and document a project data-model (data dictionary, taxonomy and ontology) to support the project team with self-service.
- Contribute pro-actively as a member of key working groups within Costain to represent the project, share best practice and drive continuous improvement.
Qualifications
Essential
- Good experience with Microsoft Power BI, DAX functional language and PowerQuery M language.
- Pays attention to detail and sees things through to completion.
- Has an ability to gather, analyse and evaluate facts in detail whilst still retaining perspective and focus on the wider picture.
- Has good interpersonal and communication skills and acts in an independent and professional manor.
- Is good at building relationships and can influence effectively.
- Is a self-starter who manages their own time and seeks to add value to their function.
- Is not afraid to address and challenge blockers to information or to raise constructive challenge.
- Can deliver accurate and robust reports orally and written, in an objective and persuasive manner.
- Can visualise data in a really engaging and intuitive way.
- Is used to delivering in a time pressured environment to meet client deadlines, and driving timely delivery from others.
- Understands and drives efficiency by applying lean improvement principles.
- Experience with Microsoft Power Automate.
- Strong Excel skills in data management, pivot tables and Power Query.
- Strong Word skills, familiar with templates, styles, references, captions, field codes and track changes.
Desirable
- Database administration with SQL Server Management Studio experience and SQL language skills will be viewed very favourably.
- Systems integration experience
- Azure data factory, logic apps, data bricks, data lake tooling
- Visual Studio and GitHub repositories
- Basic Python skills
- Microsoft Certified: Power BI Data Analyst Associate (PL-300)
About Us
Costain helps to improve people’s lives with integrated, leading edge, smart infrastructure solutions across the UK’s energy, water, transportation and defence markets. We help our clients improve their business performance by increasing capacity, improving customer service, safeguarding security, enhancing resilience, decarbonising and delivering increased efficiency. Our vision is to be the UK’s leading smart infrastructure solutions company. We will achieve this by focusing on blue chip clients whose major spending plans are underpinned by strategic national needs, regulatory commitments, legislation or essential performance requirements. We offer our clients leading edge solutions that are digitally optimised through the following five services which cover the whole lifecycle of their assets: future-shaping strategic consultancy; consultancy and advisory; digital technology solutions; asset optimisation and complex programme delivery. Our culture and values underpin everything we do.
A Disability Confident employer will generally offer an interview to any applicant that disclose they have a disability and meets the minimum criteria for the job as defined by the employer.
It is important to note that in certain recruitment situations such as high-volume, seasonal and high-peak times, the employer may wish to limit the overall numbers of interviews offered to both disabled people and non-disabled people.
For more details please go to the Disability Confident website:
https://www.gov.uk/government/collections/disability-confident-campaign
About the Team
Advisory is a core part of Costain’s strategy to broaden our mix of services and grow margin performance. We work with clients on multiple strategic fronts to understand, articulate and provide solutions for their most complex challenges and to facilitate further growth in multiple areas.
Our vision is to be recognised as a leading infrastructure consultancy who transform client capabilities and help them achieve enhanced value for money.
This is a key part of Costain achieving its mission to shape, create and deliver pioneering solutions that transform the performance of the infrastructure ecosystem.
