Senior Data Engineer - Reporting Automation & AI

BMO • Chicago, IL

3d • $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 the reports stakeholders rely on.

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 the existing code, risk data, and reporting processes, and help migrate data and code away from SAS toward Anaconda- and Python-based solutions while improving reporting workflow reliability and automation.

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.
• 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.
• Bachelor’s or Master’s degree in Computer Science, Information Systems, Engineering, or a related quantitative field.

Nice To Haves

• SAS-to-Python migration experience is strongly preferred.
• Power BI experience with DAX is a plus.
• Familiarity with Microsoft Fabric is a plus.

Responsibilities

• Design, develop, and maintain automated solutions for risk reporting.
• 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 to deliver 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 clearly to technical stakeholders.
• Investigate data-quality and reporting issues, identify root causes, and implement durable technical remediations.
• Manage technical work independently and troubleshoot complex problems with minimal supervision.

Benefits

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

What This Job Offers

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