Senior Data Analyst: Power BI, SQL & VBA Insights

Ampstek; Paris; On-site; EUR 65,000 - 90,000; Full time

Job summary

Ampstek is seeking an experienced Data Analyst to transform complex datasets into clear, actionable insights and develop robust Power BI dashboards to support strategic planning and operational efficiency.

The role requires deep expertise in Power BI, SQL, and Excel VBA, with a strong understanding of business operations and data-driven decision-making. You will collaborate with stakeholders to deliver analytical solutions and drive organizational growth.

Qualifications

• 6+ years of experience in Data Analytics / Business Intelligence / Data Analysis.
• Advanced hands-on experience with Microsoft Power BI.
• Strong Power BI Reports & Dashboards.
• Data Power Query
• Data DAX
• Report Performance Optimisation
• Data Source Integration
• Strong SQL knowledge with experience writing complex queries.
• Strong Hands-on experience with Excel VBA programming and automation.
• Good understanding of business operations and data-driven decision-making.

Responsibilities

• Analyse complex datasets and translate findings into actionable business insights.
• Develop and maintain interactive Power BI dashboards, reports, and visualizations.
• Design effective data models and optimise Power BI reports for performance.
• Integrate data from multiple sources and ensure data accuracy and consistency.
• Write and optimise complex SQL queries for data extraction and analysis.
• Work closely with business stakeholders to understand requirements and translate them into analytical solutions.
• Support strategic planning, business process improvement, and data-driven decision-making.
• Identify trends, patterns, anomalies, and opportunities within business data.
• Develop and maintain Excel-based analytical solutions using VBA programming.
• Automate repetitive reporting and data-processing activities using Excel VBA.
• Work with large datasets and ensure appropriate data quality and validation.
• Apply statistical and analytical techniques to support business decisions with data engineers, business analysts, IT teams, and business stakeholders.
• Troubleshoot data and reporting issues and provide timely resolutions.
• Contribute to continuous improvement of reporting and analytics processes.

Skills

Data analytics

Business intelligence

Stakeholder communication

Problem solving

Statistical analysis

Tools

Power BI

SQL

Excel VBA

Job description

Ampstek is seeking an experienced Data Analyst to transform complex datasets into clear, actionable insights and develop robust Power BI dashboards to support strategic planning and operational efficiency.

The role requires deep expertise in Power BI, SQL, and Excel VBA, with a strong understanding of business operations and data-driven decision-making. You will collaborate with stakeholders to deliver analytical solutions and drive organizational growth.