Senior Specialist Data Management & Reporting

Job Description

This role will work cross-functionally with a variety of areas to maximize the value the Operations Data Layer provides to the organization primarily in Data Management and Database Reporting. This includes helping to facilitate and understand requirements, defining solution functionality, designing solutions as well as developing and enhancing solutions over time. The Team member role will be hands-on and have demonstrated experience in maintaining the Reference/Master data in support of multiple species for all Sales Reporting and Business Intelligence needs.

Data Management:

• Be the Customer Master Data Steward for mapping customers internally and assist in deduplication of customer data in IT tool Informatica

• Be the data steward or work directly with other data stewards to ensure data integrity of commercial data across sales/customer platforms/systems

• Troubleshoot and recommend any fixes for downstream applications

• Support and enhance existing PL/SQL Stored Procedures and Functions for automating the loading and validation of all Master data entities in the centralized Master Data Repository

• Develop and execute automated scripts to provide data and context to incoming field requests from Salesforce system

• Be responsible for Master data updates and enhancements especially with data shared with external partners

• Maintain Standard pricing across all species at multiple Units of Measure

Database Development and Reporting:

• Build Database views for master data and sales reporting via internal applications and data visualization tools

• Support Spotfire/Power BI dashboards in self-service mode primarily fixing data issues and enhancing backend database views in collaboration with IT

• Create and automate SQL scripts for providing reports/ data to internal (Sales, Marketing, Finance) and Pricing Portal for Distribution

• Create UNIX scripts for automating delivery of operational reports

Education:

• Bachelor’s degree Required in Computer Science or Engineering

Required Skills and Experience:

• At least 7 years of relevant work experience

• Experience working in tools and applications such as SQL Loader, Toad, Workbench for AWS Redshift, SQL Developer for Oracle

• Proficiency in using Programming Languages such as SQL, PL/SQL, Oracle DDL, Unix Shell Scripts

• Knowledge of Oracle Databases

• Exposure to Data Stewardship tools like Informatica

• Strong troubleshooting, analytical and problem-solving skills balanced with a creative mindset

• Ability to facilitate continuous improvement efforts collaboratively with team and peers

• Self-starter and be able to handle multiple tasks and priorities

• Work collaboratively across teams to design and build solutions with the IT department

• Provide support to other team members to trouble shoot and resolve data related issues

• Provide end user support for handling data accuracy and quality related questions and for escalating technical issues to appropriate IT support individuals

NOTICE FOR INTERNAL APPLICANTS

In accordance with Managers' Policy - Job Posting and Employee Placement, all employees subject to this policy are required to have a minimum of twelve (12) months of service in current position prior to applying for open positions.

If you have been offered a separation benefits package, but have not yet reached your separation date and are offered a position within the salary and geographical parameters as set forth in the Summary Plan Description (SPD) of your separationpackage, then you are no longer eligible for your separation benefits package. To discuss in more detail, please contact your HRBP or Talent Acquisition Advisor.

Employees working in roles that the Company determines require routine collaboration with external stakeholders, such as customer-facing commercial, or research-based roles, will be expected to comply not only with Company policy but also with policies established by such external stakeholders (for example, a requirement to be vaccinated against COVID-19 in order to access a facility or meet with stakeholders).  Please understand that, as permitted by applicable law, if you have not been