This role will be a part of a larger project responsible for cleaning the Master Data in the company?s ERP (Oracle) and organizing the customers into multiple customer hierarchies for loading to the CRM. This role will interact with individuals across multiple international regions (primarily US, EU, LATAM) in order to develop a complete understanding of customer (hospital) mapping into IDN?s and tender authorities. The responsibilities of this role will be organized around 2 projects:
1) Clean up of the Customer Master Data
a. This role will be required to work with/manipulate large amounts of data, helping to identify and clean redundant customer master records as a part of a clean-up of the customer hierarchy.
2) Mapping of the customers into Multiple Customer Hierarchies
a. This role will interact with the sales operations teams in each region in order to understand and capture customer attributes (i.e. territory and IDN Mgm?t) which will be required for the creation of customer hierarchies.
Success for this role will be defined by delivering a cleaned customer hierarchy, tagged with all necessary customer attributes, and organized into the newly created customer hierarchies.
Key responsibilities will include
? Manages, analyzes, and resolves data initiative issues and manages revisions needed to best meet internal and customer requirements while adhering to published data standards.
? Assists in data management, governance, and data quality of master data requirements with other functional data owners to ensure functional master data integrity across the operation of financial systems is consistent and meets stated business rules and requirements.
? In collaboration with subject matter experts and data stewards, helps define and implements data strategy, policies, controls, and programs to ensure the Customer data is accurate, complete, secure, and reliable.
? Provides assistance in resolving data quality problems through the appropriate choice of error detection and correction, process control and improvement, or process design strategies collaborating with subject matter experts (SMEs) and data stewards.
? Work closely with the business/IT to ensure alignment of master data rules and the operations of the application meet all requirements.
? Assists in the application and implementation procedures of data standards and guidelines on data ownership, coding structures, and data replication to ensure access to and integrity of data sets.
? Conducts data cleaning to rid the system of old, unused data, or duplicate data for better management and quicker access.
? Develops and implements strategies to translate business requirements and models into feasible and acceptable data warehouse designs to ensure that business needs are met.
Qualifications: ? Position requires a BA or BS in Business Administration, Finance, or IT
? Excellent analytical, organizational, and communication skills.
? Ability to synthesize large amounts of complex data into meaningful management reporting in order to provide regular project updates to senior management
? Expert/Advanced skill level in Microsoft Access or Excel with 3+ years Proficiency (2003-2010, VBA, SQL)
?Experience with ERP, master data, customer hierarchies, and CRM applications a plus.