Senior Data Analytics Engineer

BMO Financial Group

Toronto, Ontario, Canada
Base: $67,200.00 - $124,200.00; bonus/equity: may ...
Hybrid
Python sas and sql programming
Power bi dax and m code development
Sql server configuration and optimization
The Senior Data Engineering & Analytics Specialist is responsible for designing, building, and optimizing scalable data platforms that enable high-quality, data-driven decision-making across hybrid cloud and on-prem environments

Job Summary

  • The Senior Data Engineering & Analytics Specialist is responsible for designing, building, and optimizing scalable data platforms that enable high-quality, data-driven decision-making across hybrid cloud and on-prem environments.
  • This role requires translating complex business requirements into reliable data pipelines, performant data models, and actionable insights using tools like Python, SQL, and Power BI.
  • BMO Financial Group offers a comprehensive total compensation package including performance-based incentives, discretionary bonuses, health insurance, tuition reimbursement, and retirement savings plans.

Matching Summary

The Senior Data Engineering & Analytics Specialist is responsible for designing, building, and optimizing scalable data platforms that enable high-quality, data-driven decision-making across hybrid cloud and on-prem environments.

Salary

Base: $67,200.00 - $124,200.00; Bonus/Equity: May include commission structure and discretionary bonuses; Benefits: Health insurance, tuition reimbursement, accident and life insurance, retirement savings plans

Skills & Requirements

Must-have

  • Python SAS and SQL programming
  • Power BI DAX and M Code development
  • SQL Server configuration and optimization
  • Dimensional modeling star and snowflake schemas
  • AWS Redshift and Glue experience
  • Enterprise ETL pipeline architecture

Nice-to-have

  • Java or JavaScript programming skills
  • AI ML workflows with AWS SageMaker
  • Data security encryption best practices
  • Apache Spark and Hadoop familiarity
  • MLOps concepts knowledge
  • Data governance framework expertise

Key Requirements

  • 4-6+ years of relevant experience in data engineering or analytics
  • Post-secondary degree in a related discipline or equivalent experience

Work Rights

Not specified

Tailored Resume

Cover Letter