Data Steward & Data Engineer

Merck • Rahway, NJ

1d • Hybrid

About The Position

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.

Requirements

• Bachelor’s degree Required in Computer Science or Engineering
• 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.
• 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.
• Account Management
• Business Intelligence (BI)
• Dashboard Reporting
• Data Analysis
• Data Governance
• Data Management
• Data Modeling
• Information Technology (IT) Support Services
• Master Data Management (MDM)
• Oracle Database
• Quality Management

Nice To Haves

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

Responsibilities

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

Benefits

• medical, dental, vision healthcare and other insurance benefits (for employee and family)
• retirement benefits, including 401(k)
• paid holidays
• vacation
• compassionate and sick days

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level