Bus Intelligence Analyst 1- Full-Time- Hybrid-Downsview

Position Description & Qualifications

The Role

We are looking for a motivated, analytical, customer focus, service oriented professional for the permanent position of Business Intelligence Analyst, Reporting and Analytics to interface with operations (front-line staff, Supervisors/Managers, and Support Staff). Work closely and collaboratively with operational managers and support team leaders to identify problem areas, trends, root cause and opportunities for improvement supported by data, and to consult and facilitate on the implementation of process improvements

Analytics:

• Analyzing service performance data and providing accurate and timely management information (root cause, trends, variation) on service delivery against contractual KPI’s;
• Quantitative and qualitative analysis of operational and service delivery data with summarization and action plan recommendations;
• Assess business processes and sources of data to develop new metrics that will influence change

Reporting:

• Timely, accurate and effective reporting of KPI and operational metrics;
• Development of new and improved reports to support operational demand and requests;

Support:

• To the operations: Supervisors, Management, Control Centre Manager and Business Leaders through ad hoc data mining and analysis as required to support improvement initiatives;

KEY RESPONSIBILITIES:

• Understand the overall business operations, developing innovative Control Centre solutions to help improve productivity and meet the contractual KPI’s;
• Provide guidance and support to the organization on procedures, reporting requirements and process improvement;
• Handle and resolve complex data requirements to determine service delivery and customer feedback volume, trends and develop long term strategies with key stakeholders;
• Utilize database to perform updates to scheduling, forecasting and service level databases through basic programming as assigned;
• Collaborate with IT to design, develop, execute, testing and maintenance of applications, data models for reporting and analytical purposes;
• Develop, implement and document the processes, systems and controls for compliance with processes and business needs, detailing all work efforts and knowledge translation to the IT department and support

stakeholder learning;

• Other related duties relevant to this position as may be required
• Comply with all regulations, policies and procedures pertaining to the operations including occupational health and safety, environmental, drug and alcohol, and quality.
• Design, develop and deploy Enterprise BI solutions that leverage common data architecture and data optimization approaches
• Design, develop and deploy interactive data visualizations using Power BI. Analyse complex business problems/data and translate that into visualization
• Create effective Power BI dashboards, reports, and applications utilizing best practices
• Collect and analyse requirements from users across the driver examination services program.
• Incorporate User Feedback to promote analytics self-service and drive adoption
• Collaborate with Power Users to enable Analytics Agility, faster Report Creation and insights
• Perform modelling of data and flows into Data Warehouse
• Understand and maintain the knowledge on Data Warehouse table designs, data definitions, and data integration
• Write complex SQLs queries and develop Microsoft SSIS, SSAS, etc.
• Experience with ETL methodology in performing Data Profiling, Data Migration, Extraction and Transformation. Must have skill to connect to various data sources like database, SharePoint, REST endpoints, Microsoft AD and ability work payloads in JSON, XML etc.
• Excellent analytical and program debugging skills
• Create Training Materials and administer end-user training
• Participate in code reviews – peer and junior.
• Participates in team-based projects, many of which may be matrix managed; must be accustomed to completing deliverables within time and budgetary constraints.
• Mentor junior staff members for career development.
• Work on multiple parallel projects and meet specified deadline and/or milestones

JOB REQUIREMENTS:

EDUCATION /CERTIFICATIONS:

• A bachelor’s degree in computer science or a related field is required, along with at least 2 years of experience in enterprise data warehousing and a minimum of 2 years working with Power BI.

SKILLS/Competencies (Interpersonal Communication, Financial, Managerial, Problem solving):

• Business process transformation, using data