Sales Enablement Data & Automation Specialist

Merck

Sydney

On-site

AUD 110,000 - 165,000

Full time

2 days ago

Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Flexible work arrangements

Job summary

Merck, a global Animal Health leader, seeks a Sales Enablement Data & Automation Specialist in Sydney/Macquarie Park. You will drive data-informed decisions by migrating dashboards to Power BI, automating workflows, and integrating data from SAP, Salesforce, Oracle, and Redshift.

Join a collaborative team with growth opportunities and flexible work arrangements. The role focuses on dashboards, SIP data management, automation, data quality, and stakeholder collaboration to enhance sales

Qualifications

Bachelor's degree in Economics, CS, 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

Dashboard development and migration from Spotfire to Power BI.
Design and maintain territory target templates and integrate data into dashboards.
Identify and automate manual tasks in Customer Effectiveness and related processes.
Extract, transform, and load data from SAP, Salesforce, Oracle, Redshift into reporting platforms.
Collaborate with Sales Ops, Finance, and BU partners to deliver solutions.

Skills

Business analytics

Data engineering

Problem solving

Collaboration

Education

Bachelor's degree in Economics, CS, Engineering, or related field

Tools

Power BI

SQL

SAP

Salesforce

Oracle

Amazon Redshift

Databricks

Python

Power Automate

RPA

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.

Required Skills