Senior Analyst, Business Automation
About the role
The Senior Analyst is responsible for building dashboards, reports, and other tools within the Automation portfolio project workstreams within a Program or Project Portfolio. The Senior Analyst effectively partners with Program Managers and Business Leads to gather requirements, build the dashboards and reports, and maintain existing reporting tools.
Responsibilities
- Champions a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge.
- Leads and drives a customer focused culture throughout their team to deepen client relationships and leverage broader Bank relationships, systems and knowledge.
- Partner with technology and program managers to integrate timelines and deliverables into project plans, create business requirement documents, test scripts, user acceptance testing, project artifacts, identify risks / issues / dependencies and obtain signoffs.
- Manage quality control / assurance testing process, issue reporting /resolution and sign-off / approval of project milestones and deliverables.
- Develop clear and concise dashboards and presentations that speak to the level of the consumer / audience.
- Provide clear updates for automation projects that support efficient and effective delivery while maintaining adherence to internal project management standards.
- Keep day-to-day activities in a manner consistent with the Bank's risk culture and the relevant risk appetite statement and limits. Communicates the Bank's risk culture and risk appetite statement throughout their teams.
- Champions a high-performance environment and implements a people strategy that attracts, retains, develops and motivates their team by fostering an inclusive work environment, communicating vison/values/business strategy and managing succession and development planning for the team.
Requirements
- Minimum of a bachelor's degree in business, finance, technology or related field.
- Must be a power user of Power Bi and Power BI Report Builder.
- Must have strong knowledge of relational databases, data modeling and using unstructured data.
- Ability to import to Power BI from multiple data sources – Excel, SharePoint, SQL and Access.
- Must have an understanding of “O Data” and how it connects to the MS Office Suite.
- Understanding of how to administer the SharePoint access and setup subsites and lists.
- Worked with Power Apps and Power Automate
- Ability to pull down SharePoint lists in Excel and Power BI.
- Understanding of linking data to MS Project and SharePoint.
- Knowledge of the development lifecycle a plus.
- Strong oral and written communication skills, with ability to effectively communicate with both technical and non-technical audiences at various levels within the organization...
- Effectively manage competing workloads and expectations where priorities can often change
Qualifications
- Minimum of a bachelor's degree in business, finance, technology or related field.
- Must be a power user of Power Bi and Power BI Report Builder.
- Must have strong knowledge of relational databases, data modeling and using unstructured data.
- Ability to import to Power BI from multiple data sources – Excel, SharePoint, SQL and Access.
- Must have an understanding of “O Data” and how it connects to the MS Office Suite.
- Understanding of how to administer the SharePoint access and setup subsites and lists.
- Worked with Power Apps and Power Automate
- Ability to pull down SharePoint lists in Excel and Power BI.
- Understanding of linking data to MS Project and SharePoint.
- Knowledge of the development lifecycle a plus.
- Strong oral and written communication skills, with ability to effectively communicate with both technical and non-technical audiences at various levels within the organization...
- Effectively manage competing workloads and expectations where priorities can often change
Skills
- Power Bi and Power BI Report Builder
- Relational databases, data modeling and unstructured data
- Multiple data sources (Excel, SharePoint, SQL and Access)
- “O Data” and MS Office Suite
- SharePoint administration and setup
- Power Apps and Power Automate
- Excel and Power BI for data manipulation
- MS Project and SharePoint integration
- Development lifecycle knowledge
- Effective communication skills
- Managing competing workloads and priorities
Benefits
At Scotiabank, we offer a comprehensive benefits package that includes:
- Flexible working arrangements
- Health and wellness programs
- Retirement savings plans
- Professional development opportunities
- Community involvement initiatives
- Wellness programs
Pay
Competitive compensation and benefits package.
Schedule
Full-time position.
Company Information
We are committed to investing in our employees and helping you continue your career at Scotiabank. Scotiabank is a leading bank in the Americas. Guided by our purpose: "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capital markets.