Senior Business & Systems Analyst

Role Overview

• Leads Business Transformation by working together with business stakeholders and recommending strategies to achieve business change
• Provides client-driven, value-added business consulting expertise to a portfolio of diverse projects in the division
• Provides analysis results and proposal recommendations to stakeholders; chairs meetings and promotes systematic discussion of complex topics
• Leads continuous improvement initiatives from concept through to implementation and benefit realization
• Builds strong relationships with team members and establishes partnerships with senior business stakeholders
• Participates in the hiring of resources, motivates and coaches team members, ensuring effective teamwork, high standards of work quality and organizational performance
• Achieves a high degree of client satisfaction by identifying user problems/needs and recommending solutions
• supported by clear documentation that is understood by both business and technical audiences
• Recommends business solutions that optimize the user experience and satisfy stakeholder needs, continually exploring and assessing options for value-add for users
• Identifies, analyzes, rationalizes and optimizes business processes in an agile manner by interviewing, documenting and facilitating business process review
• Conducts research into assigned area ensuring that such research takes into account developments within the field, corporate policies and practices, legislation and initiatives by other levels of government
• Prepares reports to management supporting recommendations on changes in technology solutions, business methods and business processes including appropriate staffing levels and resource allocation
• Lead development of Extract, Transform, Load (ETL) processes, and tools
• Design, build, test and deploy BI/GIS system improvements
• Analyze user requirements and based on findings, design functional specifications for BI/GIS front-end applications
• Develop sematic layer, metadata, reports, report definitions, visualizations for requested projects
• Develop and maintain technical or procedural documentation
• Provide and apply quality assurance best practices
• Create informative visualizations that intuitively display large or complex data relationships
• Collaborate with teams to design data warehouses, data mining or analytic architectures, master data development, data analysis methodologies, predictive models, or other data related strategies to solve critical business problems
• Acquire data from primary or secondary data sources or leverage existing data sets to create new data assets and maintain assets according to established business rules and data governance practices
• Assist with improving data quality through use of data analysis and tools
• Create queries and supply statistical data to fulfill information requests
• Organize, supply and maintain datasets for Open Data portal or other public facing
• Ensure products comply with organizational policies and laws such as PHIPA, MFPIPA and FIPPA

Requirements

• Post-secondary education in Information Management, Information Technology, Business, Public Administration or other discipline pertinent to the job function
• Considerable experience in data analytics, creating dashboards, and data visualizations
• Considerable experience using relational database management systems (e.g. Microsoft SQL Server, Oracle Database, MySQL, etc.), and business intelligence tools (e.g. Qlik, SAS Business Intelligence, Tableau, etc.)
• Experience using MS Office (Word, Excel, etc.) and Visio
• Post-graduate degrees in analytics are considered an asset
• Knowledge in paramedicine, communication centre operations, or supply chain management is considered an asset
• Extensive analytical conflict resolution and problem-solving skills
• Ability to prepare, organize, and present project documentation to senior management (e.g. business cases, feasibility study, project plans, cost benefit analysis, etc.)
• Project management experience considered an asset

Tech Stack

• ETL
• MS SQL Server
• MySQL
• Oracle
• SQL
• Tableau

Benefits

• Health insurance
• Retirement plans
• Paid time off