Lead Data Analyst
Role details
Job location
Tech stack
Job description
This role will lead the development of the company's data platform, ensuring data is transformed into meaningful insights that support decision-making across the business. The Lead Data Analyst will work across the full data lifecycle, from ingestion and modelling through to reporting and visualisation, while also managing and mentoring another Data Analyst/Engineer.
The Lead Data Analyst position is ideal for someone who enjoys combining hands-on technical delivery with leadership responsibility, advising on data strategy while building scalable BI solutions., * Own the organisation's data and BI capability following the implementation of Microsoft Fabric
- Design and develop high-quality Power BI dashboards and reporting solutions
- Develop and maintain data pipelines, integrations and data flows within Microsoft Fabric and Azure
- Integrate data from third-party systems and internal platforms into the data lake environment
- Build scalable data models and semantic layers for business reporting
- Build and optimise SQL queries, data models and dimensional schemas for reporting
- Support the continued growth of the organisation's data lake and analytics platform
- Analyse and interpret data to identify trends and insights that support business decision-making
- Work with business stakeholders to understand data needs and deliver actionable insights
- Manage and prioritise the analytics backlog to ensure work aligns with business value
- Lead and mentor a Data Analyst/Engineer while driving best practices across the data function
Requirements
- Strong Power BI expertise including DAX
- Experience working with Microsoft Fabric
- Knowledge of Azure Synapse, Databricks, Spark
- Strong SQL capability for querying, shaping and modelling data
- Experience building ETL/ELT pipelines and integrating data from APIs, files and databases
- Experience with cloud data services within Azure environments
- Strong stakeholder engagement skills and ability to translate data insights for business audiences
Desirable Skills for the Lead Data Analyst:
- Experience with Python or another analytics-focused programming language
- Experience working with Azure Data Lake, Azure Functions or Service Bus
- Experience managing or mentoring analysts or engineers
- Knowledge of data governance, security and BI deployment best practices
About the company
Microsoft is a global technology company headquartered in Redmond, Washington. Our mission is to empower every person and every organization on the planet to achieve more. We develop, license, and support a wide range of software products, services, and devices that help individuals and businesses realize their full potential.
Our flagship products include the Microsoft 365 productivity cloud, Windows operating system, Azure cloud platform, and Dynamics 365 business applications. We are also a leader in areas such as artificial intelligence, cybersecurity, developer tools, and gaming through Xbox and Game Pass.
With operations in more than 190 countries and over 220,000 employees worldwide, Microsoft is committed to responsible innovation, inclusive economic growth, and sustainability. We work closely with governments, industries, and communities to ensure that technology serves the public good and helps address some of the world’s most pressing challenges.
As we celebrate our 50th anniversary in 2025, we continue to look forward—investing in AI, cloud, and quantum computing to shape the future of work, education, and society at large scale.