Data Analyst - Commercial Operations

Embecta; Cadalso de los Vidrios; Hybrid; EUR 40,000 - 52,000; Full time

Job summary

Embecta, a global medical device company with a 100-year legacy in insulin delivery and diabetes care, is seeking a Data Analyst for Commercial Operations in Madrid. You will turn commercial, market and customer data into insights that inform regional leadership decisions, using Power BI, Excel, SQL and AI tools to improve analytics, reporting and actions.

Responsibilities include analyzing sales and customer performance, designing dashboards and data models, automating repetitive tasks with

Qualifications

• 3–5 years’ experience in data analytics, business analytics or commercial analytics.
• Proven experience analysing commercial, sales or market data and translating findings into actionable business recommendations.
• Strong Power BI capability, including DAX, data modelling and calculated tables.
• Advanced Excel skills, including Power Query, pivot tables and advanced formulas.
• Experience cleaning, combining and analysing data from multiple sources.
• Hands-on experience using AI and automation tools, such as Microsoft Copilot, Power Automate or Power Apps.
• Working knowledge of Salesforce data structures; experience with IQVIA, SAP or similar platforms is an advantage.
• Strong problem-solving and analytical skills with excellent attention to detail.
• Ability to turn ambiguous business questions into structured analysis and clear recommendations.
• Strong communication and data-storytelling skills, with the ability to explain complex information to non-technical stakeholders.
• A proactive, curious and collaborative mindset, with the ability to work independently across multiple priorities.
• Very good command of English.

Responsibilities

• Analyse sales, market share, market size and customer performance to identify trends and opportunities.
• Provide data-backed insights and recommendations to Commercial, Finance and Supply Chain teams.
• Lead ad-hoc analyses on performance drivers, accounts, channels and variances versus plan.
• Design and maintain Power BI dashboards and data models (DAX, DirectQuery and Import).
• Build and streamline Excel models and analyses using Power Query and advanced formulas.
• Prepare market and performance insights for Monthly Business Review and share KPIs with leadership.
• Identify and automate repetitive data and reporting activities using AI/tools; prototype practical AI solutions with IT.

Skills

Power BI

Excel

Data modelling

DAX

AI tools

Python or R

Salesforce data

IQVIA data

SAP data

Data storytelling

Education

3–5 years experience in data analytics

Tools

SQL

Power Automate

Power Apps

Copilot / AI tooling

Job description

embecta is a global medical device company with a 100-year legacy in insulin delivery and diabetes care. Driven by innovation, purpose, and a commitment to improving lives, we are expanding our portfolio of solutions to serve even more patients, healthcare providers, and communities around the world.As Data Analyst – Commercial Operations, you will turn commercial, market and customer data into insights that help drive decisions across embecta’s International business, covering five clusters and 100+ countries.You will analyse business performance, identify the drivers behind the numbers, and translate complex data into clear, actionable insights for regional and leadership teams. You will work with data from Salesforce, IQVIA, SAP and local sources, using Power BI, Excel, automation and AI tools to improve how we analyse, report and use data.This is a great opportunity for a curious, hands-on analyst who enjoys solving business problems, challenging the status quo and finding smarter ways to use data.Key ResponsibilitiesAnalysis, Reporting & InsightsAnalyse sales, Share of Category (SoC), market size and customer performance to identify trends, gaps and growth opportunities.Provide Commercial, Finance and Supply Chain teams with clear, data-backed insights and recommendations.Lead ad-hoc analysis on performance drivers, accounts, channels and variance versus plan.Design, maintain and optimise Power BI dashboards and data models, including DAX, DirectQuery and Import models.Build and streamline Excel models and analyses using Power Query, pivot tables and advanced formulas.Prepare market and performance insights for the Monthly Business Review (MBR) and proactively share key KPIs with leadership.AI & AutomationIdentify and automate repetitive data and reporting activities using tools such as Power Automate, Power Apps, Python or other scripting solutions.Use AI tools, including Microsoft Copilot, to improve analysis, identify anomalies and create reporting commentary.Partner with IT to prototype practical AI solutions and continuously improve analytics processes.Act as a hands-on problem solver for data and reporting needs, taking solutions from idea through to delivery.Data Quality & Account ManagementIntegrate data from Salesforce, IQVIA, SAP and local sources into a trusted analytics environment.Implement data-quality checks, resolve issues at source and monitor data health.Maintain account hierarchies, territory and cluster mappings, and customer master data.Manage account naming standards, mergers, divestitures and organisational changes.Troubleshoot Salesforce-to-analytics data synchronisation and support ongoing data governance.What You’ll Bring3–5 years’ experience in data analytics, business analytics or commercial analytics.Proven experience analysing commercial, sales or market data and translating findings into actionable business recommendations.Strong Power BI capability, including DAX, data modelling and calculated tables.Advanced Excel skills, including Power Query, pivot tables and advanced formulas.Experience cleaning, combining and analysing data from multiple sources.Hands-on experience using AI and automation tools, such as Microsoft Copilot, Power Automate or Power Apps.Working knowledge of Salesforce data structures; experience with IQVIA, SAP or similar platforms is an advantage.Strong problem-solving and analytical skills with excellent attention to detail.Ability to turn ambiguous business questions into structured analysis and clear recommendations.Strong communication and data-storytelling skills, with the ability to explain complex information to non-technical stakeholders.A proactive, curious and collaborative mindset, with the ability to work independently across multiple priorities.Very good command of English.Nice to HaveExperience with SQL, Python or R for analysis or automation.Experience within healthcare, medical devices or pharmaceuticals, particularly with market, sales or customer master data.Travel: No regular travel required.#LI-DF1#LI-HYBRIDembecta is an Equal Opportunity/Affirmative Action Employer. We do not unlawfully discriminate on the basis of race, color, religion, age, sex, creed, national origin, ancestry, citizenship status, marital or domestic or civil union status, familial status, affectional or sexual orientation, gender identity or expression, genetics, disability, military eligibility or veteran status, or any other protected status.