Data Analytics Analyst

Application Deadline:

04/04/2024

Address:

VIRTUAL(R)13 - HomeRes - IL

Job Family Group:

Human Resources

• Experience with designing and developing Power BI Reports using SQL, Data Preparation using the inbuilt Data Modeling features and Utilize DAX (Data Analysis Expressions) to create complex calculations and measures.
• Implement and maintain data security measures within Power BI, ensuring compliance with organizational policies, develop role-based access control and manage user access to reports and dashboards.
• Advanced understanding of data warehousing concepts, including star and snowflake schemas, ETL, ability to troubleshoot and resolve issues related to data refresh, connectivity, and performance.
• Capability to design and implement complex data transformations using Power Query Editor, Strong proficiency in SQL queries, SQL Agent, and Store procedures, create reports and dashboards that provide insights into Sales & Incentive metrics and KPIs

Technical proficiency in Power BI, Tableau, SQL, Data Modeling & Microsoft Excel

Provides expert advice and counsel related to performance management through a variety of business/group & leadership engagements to execute the HR strategy and support the business/group strategy. Supports/defines the strategic direction, governance design, program design and execution of the performance management program at BMO. Completes specific strategic & operational work to deliver business results and/or minimize risk.

• Provides input to the development of the program strategy and contributes to and continually improves principles, process, and tools.
• Manages relationships with outside service providers for programs and ensure all required activities are completed.
• Provides advanced analytical and other project support in the design, development, implementation and evaluation of policies and programs.
• Builds change management plans of varying scope and type; leads or participates in a variety of change management activities including readiness assessments, planning, stakeholder management, execution, evaluation and sustainment of initiatives.
• Leads or participates in defining the communication plan designed to positively influence or change behaviour; develops tailored messaging; and identifies appropriate distribution channels.
• Provides input into the planning and implementation of operational programs.
• Develops solutions and makes recommendations based on an understanding of the business strategy and stakeholder needs.
• Provides advice and guidance to assigned business/group on implementation of solutions.
• Supports the design, development and implementation of multi-year strategy for performance management that improves employee productivity, engagement and advocacy in alignment with BMO’s overall business strategy.
• Provides input to policy positions for performance management, taking into account legislative requirements.
• Breaks down strategic problems, and analyses data and information to provide insights and recommendations. Gathers and formats data into regular and ad-hoc reports, and dashboards.
• Monitors and tracks program performance, and addresses any issues.
• Provides analytical support & recommends program design solutions, including manipulating data, preparing funding & forecasting models, preparing scenarios, developing preliminary results and monitoring variances to plan for various total reward programs.
• Participates in / coordinates industry benchmarking processes that allow for better understanding of BMO’s program in relation to comparators.
• Builds effective relationships with internal/external stakeholders.
• Builds alignment between stakeholders.
• Supports development and execution of strategic initiatives in collaboration with internal and external stakeholders.
• Focus is primarily on business/group within BMO; may have broader, enterprise-wide focus.
• Exercises judgment to identify, diagnose, and solve problems within given rules.
• Works independently on a range of complex tasks, which may include unique situations.
• Broader work or accountabilities may be assigned as needed.

  Qualifications:

• Typically between 4 - 6 years of relevant experience and post-secondary degree in related field of study or an equivalent combination of education and experience.
• Technical proficiency gained through education and/or business experience.
• Verbal & written communication skills - In-depth.
• Collaboration & team skills - In-depth.
• Analytical and problem solving skills - In-depth.
• Influence skills - In-depth.
• Data driven decision making - In-depth.

Compensation and Benefits: