Lexmark creates innovative imaging solutions and technologies that help customers worldwide print, secure and manage information with ease, efficiency and unmatched value.
What we offer :
Competitive pay and benefits package
Diverse and inclusive workforce
Dynamic and collaborative team environment
Environmental excellence and community support.
Sound intriguing? Open the possibilities to joining our team and apply today!
Responsible for maximizing revenue with existing customers by understanding customer demand and managing all operational aspects for customers.
Analyzes customer forecasts and historical shipment records to detect changes in demand. Contacts customer to discuss demand trends and maximize sales of products.
Monitors inventory levels and shipment activity.
DATE LAST UPDATED : MAY 2017
UPDATED BY : Reah Yu
JOB / BUSINESS TITLE :
Business Intelligence Analyst CDM
Business Area :
ISS SALES AND MARKETING - CSSC
Sales and Marketing Operations
Channel and Operation Reporting
Job Role : Range of Level :
Range of Level : Reports To :
Reports To : Direct Reports, If Any :
Direct Reports, If Any :
Indirect Reports, If Any :
Annual Budget : Location :
Business Intelligence Analyst
DO NOT FILL OUT THIS LINE ITEM)
Business Intelligence Manager Channel and Operation Reporting
Lexmark Cebu Shared Service
JOB PURPOSE / MISSION / SUMMARY :
CDM Team is responsible for the collection, correction of errors in the CDM Portal, completeness and timeliness of channel reported data (sales out, inventory and retail reports) by doing analysis, validation and cleansing.
This is a significant aspect for Lexmark to make sound decisions related to sales, accuracy in commissions, sales and marketing analysis and forecasting and rebates payout.
KEY ROLES & RESPONSIBILITIES / KEY JOB FUNCTIONS :
Setup of new reporting partners. This includes the creation of the profile and the mapping of the data provided to the Global Template.
This will first be done in QA so we can verify the partner can provide the data consistently in a set format and so the country can validate the data provided.
Once verified the same setup will be done in production. The setup will involve working directly with the partners and country key users.
Daily monitoring to verify the partners reporting match what was expected.
Follow up with partners when they do not report when expected and research any unexpected files that are reported. The follow up and research will involve working directly with the partners and country key users.
Conducts daily cleansing of data errors. Errors can be solved through systematic research from available search engines, the MDM master data and SAP transactional data.
Analytical thinking is key in successful and efficient data cleansing ensuring relevant data coincides with each other from limited data sources.
In some situations it will involve working directly with the partners and country key users.
Analyzing data with standard methods, interpreting the results, and ensuring high quality & integrity of the data collected.
As issues are identified rules can be setup that fix data quality issues automatically. Examples of these are part substitution rules, removal of prefixes and removal of suffixes.
Timely escalation of data anomalies to partners and country key users especially involving large data source.
Participates in ongoing decisions concerning data collections and data analysis.
Ensure quick coordination and problem resolution of all CDM data issues. Timing is essential as it affects timely rebate / commissions processing and accuracy of channel performance reports.
Periodic review of the data quality and partner scorecards reports to determine specific partner action plans to improve data collection.
Enrich reported data to correct and ensure accurate party and transaction data. Analysts has to have knowledge on promotions, country rule on these promotions and as well as party structure on an MDM aspect.
Does investigation if CDM data is missing / not integrating into the business objects and or if there are discrepancies on the data in BO and the raw file provided by the partner
Conducts regular GT mapping audit and Serial number audit.
Conducts regular volume analysis identifying quantity fluctuations and conducts further investigation if there are abnormal increases / decreases.
Periodic preparation of partner scorecard
COMPETENCIES, SKILLS, KNOWLEDGE & ABILITIES :
Understanding of Lexmark path to market structure.
Understanding Channel Partner Management process.
Knowledge in reporting and rebates management.
Analytical Skills : Data analysts work with large amounts of data : facts and figures. You will need to see through the data and analyze it to find conclusions.
Communication Skills : Data analysts are often called to present their findings, or translate the data into an understandable document.
You will need to write and speak clearly, easily communicating complex ideas.
Critical Thinking : Data analysts must look at the numbers, trends, and data and come to new conclusions based on the findings.
Attention to Detail : Data is precise. Data analysts have to make sure they are vigilant in their analysis to come to correct conclusions.
Must be fluent in both written and speaking English, Spanish and Portuguese language
Oral (Conversational & Public Presentation) & Written Communication
Ability to work effectively and efficiently in a cross-functional, cross-geography working environment
Ability to show initiative, good judgment, and resourcefulness.
Must value operating in a collaborative and cooperative environment.
EDUCATION, EXPERIENCE & CERTIFICATIONS BASIC REQUIREMENTS :
Education : Preferably a graduate of Bachelor of Science, with focus on business related discipline.
Experience : Minimum 1 year relevant work experience.
Licenses & Certifications : no minimum requirement
ORGANIZATIONAL CHART (COPY / PASTE ORG CHART) :
CAREER PROGRESSION :
Successful assignment can lead to lateral movement to COE Functions or to vertical progression such as Team Lead role in any finance department, or change in career within Lexmark CSSC organization.
WORKING CONDITIONS :
Must be agreeable to working off shift
Limited international travel will be required (20%-30%)
Able to work on any Lexmark geographical time zone.
Office setup and occasional offsite (during travel)