Data Modelling Analyst

Role overview

Responsibilities

• Manipulate data from multiple sources, including unstructured data, to improve the robustness and efficiency of outputs for quantity surveyors, the Commercial team, and management.
• Work with commercial assistants to reduce manual work in staff cost reporting.
• Work with the Cost Manager to improve application-for-payment processes and cover white- and blue-collar cost reporting.
• Collaborate with Commercial, Procurement, Finance, workers, and external parties; build understanding of project timelines, deliverables, and cost management within project controls.
• Work is performed in a live Ministry of Defence facility; other suitable tasks may be assigned with training and support.

Essential requirements

• Advanced Power BI and Power Query, or equivalent, data-modelling ability using multiple Excel and unstructured datasets.
• Strong numerical, analytical, data-analysis, and critical-thinking skills; strong Excel skills, including INDEX/MATCH, XLOOKUP, nested IFs, TEXTBEFORE/AFTER, and VSTACK.
• Attention to detail, ethical teamwork, ownership, and curiosity to ask questions and offer ideas.
• Degree or equivalent qualification in data science, programming, finance, or quantity surveying.
• GCSEs including Maths, English, and IT or a technical subject at grade 5 or above.
• BPSS security clearance is required; clearance processing may take up to eight weeks.

Desirable qualifications and experience

• Team experience, budgeting and dashboard-creation skills, confident communication, and construction-industry understanding are desirable.
• Working toward an apprenticeship or other relevant postgraduate qualification is desirable.

Workplace and schedule

• The position is based at Devonport Dockyard in Plymouth, within a live MOD facility.
• The role is permanent and scheduled for 42.5 hours per week.

Benefits

• Benefits include a competitive salary, family-friendly policies, company car or travel allowance, 8% matched pension contributions, private healthcare, and life assurance.
• Leave provisions include 26 days' holiday, two wellbeing days, and one volunteering day; personal and professional development is offered.

About BAM