Senior Data Engineer - Reporting Automation & AI

Bank of Montreal • Chicago, IL

1d • Hybrid

About The Position

The Senior Data Engineer designs, develops, and maintains automated reporting solutions that improve the efficiency, accuracy, and scalability of risk-reporting processes. The role combines reporting automation, AI-enabled workflows, application development, and technical problem solving to modernize legacy processes and support future-state reporting platforms. The successful candidate will work closely with risk-reporting teams to turn manual, fragmented processes into reliable automated pipelines, serving as a technical bridge between raw risk data and accurate, timely reports.

This is a net-new hybrid role based in Downtown Chicago. The successful candidate works from the Chicago office three days per week, with Tuesday as a required in-office day. During the first several months, the candidate will become familiar with existing code, risk data, and reporting processes, advance migration from SAS to Anaconda- and Python-based solutions, and improve the reliability and automation of reporting workflows.

The role also provides production and end-user support and governance for the risk technical platform and system environment supporting risk data and control structures. It supports system planning, maintenance, change management, production operations, database coordination, data governance, and the monitoring of risk systems and infrastructure. The position collaborates with stakeholders and technology service providers, supports strategic initiatives and regulatory audits, and contributes to risk system documentation, process controls, and operational effectiveness. The successful candidate applies the Risk Management Framework and makes sound, risk-informed decisions in accordance with business strategy, approved risk appetite, policies, laws, and regulations.

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 to automate reporting workflows and build supporting applications.
• At least 3 years of experience integrating AI functionality into existing processes through APIs or comparable AI-enabled workflow tools.
• 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.
• 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 and applications.
• In-depth knowledge and experience with risk policy frameworks and quality control or testing frameworks.
• Ability to work independently, take initiative, and manage technical work with limited day-to-day direction.
• Strong collaboration and communication skills, including the ability to explain technical ideas concisely and work effectively with data-reporting teams.
• In-depth verbal and written communication, collaboration and teamwork, analytical and problem-solving, influence, and data-driven decision-making skills.
• Deep technical proficiency gained through extensive education and business experience.
• Ability to exercise judgment, diagnose and solve problems within established rules, and handle non-routine situations.
• Ability to make sound, risk-informed decisions in accordance with the Risk Management Framework, approved risk appetite, applicable policies, laws, and regulations.

Nice To Haves

• Experience modernizing legacy reporting or data processes.
• SAS-to-Python migration experience is strongly preferred.

Responsibilities

• Design, develop, and maintain automated reporting solutions to improve the efficiency, accuracy, and scalability of risk-reporting processes.
• Build and integrate AI-enabled workflows for data preparation, validation, and report generation.
• Develop and maintain Python and Shell applications and scripts that automate reporting, monitor system health, and improve operational reliability.
• Modernize manual and legacy reporting processes into scalable automated pipelines, including migration from SAS to Anaconda- and Python-based solutions.
• Design optimized data marts and star schemas for Power BI consumption.
• Develop and tune SQL queries for accurate, high-performing risk-reporting outputs.
• Partner with data-reporting teams to ensure data structures and outputs support effective reporting and visualization.
• Provide production and end-user support and governance for the risk technical platform and its risk data and control structures.
• Support planning, maintenance, and change management for risk system strategies, process and parameter changes, production schedules, and operational tasks.
• Work with stakeholders to resolve issues and recommend or implement solutions that support service delivery and business objectives.
• Support strategic planning, analyze data and emerging issues, research requirements and best practices, and develop recommendations.
• Support system management infrastructure planning and strategic initiatives, including requirements, design, development, testing, sign-offs, production, and post-implementation activities.
• Represent risk systems management during internal or external regulatory audits and examinations.
• Coordinate database management and ensure data alignment and integration in accordance with data governance standards.
• Build and participate in change management plans and activities, including readiness assessments, stakeholder management, execution, evaluation, and sustainment.
• Monitor risk system infrastructure, applications, and business transactions; collaborate on root cause analysis and corrective actions.
• Monitor and track performance, metrics, and milestones; recommend resolutions and escalate issues as appropriate.
• Support data reconciliation and provisioning between core risk systems.
• Verify and monitor changes implemented in production environments according to applicable guidelines and policies.
• Maintain system and process documentation, process controls, and operational knowledge assets.
• Communicate technical ideas, tradeoffs, and solutions clearly to technical stakeholders.

Benefits

• Health insurance
• Tuition reimbursement
• Accident insurance
• Life insurance
• Retirement savings plans
• Performance-based incentives, discretionary bonuses, and other perks and rewards may be included in the total compensation package.
• Training and coaching, manager support, and network-building opportunities.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior