This is a hybrid role. Employees will be expected to work from the BMO office 3 - 4 days per week.

Working within BMO's Chief Data and Analytics Office the Microsoft Business Intelligence (BI) Developer will work with the team to design, develop, implement, support and administer BI applications. Utilizing their knowledge of databases, ETL (Extract / Transform / Load) and application development they will create apps using SQL Server BI tools (SSIS, SSAS, SSRS) and ASP.NET/C#/JavaScript. For this entry level position we are looking for someone with a few years of experience and/or a good educational background in IT development with a focus on development, ETL and databases.

MANDATE: The Chief Data and Analytics Office (CDAO) is part of the Risk and Finance divisions of BMO - Bank of Montreal. The CDAO strategy is focused on building a trusted, scalable data foundation aligned with enterprise data and architecture standards that enables timely decision making, regulatory confidence, operational efficiency, and AI-powered insight generation across Risk and Finance.

Within the CDAO the Data Insights and Enablement team is responsible for designing holistic solutions that encompass department and enterprise wide needs. This will include assisting the team in various capacities with the development and support of staged data for reports, data cubes, data adjustments, data quality monitoring, operational reports, and an automated production environment. The team will also work closely with BMO’s technology team to help guide the efficient provisioning and operation of the systems, databases and applications that support Risk and Finance.

The BI Developer position will require the individual to participate in the detailed development and support of projects for the CDAO. On these projects the individual in this role will assist in designing efficient, effective and timely applications. This position will require the incumbent to use his/her experience and knowledge of the software development life cycle (SDLC), development tools, problem resolution and application support. The individual in this role will continually look for ways to improve the efficiency and delivery of developed processes. The incumbent will ensure that the development standards and processes will result in an efficient, stable and reliable environment for Risk and Finance.

ACCOUNTABILITIES: Development: The individual in this role will ensure that the following key criteria are met:

• Developing robust, scalable applications and processes
• Building data quality checks into developed applications and processes
• An appropriate level of documented unit testing is performed prior to implementation
• Metadata is captured for all transformations and processes, and an impact analysis is carried out prior to any enhancements.
• User acceptance testing is performed when appropriate to ensure that the client agrees to the final deliverable.

Support of Production Processes / Applications / Systems: The incumbent will help implement and support production processes / applications / systems within the Risk Reporting environment. The individual in this role will provide support by analyzing and resolving production problems with Risk Reporting developed applications and processes. In particular, the position must ensure that

• Problems / errors are thoroughly investigated and resolved in a timely manner by involving the appropriate IT and business specialists.
• Processes and system enhancements are implemented to prevent reoccurrences of issues.
• Timely off-hours support is provided on evenings, weekends and holidays
• Preparation or implementation of processes / applications into and automated production environment
• Administration of applications / systems to ensure functionality, availability, performance and security are maintained

QUALIFICATIONS:

• 2+ years of development experience and/or relevant post-secondary school education
• 2+ years of experience with relational databases and writing complex SQL queries and/or relevant post-secondary school education
• Experience with Microsoft SQL Server, SSIS, SSRS, SSAS, T-SQL Stored Procedures would be beneficial
• Experience designing and developing ETL processes would be beneficial
• MSBI administration experience (SQL Server, SSIS, SSAS, SSRS and SharePoint) would be beneficial
• Experience with MS Visual Studio, VB.NET, ASP.NET, C#, JavaScript would be beneficial
• Experience with Power BI development would be beneficial
• Experience with SAS development would be beneficial

General Knowledge/Skills

• Is driven and can work on their own with minimal supervision.
• Will “own” the tasks given to them. Must be able to drive tasks to completion by seeking out help when needed and understanding task deadlines.
• Is innovative and always seeks out better ways to do things. Both in the tasks presented to them but also in other areas within their work environment.
• Is curious about technology and seeks out ways to gather more experience in new areas.
• Strong troubleshooting/problem solving abilities.
• Excellent oral and written communication skills.
• Advanced knowledge of Microsoft Excel, PowerPoint.
• Experience in Financial Service industry and Risk Reporting would an asset.

Salary: $61,600.00 - $113,900.00

Pay Type: Salaried

The above represents BMO Financial Group’s pay range and type.

Salaries will vary based on factors such as location, skills, experience, education, and qualifications for the role, and may include a commission structure. Salaries for part-time roles will be pro-rated based on number of hours regularly worked. For commission roles, the salary listed above represents BMO Financial Group’s expected target for the first year in this position.

BMO Financial Group’s total compensation package will vary based on the pay type of the position and may include performance-based incentives, discretionary bonuses, as well as other perks and rewards. BMO also offers health insurance, tuition reimbursement, accident and life insurance, and retirement savings plans. To view more details of our benefits, please visit: https://jobs.bmo.com/global/en/Total-Rewards

About Us At BMO we are driven by a shared Purpose: Boldly Grow the Good in business and life. It calls on us to create lasting, positive change for our customers, our communities and our people. By working together, innovating and pushing boundaries, we transform lives and businesses, and power economic growth around the world.

As a member of the BMO team you are valued, respected and heard, and you have more ways to grow and make an impact. We strive to help you make an impact from day one – for yourself and our customers. We’ll support you with the tools and resources you need to reach new milestones, as you help our customers reach theirs. From in-depth training and coaching, to manager support and network-building opportunities, we’ll help you gain valuable experience, and broaden your skillset.

To find out more visit us at https://jobs.bmo.com/ca/en

BMO is committed to an inclusive, equitable and accessible workplace. By learning from each other’s differences, we gain strength through our people and our perspectives. Accommodations are available on request for candidates taking part in all aspects of the selection process. To request accommodation, please contact your recruiter.

Note to Recruiters: BMO does not accept unsolicited resumes from any source other than directly from a candidate. Any unsolicited resumes sent to BMO, directly or indirectly, will be considered BMO property. BMO will not pay a fee for any placement resulting from the receipt of an unsolicited resume. A recruiting agency must first have a valid, written and fully executed agency agreement contract for service to submit resumes.