Reporting and Analysis Specialist

"Within the Customer Service Operations Department in the Canon Consumer Imaging Business Unit, we are looking for a Reporting and Analysis Specialist due to the expanding nature of our business. About the opportunityCustomer Service is seeking a highly organized, service-oriented, precision-focused individual who is a team player, and has strong communication and multi-tasking skills. The “European Reporting & Analysis Specialist” will be responsible for supporting the business with accurate, clear reporting and analysis of the Customer Service operations. The position reports directly to the European Customer Service Operations Manager.Key TasksReport Generation - §Any reports, which are required, but not yet developed, must be designed, developed and implemented.§Required monthly, weekly reports/extracts must be generated, checked, and distributed to the necessary recipients.§Ad-hoc reports that are required must be generated, checked, and distributed to the necessary recipients.§Create/maintain report sets. Reports must be formatted, accurate and be contained in the respective report set document. All report sets that are distributed must contain information clear explanations of how data has been calculated, etc.Report Analysis - §Execute comprehensive analysis of the RCC operations, including product trends, ASF repair trends, warranty trends, etc. using the available reports and data.§Support the HelpDesk Operations Specialist and the WebSupport Operations Specialist in analyzing the HelpDesk & WebSupport operations including performance at the 1st, 2nd and 3rd level, product trends, common queries, etc.§Support the department in the analysis of budget data/reports and trends.§Create necessary management presentations required for the communication of data analysis results trends, issues, etc..Reporting System, Tools - §Develop and maintain ‘work-around solution’ for reporting until new solution hardware and software is in place.§Full involvement in the new reporting solution project where in-depth knowledge of the reporting requirements must be known and communicated to the project team.§Train and mentor colleagues to be able to properly use the reporting solution must be the ‘super-user for the CS Dept..Miscellaneous - §Project Support:§Provide any required support in Customer Service related projects.Essential RequirementsThe most important requirements for this position are your enthusiasm and drive for excellence. In addition, the ideal candidates must possess and meet the following requirements:§Fluent English, both written and spoken.§Advanced MS Access skillsUnderstanding of structuring multiple table structuresAbility to write advanced queries within Access and joining tables and field sets - Jet SQL query writing knowledge would also be advantageous although not essential. Understanding of import and export of file formats Plain text parsing, comma separated values, Excel etc.§MS ExcelProficient in multi table excel layouts, workbook / worksheet linking, advanced excel function knowledge including lookups, concatenation, Boolean Logic IF/AND/OR functions etc, conditional formatting, Pivot table creation. Chart Creation. Macro and Visual Basic Knowledge is advantageous but not essential.§Good analytical skills - can interpret business, operational and financial indicators. In-dept understanding on which areas need to be investigated further.§Very good database and query skills.§Excellent Excel and reporting skills.The ideal candidate is…§An experienced Customer Service professional with a successful track record in a multinational company, preferably within Europe in the industry of technical- consumer products, imaging industry, etc.§Has strong experience in reporting and analysis.§Will have performed at a professional level for the last 3 years.Desirable Requir"