Senior Data Engineer - Reporting Automation & AI

BMO • Chicago, IL

2d • $75,000 - $160,000 • Hybrid

About The Position

The Senior Data Engineer - Reporting Automation & AI designs, develops, and maintains automated reporting solutions to 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 works with risk-reporting teams to turn manual, fragmented processes into reliable automated pipelines, bridging 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, then help migrate data and code away from SAS toward Anaconda- and Python-based solutions while improving workflow reliability and automation.

The role also provides production and end-user support and governance for the risk technical platform and its environment, which supports risk data and control structures. It supports system strategy, maintenance, change management, database and data-governance activities, operational reliability, and delivery of risk-system initiatives. The position works with stakeholders to resolve issues, deliver solutions, monitor performance, support audits, and provide specialized consulting, analytical, and technical support. Broader work or accountabilities may be assigned as needed.

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.
• Experience modernizing legacy reporting or data processes.
• 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 work effectively with data-reporting teams and explain technical ideas concisely.
• 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.
• Deep technical proficiency gained through education and business experience.
• In-depth verbal and written communication, collaboration, analytical and problem-solving, influence, and data-driven decision-making skills.

Nice To Haves

• SAS-to-Python migration experience is strongly preferred.

Responsibilities

• Design, develop, and maintain automated reporting solutions for 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 to automate reporting, monitor system health, and improve operational reliability.
• Modernize manual and legacy reporting processes into scalable automated pipelines, 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 for accurate, high-performing risk-reporting outputs.
• Partner with data-reporting teams to ensure data structures and outputs support effective reporting and visualization.
• Communicate technical ideas, tradeoffs, and solutions to technical stakeholders.
• Provide production and end-user support and governance for the risk technical platform and system environment.
• Support planning, maintenance, and change management for risk-system strategies, process changes, system parameter changes, production schedules, and operational tasks; oversee system parameter changes.
• Work with stakeholders to resolve issues and provide solutions that support service delivery and effectiveness.
• Recommend and implement solutions based on analysis of issues and their business implications; assist with strategic plans and identify emerging issues and trends.
• Research requirements and best practices and develop recommendations for changes or enhancements.
• Help determine business priorities and execution sequencing; conduct independent analysis to resolve strategic issues.
• Support system-management infrastructure planning and development for a designated portfolio.
• Support strategic initiatives with stakeholders through intake, requirements, design, development, testing, simulation, 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.
• Analyze strategic problems, data, and information to provide insights and recommendations.
• Build change-management plans and lead or participate in readiness assessments, planning, stakeholder management, execution, evaluation, and sustainment.
• Guide or assist with identifying and classifying issues and recommending action plans.
• Provide input to ongoing operational programs and lead or participate in designing, implementing, and managing core business or group processes.
• Monitor risk-system infrastructure, applications, and business transactions across the environment.
• Collaborate with Technology service providers and other stakeholders to investigate issues, perform root-cause analysis, and plan corrective actions in accordance with production-support processes and guidelines.
• Build effective relationships and ensure alignment among internal and external stakeholders.
• Monitor and track performance, metrics, and milestones; recommend resolutions and escalate issues as appropriate.
• Support data reconciliation and provisioning processes between core risk systems.
• Verify and monitor production-environment changes in accordance with guidelines and policies.
• Support development and maintenance of system and process documentation, process controls, and operational knowledge assets.
• Apply the Risk Management Framework and make sound, risk-informed decisions aligned with business strategy, risk appetite, policies, laws, and regulations.

Benefits

• Health insurance
• Tuition reimbursement
• Accident insurance
• Life insurance
• Retirement savings plans
• Performance-based incentives and discretionary bonuses may be included, depending on the position's pay type.
• Other perks and rewards may be included.

What This Job Offers

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