Senior Business & Systems Analyst

Senior Business & Systems Analyst

As an integral part of a dynamic Information and Business Transformation team, the successful candidate will be responsible for providing business intelligence (BI) including geospatial analysis and data services for turning data into critical information and insights that can be used for making sound business decisions.

Major Responsibilities

• 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.

Business Intelligence

• 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.

Data Science

• 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.

Freedom Of Information Requests And Open Data

• 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.

Key Qualifications

Your application must describe your qualifications as they relate to:

• Post-secondary education in Information Management, Information Technology, Business, Public Administration or other discipline pertinent to the job function, or an equivalent combination of education and experience.
• 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.

Key skills/competency

• Business Transformation
• Data Analytics
• Business Intelligence (BI)
• ETL Processes
• Geospatial Analysis (GIS)
• Data Visualization
• Stakeholder Management
• Process Optimization
• SQL Server/Oracle/MySQL
• Qlik/SAS BI/Tableau