Data Steward & Data Engineer

Job Description

Job Description

Overview:

This role will work cross-functionally with a variety of areas to maximize the value the Operations Data Layer provides to the organization. This includes helping to facilitate and comprehend requirements defining solution functionality designing solutions as well as developing and enhancing solutions over time. The Team member will be hands-on and have demonstrated experience developing and maintaining the central data repository in support of multiple species for all data integration and business intelligence needs.

Data Engineering Support:

• Elaborate Requirements Data Validation UAT and work with IT to build data views for use by all downstream applications like Dashboards mobile applications EDI data support Days of Supply and Analytics dashboards

• Provide requirements to IT for building backend objects that are required for business analysts and pricing team.

• Work with the team-lead on building and maintaining the self-service operations data layer that acts as a central repository for all Data Warehouse and Business Intelligence needs.

Dashboards and Reporting:

• Support dashboards in self-service mode - Planning / Development & Production Enhancement Requirements / User training / Co-ordination to align with business priorities.

• Perform UAT Provide feedback to IT for seamless migration of dashboards from On Premise to Cloud

• Develop Ad hoc business reports for Sales Marketing Finance and other teams through Spotfire PowerBI

Data Governance and Monitoring:

• Work with data management team lead to implement data governance standards and to build business / technical lineage with Collibra.

• Define Business Terms / Acronyms / Processes / various dashboards. Link above business assets for traceability / lineage and make them available for business consumption.

• Monitor data quality report and work proactively with IT on data issues as part of daily reconciliation process.

• Check the accuracy of the master and operational data which impacts dashboard reporting.

Data Management - Master Data Repository:

• Work with the strategic account managers and maintain the customer list for various corporate accounts

• Maintain Standard pricing across all species at multiple Units of Measure and load all Special pricing programs across species by UIN from PROS

• Manage the sales quota to support the Sales Rep Incentive programs

• Develop 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 accountable for Master data updates and enhancements especially with data shared with external partners like Proagrica and Celeritas

• Provide accurate Roster data from MDR for Customer Link Portal and update changes from Portal in MDR

• Develop Data feeds from Animal Health Data Platform in Databricks to Informatica Customer MDM in collaboration with IT

• Provide UAT support when the MDR goes through upgrade or other design changes as proposed by IT

Database Development and Reporting:

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

• Create and automate SQL scripts for providing reports/ data to internal (Sales Marketing Finance Audit)/external partners for Margin/Rebate calculation and Pricing Portal for Distribution

• Develop scripts for generating Gross to Net files for SAP upon Pricing updates.

Education:

Bachelors degree Required in Computer Science or Engineering

Required Skills and Experience:

• 10 years of relevant work experience.

• Experience working with databases such as Databricks AWS Redshift Oracle and with tools and applications such as SQL Loader Toad SQL Workbench for AWS Redshift SQL Developer for Oracle.

• Ability to use IDMC to integrate data across source systems.

• Ability to build Spotfire and Power BI Dashboards.

• Experience in Animal Health industry including business knowledge of EDI / AHN processes.

• Sales / Marketing tasks and good understanding of Sales data elements is a plus.

• Ability to work independently and within a team and direct the resolution of highly complex or unusual business problems.

• Excellent communication relationship and leadership skills are required.

• Proficiency in using Programming Languages such as SQL PL/SQL Oracle DDL Unix Shell Scripts Knowledge of Oracle Databases and Proficient in Data Modeling tools like Erwin.

• Exposure to Windows Linux and Unix Operating Systems

• 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.

• Provide relevant inputs on solution requirements and solution recommendations.

• Manage the implementation of new enhancements Prioritize tasks and activities for provisioning data via Dashboards or other backend data views.

• Assist other team members to develop reports and dashboards and to assist the business and Serve as a subject matter expert.

• Remain current on new features and functionality of PowerBI and Spotfire product lines and provide recommendations for process improvements. Evaluate those capabilities for their business benefit.

• 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 and team.

Required Skills:

Preferred Skills:

Current Employees apply HERE

Current Contingent Workers apply HERE

US and Puerto Rico Residents Only:

Our company is committed to inclusion ensuring that candidates can engage in a hiring process that exhibits their true capabilities. Please click here if you need an accommodation during the application or hiring process.

As an Equal Employment Opportunity Employer we provide equal opportunities to all employees and applicants for employment and prohibit discrimination on the basis of race color age religion sex sexual orientation gender identity national origin protected veteran status disability status or other applicable legally protected a federal contractor we comply with all affirmative action requirements for protected veterans and individuals with disabilities. For more information about personal rights under the U.S. Equal Opportunity Employment laws visit:

EEOC Know Your Rights

EEOC GINA Supplement

We are proud to be a company that embraces the value of bringing together talented and committed people with diverse experiences perspectives skills and backgrounds. The fastest way to breakthrough innovation is when people with diverse ideas broad experiences backgrounds and skills come together in an inclusive environment. We encourage our colleagues to respectfully challenge one anothers thinking and approach problems collectively.

Learn more about your rights including under California Colorado and other US State Acts

U.S. Hybrid Work Model

Effective September 5 2023 employees in office-based positions in the U.S. will be working a Hybrid work consisting of three total days on-site per week Monday - Thursday although the specific days may vary by site or organization with Friday designated as a remote-working day unless business critical tasks require an on-site Hybrid work model does not apply to and daily in-person attendance is required for field-based positions; facility-based manufacturing-based or research-based positions where the work to be performed is located at a Company site; positions covered by a collective-bargaining agreement (unless the agreement provides for hybrid work); or any other position for which the Company has determined the job requirements cannot be reasonably met working remotely. Please note this Hybrid work model guidance also does not apply to roles that have been designated as remote.

The salary range for this role is

This is the lowest to highest salary we in good faith believe we would pay for this role at the time of this posting. An employees position within the salary range will be based on several factors including but not limited to relevant education qualifications certifications experience skills geographic location government requirements and business or organizational needs.

The successful candidate will be eligible for annual bonus and long-term incentive if applicable.

We offer a comprehensive package of benefits. Available benefits include medical dental vision healthcare and other insurance benefits (for employee and family) retirement benefits including 401(k) paid holidays vacation and compassionate and sick days. More information about benefits is available at can apply for this role through (or via the Workday Jobs Hub if you are a current employee). The application deadline for this position is stated on this posting.

San Francisco Residents Only:We will consider qualified applicants with arrest and conviction records for employment in compliance with the San Francisco Fair Chance Ordinance

Los Angeles Residents Only:We will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of applicable state and local laws including the City of Los Angeles Fair Chance Initiative for Hiring Ordinance

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:

Relocation:

VISA Sponsorship:

Travel Requirements:

Flexible Work Arrangements:

Shift:

Valid Driving License:

Hazardous Material(s):

Job Posting End Date:

*A job posting is effective until 11:59:59PM on the day BEFOREthe listed job posting end date. Please ensure you apply to a job posting no later than the day BEFORE the job posting end date.