REPORTING ANALYST

Position Title: SSC L&D Reporting AnalystNotice Period: 2 months!Principal Responsibilities: (Essential Function)•Design high priority reports in a timely manner•Review, analyze, define and document customer and business reporting requirements•Develop and communicate system documentation and testing scenarios•Design SSRS Report requirements•Experienced with ETL best practices and technologies including Microsoft SQL Server Integration Services (SSIS)/Microsoft Data Transformation Services (DTS)•Knowledge of advanced relational database design concepts•Create ERDs, data dictionaries, process models, specifications, diagrams, and charts•Familiar with query tuning and with evaluating and configuring other DB performance tuning techniques through the use of Indexes, staged data, and other optimization methods•Business Intelligence experience (SSAS, Power BI, etc.) a plus•Utilize MS Visual Studio and TFS in an agile team oriented development environment•Administer all actions associated with learning and development within the designated learning platform using pre-defined procedure templates•Respond to tickets appropriately: Identify, evaluate and prioritize customer problems and complaints•Participate in departmental training activities including training programs in support of new technologies, procedures, and customer service enhancements•Work with departmental staff to promote, develop, and maintain strong customer service values•Escalate unresolved issues to support leads, designated (L&D Client) service group•Interact with internal customers via telephone, e-mail and chat, providing support and problems solving abilitiesJob requirements:• English business fluent (C1 advanced) + other language(s) as appropriate (French, German and/or Spanish)At least two (3) year’s experience using T-SQL (SPROCS, Functions, etc.)At least three (3) year’s experience supporting SSRS ReportsAt least three (3) year’s experience supporting Crystal ReportsAt least three (3) year’s experience developing Business Requirements Documentation (BRD)Experience building SSIS packages a plusExperience with Team Foundation Server, Visual Studio including BIDs, SSDT and GIT a plusExperience with Visio a plusAdvanced communications skillsPC Skills including MS Word and ExcelBasic understanding of the principles, theories, and practices of group dynamics and/or team developmentCan work productively in a global, multi-cultural environmentManage time effectively to handle multiple critical level requestsAdaptable to dynamic environmentAbility to produce under stressful situationsAbility to manage multiple tasks and prioritize work to adhere to deadlines and within identified time framesBehavioural Skills:Client FocusProactively seeks customer feedback and takes appropriate actionConsiders the impact of decisions and actions on the customerEffectively manages customer expectations Commitment to deliver resultTeam WorkingTakes ownership and follows through on team decisions and actionsFlexibilityAdapts to changing circumstances and new information that impacts goals and plans Can play several different roles simultaneously according to the specific situationTakes a positive approach to dealing with changeCreativityAdapts existing solutions for new problems or situations.Demonstrates a personal ability to apply creativity in problem solving.Discusses different aspects of the problems to bring more structure in complex situations.Leadership & Interpersonal SkillsDemonstrates a personal ability to develop and sustain effective working relationships.