Senior Business Analyst (Excel, Power BI, Cloud)

Department :

PHSA IMITS, Business Systems

Project Description :

PHSA is in search of a Senior Business Analyst (BA) specialized in Application Dependency Mapping. This role involves creating a thorough and accurate representation of dependencies among different components within applications, servers, networks, and storage.

The Senior Business Analyst will support the Cloud Centre of Excellence to support project and various stakeholders within BC Health. In this role you will;

1. Play a pivotal role in creating a comprehensive and precise representation of dependencies among various components within applications.

This includes databases, web servers, APIs, third-party services, and other software modules.

2. Lead in engaging with application owners to ensure accurate mapping and understanding of dependencies. Depending on project size and availability, the BA may oversee multiple customer projects simultaneously.

3. Understanding of application architecture principles and patterns to analyze and map dependencies accurately.

Successful candidates are with strong understanding of business analysis techniques and methodologies, including requirements gathering, process mapping, and stakeholder management.

Preference will be given to analysts with prior government business analyst experience.

Services Required :

• Selected resource will need to perform the following functions : Generate reports and presentation materials using Excel and PowerPoint.
• Collaborate with internal teams to gather requirements and analyze IT systems / applications.
• Map applications to cross-functional business capabilities.
• Create and maintain detailed documentation, including mapping and catalogs.
• Assist in implementing and maintaining the "Application Master Spreadsheet."
• Conduct consulting activities and methodologies for comprehensive application discovery, analysis, and technical / business discussions.
• Provide analytical support to assess the feasibility of application enhancements.
• Verify application functionality by testing versions of applications.
• Ensure consistency and compliance of all components with relevant regulatory, departmental, IT, and corporate standards, policies, and guidelines.
• Utilize expertise in Application Dependency Mapping to analyze how applications impact IT infrastructure and understand their links to other services and infrastructure.
• Possess familiarity with infrastructure architecture, including basic networking, telemetry, compute, hypervisor, operating system, load balancing, and storage.
• Understand application and systems architecture, defining components, interactions, and overall structure, including n-tier, database, and web servers.

Specific Qualifications or Experience Required :

• Previous experience with complex Information Technology (IT) projects
• 8+ years’ experience working as a business analyst in a IT / Cloud capacity
• Proficiency in using Excel for data analysis tasks, including sorting, filtering, and summarizing large datasets.
• Strong understanding of Excel formulas and functions for data manipulation, calculations, and analysis.
• Skill in creating PivotTables to analyze and summarize data dynamically.
• Ability to create various types of charts and graphs in Excel to visualize data effectively.
• Knowledge of data validation techniques in Excel to ensure data accuracy and consistency.
• Proficiency in applying conditional formatting to highlight important data points and trends.
• Familiarity with importing data into Excel from different sources and exporting data to other formats for sharing and analysis.
• Ability to clean and preprocess data in Excel using techniques such as removing duplicates, correcting errors, and standardizing formats.
• Understanding of Excel tables and their advantages for managing structured data efficiently.
• Ability to create data models in Power BI to structure and organize data for analysis.
• Proficiency in using Power Query to clean, transform, and reshape data from multiple sources for analysis. (Nice to have).
• Strong written and verbal communication skills including the ability to produce concise, structured and well written documents and reports
• Highly adaptable and able to work in a fast paced priority driven environment
• Exceptional level of professionalism; personable, approachable, courteous
• Excellent time management, prioritization and organizational skills
• Strong attention to detail including an awareness of downstream effects of actions
• Ability to work independently to meet deliverables and solve problems
• Self-starter, proactive and solution oriented
• Ability to adapt to change and tolerate high stress levels
• Experience working within the Health Authorities is highly preferred

Job 70431