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.

Senior Data Engineer – Reporting Automation, AI

BMO U.S.

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

Posted 10/23/2026full-timeChicago • Illinois • United StatesSenior💰 $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, with a strong focus on Python, SQL, and AI-enabled workflows. Proficient in risk system management and data governance, ensuring high-quality reporting and compliance with regulatory standards.

Highest-signal resume keywords
Advanced SQLPython DevelopmentAI IntegrationPower BIRisk System Management

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
SQL QueriesPython ScriptingShell ScriptingData Mart DesignDimensional ModelingReporting AutomationPerformance TuningData ReconciliationChange ManagementRoot-Cause Analysis
Soft Skills
Analytical SkillsProblem-Solving SkillsCollaboration SkillsCommunication SkillsInfluence Skills
Tools & Technologies
Power BIPower QueryGitAnacondaSAS
Industry Keywords
Risk ReportingData GovernanceQuality ControlRegulatory AuditsData Warehouse Concepts

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
  • Modernize manual and legacy reporting processes into scalable automated pipelines
  • Migrate 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 support effective reporting and visualization
  • Provide production and end-user support and governance for the risk technical platform
  • Support planning, maintenance, and change management for risk-system strategies and operational tasks
  • Manage system parameter changes
  • Resolve stakeholder issues and provide business solutions
  • Research requirements and best practices and recommend changes or enhancements
  • Support system-management infrastructure planning and development
  • Coordinate database management and data governance
  • Lead or participate in change-management activities
  • Monitor risk-system infrastructure, applications, and business transactions
  • Investigate incidents, perform root-cause analysis, and plan corrective actions
  • Support data reconciliation and provisioning between core risk systems
  • Verify and monitor production-environment changes
  • Maintain system and process documentation, process controls, and knowledge assets
  • Track metrics and milestones, address issues, and escalate as appropriate
  • Represent risk systems management during regulatory audits and examinations

Requirements

What you’ll need
  • 5+ years of hands-on professional work experience in reporting automation or data development
  • Advanced SQL with complex views, stored procedures, and performance tuning
  • 3+ years of experience using Python and Shell scripting
  • 3+ years of experience integrating AI functionality through APIs or comparable AI-enabled workflow tooling
  • 2 years of experience with Power BI and Power Query
  • 2 years of experience using Git for version control
  • 4+ years of experience with dimensional modeling and modern data-warehouse concepts
  • Experience modernizing legacy reporting or data processes; SAS-to-Python migration experience strongly preferred
  • Typically 5–7 years of relevant experience and a post-secondary degree in a related field of study, 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/testing frameworks
  • Deep knowledge and technical proficiency gained through extensive education and business experience
  • In-depth verbal and written communication skills
  • In-depth collaboration and team skills
  • In-depth analytical and problem-solving skills
  • In-depth influence skills
  • In-depth data-driven decision-making skills
  • Ability to work independently and manage technical work with limited day-to-day direction

Benefits

Comp & perks
  • Performance-based incentives
  • Discretionary bonuses
  • Health insurance
  • Tuition reimbursement
  • Accident and life insurance
  • Retirement savings plans
  • In-depth training and coaching
  • Manager support
  • Network-building opportunities
  • Reasonable accommodations for individuals with disabilities