Reporting Automation / AI Developer
BMO U.S. - Chicago, IL
Hiring: Reporting Automation / AI Developer Company: BMO U.S. Location: Chicago, IL Job Posted Time: 2026-09-16 17:29:35 Employment Type: Part-time / Hybrid Target Skills & Keywords : Data Warehouse, Git, Python, SQL, Shell About the job Required Skills: •Reporting Automation: Design, develop, and maintain automated reporting solutions that improve the efficiency, accuracy, and scalability of risk reporting processes. •AI-Enabled Workflows: Build and integrate AI-enabled workflows to streamline data preparation, validation, and report generation, reducing manual effort and turnaround time. •Application Development: Develop and maintain applications and scripts (Python / Shell) that support reporting automation, monitor system health, and improve the reliability of risk reporting operations. •Legacy Modernization: Re-engineer legacy, manual reporting processes into modern, automated pipelines that support future-state reporting platforms. •Reporting Delivery: Design optimized data marts and star schemas tailored for Power BI consumption, and optimize SQL to deliver accurate risk reporting outputs. Qualifications: •Professional Experience: A few years of hands-on experience in reporting automation or data development, with a strong mastery of SQL (complex views, stored procedures, and performance tuning). •Automation & Development: Proven ability to use Python and Shell scripting to automate reporting workflows and build supporting applications. •AI Enablement: Familiarity applying AI-enabled workflows and tooling to modernize and accelerate reporting processes. •Reporting Tools: Hands-on experience with Power BI (DAX / Power Query) is a plus; familiarity with Microsoft Fabric is also a plus. •Engineering Practices: Version control using Git and a solid grasp of dimensional modeling and modern data warehouse concepts. •Independence: A self-starter with the technical maturity to manage deliverables and troubleshoot complex problems with minimal supervision. •Bachelor’s or Master’s degree in Computer Science, Information Systems, Engineering, or a related quantitative field. •Technical Problem Solving: Independently investigate data quality and reporting issues, identify root causes, and implement durable technical remediations. •Clear Communication: Communicate clearly with both technical and non-technical stakeholders to ensure alignment, transparency, and data integrity across risk reporting. Compensation: •$75,000 - $160,000 / year Interested candidates, please apply directly through the job posting on company's career page or try via AI auto apply on this platform. Don't miss this opportunity to join a forward-thinking team!