AVEVA

Lead Data and Intelligence Analyst

AVEVA

full-time

Posted on:

Location Type: Hybrid

Location: London • 🇬🇧 United Kingdom

Visit company website
✨ AI Apply
Apply

Job Level

Senior

Tech Stack

AzureETLSQL

About the role

  • Deliver and advance the commercial data strategy to ensure a “single version of the truth” for reporting and decision-making
  • Contribute to data warehouse and data lake initiatives to enable advanced analytics
  • Design and maintain ETL/ELT pipelines using Microsoft-based tools (e.g., Data Factory, Synapse, Fabric pipelines), ensuring data quality, integrity, and timeliness
  • Drive adoption of standardized data infrastructure by replacing non-standard data sources (Excel, manual files, SharePoint) with governed pipelines and curated datasets
  • Design, development, and optimisation of advanced dashboards, reports, and models within Power BI, ensuring usability and scalability across the business
  • Perform deep-dive and ad-hoc analyses, generating actionable insights to address commercial challenges and opportunities
  • Collaborate with senior commercial, sales, and operations leaders to understand requirements, design analytical solutions, and translate complex datasets into actionable insights
  • Develop, optimize, and maintain complex SQL queries to support analytics and reporting requirements
  • Provide technical leadership to junior analysts, fostering best practices in BI, data engineering, and stakeholder management
  • Stay current with Microsoft BI & Fabric updates, recommending and implementing improvements to data workflows and reporting

Requirements

  • Bachelor’s degree in a STEM discipline (or equivalent experience)
  • 7+ years of experience in analytics, BI, or data engineering, with at least 2–3 years in a senior or lead role
  • Expertise in Power BI – advanced DAX, data modelling, performance optimization, and deployment
  • Strong SQL proficiency with proven experience in query optimization
  • Hands-on experience with Azure Data Factory, Synapse, or Fabric pipelines
  • Strong communication and presentation skills, able to engage effectively with stakeholders at all levels
  • Ability to translate business needs into technical solutions and deliver measurable business impact
  • Strong attention to detail with a track record of delivering high-quality, accurate, and scalable BI solutions
Benefits
  • Flexible benefits fund
  • Emergency leave days
  • Adoption leave
  • 28 days annual leave (plus bank holidays)
  • Pension
  • Life cover
  • Private medical insurance
  • Parental leave
  • Education assistance program

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
ETLELTSQLDAXdata modelingperformance optimizationdata analysisdata engineeringadvanced analyticsreporting
Soft skills
communicationpresentationstakeholder managementattention to detailcollaborationtechnical leadershipproblem-solvinganalytical thinkingadaptabilitymentoring
Certifications
Bachelor’s degree in STEM