Apply

Ready to go for it?

AI Apply speeds things up—apply directly if you prefer.

FREE ACCESS
5,000–10,000 jobs/day
Scoutfield Logo

See all jobs on Scoutfield

Search thousands of fresh jobs every day.

Discover
  • Fresh listings
  • Fast filters
  • No subscription required
Create a free account and start exploring right away.
BMO U.S.

Reporting Automation, AI Developer

BMO U.S.

. Design, develop, and maintain automated reporting solutions for risk reporting processes .

Posted 9/15/2026full-timeChicago • Illinois • United StatesJuniorMid-Level💰 $75,000 - $160,000 per yearWebsite

Core Competencies

Role fit
Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and developing automated reporting solutions, utilizing Python, SQL, and Power BI to enhance data integrity and streamline risk reporting processes. Capable of collaborating with diverse stakeholders to translate manual workflows into efficient automated systems.

Highest-signal resume keywords
SQL MasteryPython ScriptingShell ScriptingPower BI DevelopmentAI-Enabled Workflows

ATS Keywords

Tailor your resume
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills
SQLPythonShell ScriptingPower BIDimensional ModelingData Warehouse ConceptsAutomated ReportingData Quality InvestigationTechnical RemediationVersion Control
Soft Skills
Clear CommunicationProblem SolvingCollaboration
Tools & Technologies
Power BIMicrosoft FabricGit
Industry Keywords
Risk ReportingAutomated PipelinesData PreparationData ValidationReporting Automation

Tech Stack

Tools & technologies
PythonShell ScriptingSQL

About the role

Key responsibilities & impact
  • 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
  • Monitor system health and improve the reliability of risk reporting operations
  • Re-engineer legacy manual reporting processes into modern automated pipelines
  • Design optimized data marts and star schemas for Power BI consumption
  • Optimize SQL to deliver accurate risk reporting outputs
  • Partner with risk reporting teams to translate fragmented manual processes into reliable automated pipelines
  • Investigate data quality and reporting issues, identify root causes, and implement technical remediations
  • Communicate with technical and non-technical stakeholders to ensure alignment, transparency, and data integrity

Requirements

What you’ll need
  • A few years of hands-on experience in reporting automation or data development
  • Strong mastery of SQL, including complex views, stored procedures, and performance tuning
  • Proven ability to use Python and Shell scripting to automate reporting workflows and build supporting applications
  • Familiarity applying AI-enabled workflows and tooling
  • Hands-on experience with Power BI (DAX / Power Query) is a plus
  • Familiarity with Microsoft Fabric is a plus
  • Version control using Git
  • Solid grasp of dimensional modeling and modern data warehouse concepts
  • 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
  • Ability to independently investigate data quality and reporting issues, identify root causes, and implement durable technical remediations
  • Ability to communicate clearly with technical and non-technical stakeholders

Benefits

Comp & perks
  • Health insurance
  • Tuition reimbursement
  • Accident insurance
  • Life insurance
  • Retirement savings plans
  • Performance-based incentives
  • Discretionary bonuses
  • In-depth training and coaching
  • Manager support
  • Network-building opportunities
  • Tools and resources for professional growth