AVEVA is creating software trusted by over 90% of leading industrial companies.
Job Title: Lead Data and Intelligence Analyst
Location: London/Cambridge - Hybrid
Employment Type: Full-Time
The job
We are seeking a highly skilled and hands-on Lead Data and Intelligence Analyst, ensuring that data solutions directly support commercial strategy and performance.
The successful candidate will be an expert in Power BI and proficient in SQL, with practical experience in building data engineering pipelines within the Microsoft ecosystem. This role requires a blend of technical expertise, business acumen, and stakeholder engagement, along with the ability to provide leadership and mentorship to junior analysts.
Key Responsibilities:
1. Commercial Data Intelligence – 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.
2. Data Engineering Pipelines – 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.
3. Power BI Development – Design, development, and optimisation of advanced dashboards, reports, and models within Power BI, ensuring usability and scalability across the business.
4. Data Analysis – Perform deep-dive and ad-hoc analyses, generating actionable insights to address commercial challenges and opportunities.
5. Stakeholder Engagement – Collaborate with senior commercial, sales, and operations leaders to understand requirements, design analytical solutions, and translate complex datasets into actionable insights.
6. SQL & Data Modelling – Develop, optimize, and maintain complex SQL queries to support analytics and reporting requirements.
7. Leadership & Mentorship – Provide technical leadership to junior analysts, fostering best practices in BI, data engineering, and stakeholder management.
8. Continuous Improvement – Stay current with Microsoft BI & Fabric updates, recommending and implementing improvements to data workflows and reporting.
Qualifications & Experience:
9. Bachelor’s degree in a STEM discipline (or equivalent experience).
10. 7+ years of experience in analytics, BI, or data engineering, with at least 2–3 years in a senior or lead role.
11. Expertise in Power BI – advanced DAX, data modelling, performance optimization, and deployment.
12. Strong SQL proficiency with proven experience in query optimization.
13. Hands-on experience with Azure Data Factory, Synapse, or Fabric pipelines.
14. Strong communication and presentation skills, able to engage effectively with stakeholders at all levels.
15. Ability to translate business needs into technical solutions and deliver measurable business impact.
16. Strong attention to detail with a track record of delivering high-quality, accurate, and scalable BI solutions.
Competencies:
17. Technical Leadership – Ability to set standards, mentor others, and act as a SME in BI and data engineering.
18. Strategic Thinking – Capable of aligning technical solutions with commercial objectives.
19. Collaboration – Adept at working cross-functionally and influencing decision-making in a matrixed organization.
20. Problem Solving – Able to diagnose data issues, propose solutions, and implement improvements quickly.
21. Commercial Acumen – Understands the dynamics of sales and commercial operations, ensuring analytics directly support performance improvement.
Commercial at AVEVA
Our Commercial team, comprised of over 2,000 dedicated colleagues, is the backbone of our customer relationships and business growth. From industry experts and solution architects to sales, support, success managers, and business operations, everyone shares a common goal: to deeply understand our customers' needs and deliver tailored solutions.
If you're passionate about driving growth, tackling complex business challenges, and fostering strong customer relationships, you'll find success and fulfilment in our Commercial team.
Find out more:
UK Benefits include:
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.
It’s possible we’re hiring for this position in multiple countries, in which case the above benefits apply to the primary location. Specific benefits vary by country, but our packages are similarly comprehensive.
Find out more: aveva.com/en/about/careers/benefits/
Hybrid working
By default, employees are expected to be in their local AVEVA office three days a week, but some positions are fully office-based. Roles supporting particular customers or markets are sometimes remote.
Hiring process
Interested? Great! Get started by submitting your cover letter and CV through our application portal. AVEVA is committed to recruiting and retaining people with disabilities. Please let us know in advance if you need reasonable support during your application process.
Find out more: aveva.com/en/about/careers/hiring-process
About AVEVA
AVEVA is a global leader in industrial software with more than 6,500 employees in over 40 countries. Our cutting-edge solutions are used by thousands of enterprises to deliver the essentials of life – such as energy, infrastructure, chemicals, and minerals – safely, efficiently, and more sustainably.
We are committed to embedding sustainability and inclusion into our operations, our culture, and our core business strategy. Learn more about how we are progressing against our ambitious 2030 targets: sustainability-report.aveva.com/
Find out more: aveva.com/en/about/careers/