Senior Specialist Data Management & Reporting
USA - New Jersey - Rahway
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 …
This job isn't fresh anymore!
Search Fresh JobsJob Profile
Hybrid Hybrid work model
Benefits/PerksFlexible work arrangements Hybrid work Hybrid work model Insurance Meetings Paid holidays Retirement benefits Sick Days Vacation
Tasks- Business intelligence
- Collaboration
- Data Management
- Data visualization
- Innovation
- Reporting
Analytical AWS AWS Redshift Business Intelligence Business Operations Collaboration Commercial Computer Science Continuous Improvement Data Database Development Data Management Data Stewardship Data Visualization Design Distribution Engineering Finance Informatica Innovation IT Management Manufacturing Marketing PL/SQL Power BI Problem-solving Programming Quality Redshift Reporting Research Sales Spotfire SQL Technical Troubleshooting Validation Visualization Tools
Experience7 years
EducationBachelor's degree Business Computer Science Engineering Finance IT Management Marketing Science
Certifications TimezonesAmerica/Anchorage America/Chicago America/Denver America/Los_Angeles America/New_York Pacific/Honolulu UTC-10 UTC-5 UTC-6 UTC-7 UTC-8 UTC-9