Description
Work with Leadership team to identify performance metrics and targets for services provided. Gather requirements for reporting performance actual to target Identify existing data sources and reporting tools and recommend approach for data capture and reporting. Design, implement, build, test/validate and publish ad hoc and standard reports. Train members of the Division to use reports. Assess results through data investigation, analysis, and evaluation to identify trends and recommend methods of identifying and reporting trends. Create supporting documentation for reports and create detailed documentation outlining report criteria. Prepare summaries and analysis results using graphical representations and professional formatting. Ensure that reports support the overall scope of business strategies. Maintain data integrity and ongoing quality control of delivered reports. Partner with Program Manager to collate forecasting and budget data and generate reports to IT Supervisors.SKILLS:
REQUIRED SKILLS:
MUST HAVE ADVANCED EXCEL SKILLS Including Pivot tables. 3+ years professional experience in data analysis and report design/development. Strong knowledge of reporting programs and tools. Excellent communication and interpersonal skills. Advanced MS Excel Skills to include use of advanced functions (IF, AND, VLOOKUP, FORECAST, ARRAY), Create PivotTables to consolidate data, Import & export data. Create and manage Scenarios, use Microsoft Query and Web Query tools, Create macros. Successful candidate will know when to use these functions and will consult with teams to understand what reports are needed and will work to build needed reports. Must be able to create pie charts, graphs and bar charts to demonstrate inventory levels, planned to actual spend and other budgetary data (assets, liabilities, equity, income and expenses). Must understand assets vs. liabilities, expense vs capital, invoicing, general ledger concept and other basic bookkeeping/accounting principles. Must be highly organized, self directed and able to meet deadlines. Must have strong communication skills and work well in teams. Strong analytic and problem solving skills and abilities. Demonstrate strong communication (both verbal and written), and customer service skills. Ability to translate data to information and communicate in simple terms
DESIRED SKILLS:
Experience working with business process analysis, predictive modelling, analytic reporting, segmentation analysis or data visualization. Bachelors degree in MIS, Business Intelligence or equivalent work experience. In-depth knowledge and experience with relational database concepts and query tools. Sound knowledge of SQL and data extraction methodologies. Experience in IT, Call Center Management, or related industry preferred. Intermediate level of programming knowledge and of relational databases, database structures and design, systems design, data management, data warehouse. Intermediate level proficiency in MS Access and PowerPoint.