Data Analyst
Bristol
12 months initially
30.86ph inside IR35 / Umbrella
Due to the urgent nature of the role, candidates must have valid and transferrable SC Security Clearance.
Role Description:
A data analyst / developer is required to work within a planning environment to advise and assist in the construction of reports and dashboards to benefit a diverse range of stakeholders. The successful applicant will help accelerate the development of a BI project that will bring stakeholders together, offering fresh insights and transforming the decision-making processes within a complex project planning and reporting environment.
Core Duties:
The toolset being utilised is anticipated to be Microsoft PowerBI but skills in alternative toolsets e.g. Tableau will be considered and knowledge of back-end database query languages will also be advantageous.
- Report Development: Design, develop, and maintain interactive and insightful Power BI reports tailored to meet the specific needs of a diverse range of defence stakeholders.
- Data Integration: Collaborate with cross-functional teams to gather, transform, and integrate data from various sources, including planning systems and engineering data sources.
- Data Modelling: Develop robust data models to ensure efficient data storage, retrieval, and analysis within Power BI using DAX.
- Performance Optimization: Implement optimizations to enhance overall responsiveness, ensuring that the user experience is satisfying.
- Custom Visuals: Leverage Power BIs capabilities to create custom visuals and incorporate advanced analytics to provide deeper insights.
- Data Governance: Establish and enforce data governance policies, including data validation, security and access controls to maintain data integrity and confidentiality.
- Automation and Scheduled Reporting: Advise on how automated data refresh schedules and distribution of reports might reduce manual effort and ensure timely access to critical information.
- User Training and Support: Provide training and support to end-users, enabling them to effectively utilize Power BI for data exploration and reporting.
Knowledge, Skills and Qualifications:
Knowledge:
• Proven experience in developing dashboards and reports in PowerBI or similar, ideally within a complex integration planning scenario.
• Knowledge of planning processes and defence industry-specific knowledge is a plus.
Skills:
• Strong analytical and problem-solving skills are essential. Data sources are not highly complex, so detailed SQL knowledge is not considered essential. However the applicant will have the freedom to advise how more complex techniques could benefit the scenario.
• Excellent communication and interpersonal skills for effective collaboration with cross-functional teams and interpretation of stakeholder requirements.
• Information gathering
• Pride in quality of work
• Diplomacy and influencing skills
Key Deliverables:
Deliverable Number Deliverable Title Deliverable Description Programme Required Date
1 PQQ Questions Pre-Qualification Questions to enable the client to select the supplier to enter the market testing phase TBC
2 Initial findings report Initial thoughts that will allow the Purchaser to make necessary adjustments to IT infrastructure, which can be time-consuming. CA + 1mo
3 Evidence of Problem Space Review Evidence that the review has been comprehensive. CA + 3mo
4 Proposals Report Requirement Traceability Matrix to ensure the requirements defined are valid and linked to CA + 4mo
5 Upissued Power BI projects Incremental upissues to the PowerBi project that enact changes to both the database and visuals. CA + 5mo
6 Training delivery Rollout of training to developers and users CA + 7mo