Description:
The role includes carrying out the full data analysis lifecycle, such as requirements analysis, data modelling, metric creation, and front-end report development. Responsibilities also include supporting the technical approach for business intelligence reporting and maintaining existing business insight reports. The analyst will work to streamline reports and enhance data integrity across the organisation while demonstrating accountability in decision-making.
Key skills and responsibilities:
- Strong proficiency in SQL, Excel, Power BI, and DAX, as these tools form a core part of the role.
- Solid knowledge of T-SQL, with experience writing complex queries and developing stored procedures to extract and interrogate data.
- Deep understanding of databases, query optimisation techniques, load monitoring, the Microsoft BI Stack, and ETL frameworks.
- Technical expertise in data mining, auditing, and segmentation.
- Experience in building reusable data models, preferably involving customer and/or asset data.
- Skilled in processing and cleaning raw data to prepare it for analysis.
- Strong analytical abilities, including experience with performance data, application of techniques such as linear regression, and advanced data visualisation skills
- Proven capability in conducting user acceptance testing (UAT) to ensure data accuracy and integrity.
- Ability to translate complex datasets into meaningful, actionable insights for stakeholders without a technical background.
- Familiarity with programming languages such as Python
- Previous experience working with cloud-based data platforms, such as Snowflake or Databricks.
- Excellent communication skills, with a track record of building and maintaining strong working relationships across all organisational levels.
- Ability to understand stakeholder requirements and design appropriate, impactful reporting solutions.