About
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.
Responsibilities
•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.
Requirements
•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.
Nice to have
•Experience with Python or R for data manipulation and automation
Conditions
No conditions stated in the posting.
