Job Description

Data Management and Automation Specialist

• 2-Year Fixed-Term Contract, full-time, with competitive remuneration and benefits

• Location: Wellington - Upper Hutt, New Zealand

• Career growth: Expand your expertise in a growing, successful industry

• Professional development: Gain valuable experience in a dynamic, evolving role

The 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 & Customer enablement by delivering accurate, timely reporting and automating processes.

What You Will Do

Responsibilities include, however not limited to:

Analytics, Dashboards & Reporting

• Migrate and develop scalable self-service dashboards in Power BI (Power Business Intelligence)

• Report and analyse data from CRM (Customer Relationship Management), ERP (Enterprise Resource Planning) and third-party sources

• Maintain data accuracy and a single source of truth

• Support business reviews with dashboards and ad hoc analysis

Administration

• Design templates and algorithms for territory target allocation

• Integrate targets into dashboards and align with Finance and BU (Business Unit) leaders

• Manage SAP (Systems Applications and Products) customer account creation and lifecycle for NZ meeting activation KPIs (Key Performance Indicators)

• Maintain accurate master data across CRM, ERP and finance/rebate platforms

• Manage SIP (Sales Incentive Plan) targets, including allocation templates, dashboards and budget alignment

Automation & Process Improvement

• Identify and automate manual workflows (data, pricing, rebates, reporting)

• Optimise CRM/SAP usage and improve downstream tools and integrations

• Standardise processes, SOPs (Standard Operating Procedures) and training; ensure policy compliance

Data Integration & Quality

• Co-own master data processes and definitions with the Lead

• Manage ETL (Extract, Transform, Load) from SAP, Salesforce, Oracle and third-party sources

• Ensure data accuracy, security, documentation and audit readiness

• Partner with global teams (BSC - Business Service Centre, AR - Accounts Receivable, MDM - Master Data Management, IT) to maintain data integrity, system health and financial alignment

What You Must have

Qualifications & Experience
• Bachelor degree in Economics /Computer Science/ Engineering
• Technical skills: SQL/Power BI/Cloud Solutions/ Data Bricks/ Python
• Solid prior experience in Business analytics and Data Engineering projects
• Ability to work with huge data arrays and significant all-around accuracy in work

Essential:

• Proven hands-on experience with Power BI dashboard development and SQL querying

• Strong knowledge of SAP, Salesforce, Oracle, and Amazon Redshift data environments

• Experience automating business processes using RPA (Robotic Process Automation), Power Automate or similar tools

• Demonstrated ability to manage complex data integration and reporting projects

• Excellent problem-solving skills and attention to detail

• Strong collaboration skills with cross-functional teams

Desirable:

• Experience in sales operations or commercial data environments

• Familiarity with sales incentive programs and territory target setting processes

What You Can Expect

• Work autonomously whilst being supported, encouraged and being part of a trusted Global Leading Animal Health organisation

• Exposure to upskill and develop in your role

• Flexibility and opening doors to other opportunities and skillsets

• Joining a collaborative team of likeminded individuals

We are proud to be a company that embraces the value of bringing talented and committed people together. The fastest way to breakthrough innovation is when 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 workplace.

Required Skills:

Customer Experience Management, Customer Satisfaction Surveys, Customer Service, Customer Service Communication, Data Analysis, Field Sales Support, Industrial Maintenance, Microsoft Office, Order Processing, Promotional Activities, Quota Management, Report Preparation, Sales Data Management, Sales Quotes, Teamwork, Technical Knowledge, Technical Support, Troubleshooting

Preferred Skills:

Current Employees apply HERE

Current Contingent Workers apply HERE

Search Firm Representatives Please Read Carefully
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.

Employee Status:

Temporary (Fixed Term)

Relocation:

VISA Sponsorship:

Travel Requirements:

Flexible Work Arrangements:

Not Applicable

Shift:

Valid Driving License:

Hazardous Material(s):

Job Posting End Date:

03/13/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.