Master data analyst for CRM

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.

• Design, 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.
• Implement 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.
• Maintain 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.
• Maintain 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.
• Set 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.
• Identify 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.

• Third-level qualification (Bachelor's degree or equivalent) in Data Analytics, Computer Science, Information Systems, Business Analytics, Engineering, Mathematics, or a related field.
• 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.
• Будет плюсом: Experience with Python or R for data manipulation and automation

• Условий в вакансии нет