Sales Enablement Data & Automation Specialist

MSD; Sydney; Hybrid; AUD 110,000 - 150,000; Full time

Benefits offered by this job

Flexible work arrangements

Job summary

MSD in Sydney is seeking a Sales Enablement Data & Automation Specialist to drive data-driven decisions by building Power BI dashboards, automating workflows, and managing sales performance data. Location options include Macquarie Park, Sydney and Murarrie, Brisbane.

The role emphasizes accuracy, collaboration, and improving sales responsiveness. You will migrate dashboards, automate processes, and integrate data from multiple systems to support sales operations and Finance partners.

Qualifications

• Bachelor’s degree in Economics, Computer Science, Engineering, or related field.
• Proficient in SQL, Power BI, Cloud Solutions, Databricks, Python.
• Experience in business analytics and data engineering projects.
• Ability to manage large datasets with high accuracy.

Responsibilities

• Lead migration of dashboards from Spotfire to Power BI and refine requirements with Sales Ops and NSMs.
• Design and maintain territory target templates using historical data and budgets.
• Automate manual tasks in Customer Effectiveness and price/rebates/order processing.
• Extract, transform, and load data from SAP, Salesforce, Oracle, Redshift into reporting platforms.
• Collaborate with Finance, IT, Sales Ops, and BU partners to deliver solutions.

Skills

Power BI

SQL

Python

Databricks

Cloud Solutions

Data analytics

Sales operations data

Data integration

Education

Bachelor’s degree in Economics, Computer Science, Engineering, or related field

Tools

SAP

Salesforce

Oracle

Amazon Redshift

Job description

Job Description Sales Enablement Data and Automation Specialist Join a trusted global leader in Animal Health and take your career in a new direction. Permanent, full-time role with competitive remuneration and benefits.

Location: Macquarie Park, Sydney, alternatively Murarrie, Brisbane, Australia.

Career growth: Expand your expertise in a growing, successful industry as part of a collaborative team. Professional development: Gain valuable experience in a dynamic, evolving role.

The Sales Enablement Data & Automation Specialist is responsible for enabling data-driven decision-making and operational efficiency through the development and maintenance of Power BI dashboards, automation of manual workflows, and management of sales performance data.

This role supports sales operations by delivering accurate, timely reporting and automating processes that improve sales effectiveness and customer responsiveness.

What You Will Do

• Dashboard Development & Migration
  • Lead migration of Spotfire dashboards to Power BI, refining requirements with Sales Operations and National Sales Managers
  • Develop and maintain scalable dashboards delivering actionable insights across business units
• Sales Incentive Program (SIP) Data Management
  • Design and maintain territory target templates based on historical sales and budgets
  • Upload and integrate target data into dashboards for accurate performance tracking
  • Collaborate with Finance and BU partners to align and finalize territory targets
• Automation & Process Improvement
  • Identify and automate manual tasks in Customer Effectiveness, including data management, pricing, rebates, and order processing
  • Partner with Customer Effectiveness Manager to prioritize and implement automation solutions
• Data Integration & Quality Assurance
  • Extract, transform, and load data from SAP, Salesforce, Oracle, Amazon Redshift, and other sources into reporting platforms
  • Ensure data accuracy, security, and documentation standards
  • Maintain master data processes and definitions within the data ecosystem
• Stakeholder Collaboration
  • Work closely with Sales Operations, Customer Effectiveness, Customer Care, Finance, IT, and Regional FFE teams to gather requirements and deliver solutions
  • Act as a trusted technical advisor within the Customer Effectiveness team

What You Must Have

• Qualifications & Skills
  • Bachelor’s degree in Economics, Computer Science, Engineering, or related field
  • Proficient in SQL, Power BI, Cloud Solutions, Databricks, Python
  • Experience in business analytics and data engineering projects
  • Ability to manage large datasets with high accuracy
• Essential
  • Proven hands‑on experience with Power BI dashboard development and SQL querying
  • Strong knowledge of SAP, Salesforce, Oracle, and Amazon Redshift environments
  • Experience automating business processes using RPA, Power Automate, or similar tools
  • Demonstrated ability to manage complex data integration and reporting projects
  • Excellent problem‑solving, attention to detail, and collaboration skills
• Desirable
  • Experience in sales operations or commercial data environments
  • Familiarity with sales incentive programs and territory target setting

What You Can Expect

• Autonomy with strong support in a trusted global Animal Health organisation
• Opportunities to upskill and develop your role
• Flexibility and pathways to broaden your skills and career
• Collaborative team environment with like‑minded professionals

Physical Environment & Tools/Equipment Utilised

• Flexible work arrangements supported
• Primarily office‑based with regional interaction and occasional local, interstate, and international travel

We are proud to be a company that embraces the value of bringing diverse, talented, and committed people together. The fastest way to breakthrough innovation is when diverse ideas come together in an inclusive environment. We encourage our colleagues to respectfully challenge one another’s thinking and approach problems collectively. We are an equal opportunity employer, committed to fostering an inclusive and diverse workplace.

Additional location(s) Compensation Information

• Required Skills
  • Ability to Coordinate
  • Audit Trails
  • Automation
  • Business Analysis
  • Business Informatics
  • Competency Management
  • Cost Efficiency
  • Customer Management
  • Dashboard Reporting
  • Data Integrity
  • Emerging Technologies
  • Incentive Compensation
  • Operational Efficiency
  • Performance Dashboards
  • Product Management
  • Requirements Management
  • Sales Performance
  • Solution Architecture
  • Solution Deployment
  • Solutions Delivery
  • Solutions Development
  • Stakeholder Relationship Management
  • Technical Advice
  • Workflow Automation

Employee Status: Regular

Relocation: No relocation

VISA Sponsorship: No

Travel Requirements: No Travel Required

Flexible Work Arrangements: Hybrid Shift: Not Indicated

Valid Driving License: No

Hazardous Material(s): N/A

Merck & Co., Inc., Rahway, NJ, USA, also known as Merck Sharp & Dohme LLC, Rahway, NJ, USA, does not accept unsolicited assistance from search firms for employment opportunities. All CVs / resumes submitted by search firms to any employee at our company without a valid written search agreement in place for this position will be deemed the sole property of our company. No fee will be paid in the event a candidate is hired by our company as a result of an agency referral where no pre-existing agreement is in place. Where agency agreements are in place, introductions are position specific. Please, no phone calls or emails.

Job Posting End Date: 11/21/2026 *A job posting is effective until 11:59:59PM on the day BEFORE the listed job posting end date. Please ensure you apply to a job posting no later than the day BEFORE the job posting end date.

Our company is a global health care leader with a diversified portfolio of prescription medicines, vaccines and animal health products. The difference between potential and achievement lies in the spark that fuels innovation and inventiveness; this is the space where we have codified our legacy for over a century. Our success is backed by ethical integrity, forward momentum, and an inspiring mission to achieve new milestones in global healthcare.