Senior Data Engineer - Reporting Automation & AI
BMO Financial Group2 days ago
Base Salary
$75k - $160k/yr
Responsibilities
- Design, develop, and maintain automated risk-reporting solutions and scalable reporting pipelines.
- Build and integrate AI-enabled workflows for data preparation, validation, and report generation.
- Develop Python and Shell applications and scripts to automate reporting, monitor system health, and improve operational reliability.
- Modernize legacy reporting processes, including migration from SAS-based processes to Anaconda and Python-based solutions.
- Design optimized data marts and star schemas for Power BI consumption.
- Develop and tune SQL queries, including complex views and stored procedures, for accurate and high-performing reporting outputs.
- Provide production and end-user support, governance, monitoring, change management, and operational oversight for risk systems.
- Coordinate databases and data reconciliation or provisioning processes while maintaining data governance and control standards.
- Investigate incidents, perform root-cause analysis, recommend corrective actions, and support production changes.
- Collaborate with risk-reporting teams, technology providers, regulators, and internal and external stakeholders.
- Support strategic initiatives across requirements, design, development, testing, implementation, and post-implementation activities.
- Maintain system documentation, process controls, knowledge assets, performance metrics, and operational programs.
Requirements
- At least 5 years of hands-on professional experience in reporting automation or data development, including advanced SQL, complex views, stored procedures, and performance tuning.
- At least 3 years of experience using both Python and Shell scripting for reporting automation and supporting applications.
- At least 3 years of experience integrating AI functionality through APIs or comparable AI-enabled workflow tooling.
- At least 2 years of experience with Power BI and Power Query.
- At least 2 years of experience using Git for version control.
- At least 4 years of experience with dimensional modeling and modern data-warehouse concepts.
- Experience modernizing legacy reporting or data processes; SAS-to-Python migration experience is strongly preferred.
- Typically 5–7 years of relevant experience and a post-secondary degree in a related field, or an equivalent combination of education and experience.
- In-depth knowledge of risk system management concepts, risk policy frameworks, quality control and testing frameworks, and data governance.
- Strong technical, analytical, problem-solving, communication, collaboration, influence, and data-driven decision-making skills.
- Ability to work independently, manage technical work with limited day-to-day direction, and handle non-routine situations.
Benefits
- Hybrid work arrangement based in Downtown Chicago, with three days per week in the Chicago office and Tuesday required in-office.
- Health insurance, tuition reimbursement, accident and life insurance, and retirement savings plans.
- Additional performance-based incentives, discretionary bonuses, and other perks may be included depending on the compensation package.
About BMO Financial Group
BMO Financial Group is a publicly traded North American bank offering personal and commercial banking, wealth management, and capital markets services to consumers, businesses, and institutions. Founded in 1817 and headquartered in Toronto, it operates in Canada and the United States, including BMO Bank N.A. in the U.S. The company is listed on the NYSE and TSX under the symbol BMO.