Join to apply for the Lead Data and Intelligence Analyst role at AVEVA
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
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:
* Commercial Intelligence – Deliver and enable the analytics strategy to ensure a “single version of the truth” for reporting and decision-making. Ensure development is aligned to delivering on AVEVA’s commercial goals.
* Power BI Development – Design, development, and optimisation of advanced dashboards, reports, and models within Power BI, ensuring usability and scalability across the business.
* SQL & Data Modelling – Develop, optimize, and maintain complex SQL queries to support analytics and reporting requirements.
* Data Analysis – Perform deep-dive and ad-hoc analyses, generating actionable insights to address commercial challenges and opportunities.
* 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.
* Stakeholder Engagement – Collaborate with senior commercial, sales, and operations leaders to understand requirements, design analytical solutions, and translate complex datasets into actionable insights.
* Leadership & Mentorship – Provide technical leadership to junior analysts, fostering best practices in BI, data engineering, and stakeholder management.
* Continuous Improvement – Stay current with Microsoft BI & Fabric updates, recommending and implementing improvements to data workflows and reporting.
Essential 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.
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.
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.
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.
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.
Equal Opportunity Employer
AVEVA is an Equal Opportunity Employer. We are committed to being an exemplary employer with an inclusive culture, developing a workplace environment where all our employees are treated with dignity and respect.
#J-18808-Ljbffr