Master Data Analyst

2210 embecta Switzerland Sàrl; Madrid; On-site; EUR 45,000 - 75,000; Full time

Job summary

embecta is seeking a Master Data Specialist to own and optimize master data across our international business. You will integrate data from Salesforce, SAP, IQVIA, and other sources into a centralized, trusted environment, drive data quality, governance, and automation, and enhance Power BI and Excel reporting for leadership and regional teams.

You will partner with Commercial Excellence, IT, Finance, and Supply Chain to standardize processes, support Salesforce data management, and explore

Qualifications

• Bachelor's degree in a data or analytics field or equivalent experience.
• Strong Power BI skills with advanced DAX and data modelling.
• Proficient Excel data manipulation and analysis capabilities.
• Working knowledge of Salesforce, IQVIA, SAP and related data systems.
• Excellent problem-solving, communication, and cross-functional collaboration.

Responsibilities

• Design, build, and maintain ETL pipelines linking Salesforce, IQVIA, SAP and more.
• Improve data quality, governance, and data‑quality dashboards across regions.
• Maintain accurate customer master data and account hierarchies in Salesforce.
• Standardize account naming, merge/divestiture handling, and territory mappings.
• Set up Power BI data models and optimize query performance.
• Identify automation opportunities and explore AI features with IT.

Skills

Power BI

Excel

Data analytics

Attention to detail

Communication

Education

Bachelor's degree in Data Analytics, Computer Science, Information Systems, Business Analytics, Engineering, Mathematics, or related field

Tools

Salesforce

IQVIA

SAP

Python/R (Desirable)

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. We are looking for a Master Data Specialist to own and optimize the data foundations that support reporting, analytics, and business decision-making across our international business. You will be responsible for integrating data from Salesforce, SAP, IQVIA, and other key systems into a centralized, trusted, and scalable data environment. This role will lead the management of customer master data, account hierarchies, territory mappings, and reporting structures across more than 100 countries. You will drive improvements in data quality, governance, and automation while enhancing Power BI and Excel reporting capabilities to deliver accurate, actionable business insights. Working closely with Commercial Excellence, IT, Finance, Supply Chain, and regional teams, you will help standardize data processes, support Salesforce data management, and identify opportunities to leverage automation and AI technologies, including Microsoft Copilot. This is an exciting opportunity for a data professional who enjoys turning complex data into meaningful business value.

Key Responsibilities

• Data Integration & Extract, Transform & Load PipelinesDesign, build, and maintain ETL processes connecting Salesforce, IQVIA, SAP, and additional data sources. Develop automated, schedule‑based data pipelines with robust error‑handling and alerting mechanisms. Centralize all locally purchased data assets (e.g., IQVIA) into a single environment Support the Monthly Business Review (MBR) data pipeline and reporting infrastructure.
• Data Cleaning & Quality AssuranceImplement standardized data‑cleaning protocols and validation frameworks. Identify and resolve data‑quality issues at source or within transformation layers. Build and maintain data‑quality dashboards and metrics to monitor ongoing data health across all regions.
• Salesforce & Customer Relationship Management (CRM) Data ManagementMaintain accurate account hierarchies and customer master data in Salesforce. Troubleshoot issues related to Salesforce‑to‑analytics data synchronization. Ensure data consistency across all Salesforce environments and connected systems.
• Account Mapping & Customer Master DataMaintain and update global account hierarchies and territory mappings. Develop and enforce standardized account‑naming conventions across regions. Create and manage account‑to‑cluster mapping tables. Manage account mergers, divestitures, and organizational structure changes.
• Power BI Infrastructure & OptimizationSet up and optimize Power BI data models, using both DirectQuery and Import modes. Create reusable templates and design standards to support scalable Power BI development. Monitor and improve query performance across Power BI datasets and semantic models.
• AI & Automation OpportunitiesIdentify and implement automation opportunities to reduce manual data‑processing workload. Evaluate AI‑enabled features (e.g., Microsoft Copilot) in collaboration with IT to enhance data workflows. Develop scripts or tools to automate repetitive validation and transformation tasks.

Education and Experience

• Third-level qualification (Bachelor's degree or equivalent) in Data Analytics, Computer Science, Information Systems, Business Analytics, Engineering, Mathematics, or a related field.
• Analytics Tools & Platforms Proficiency in Power BI including advanced DAX measures, calculated tables, and complex data‑modelling formulas.
• Strong command of Microsoft Excel for data manipulation, analysis, and model building.
• Working knowledge of the Salesforce ecosystem, including custom fields, workflows, data models, and data‑quality structures.
• Familiarity with IQVIA, SAP, and other data systems commonly used in pharmaceutical and medical device environments.
• Strong problem‑solving mindset with a high level of attention to detail.
• Ability to work independently, prioritize tasks, and manage multiple projects simultaneously.
• Excellent communication skills, with the ability to translate technical concepts into business‑friendly language.
• Collaborative approach to partnering with regional teams, business analysts, and cross‑functional stakeholders.
• Strong documentation discipline and a process‑oriented working style.

Desirable Skills

• Experience with Python or R for data manipulation and automation.

embecta 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. At embecta, a career is more than a job, it is an opportunity to make a meaningful difference in the lives of about 30 million people around the world who depend on our products to manage a chronic condition every single day. As we expand our capabilities, reach, and impact, there’s never been a more exciting time to join us.