Base: $67,200.00 - $124,200.00; bonus/equity: may ...
Hybrid
Strong python, sas, and sql programming skills
Advanced sql server configuration and optimization
Experience with aws redshift, glue, and spark
The role involves designing and maintaining robust, scalable ETL/ELT pipelines to support large-scale analytical workloads across hybrid cloud and on-prem environments
Job Summary
The role involves designing and maintaining robust, scalable ETL/ELT pipelines to support large-scale analytical workloads across hybrid cloud and on-prem environments.
Candidates will develop actionable insights using Power BI dashboards while ensuring high-performance data structures through advanced SQL Server configurations.
BMO Financial Group offers a comprehensive benefits package including health insurance, tuition reimbursement, and retirement savings plans alongside competitive compensation.
Matching Summary
The role involves designing and maintaining robust, scalable ETL/ELT pipelines to support large-scale analytical workloads across hybrid cloud and on-prem environments.
Salary
Base: $67,200.00 - $124,200.00; Bonus/Equity: May include commission structure and performance-based incentives; Benefits: Health insurance, tuition reimbursement, accident/life insurance, retirement savings plans
Skills & Requirements
Must-have
Strong Python, SAS, and SQL programming skills
Advanced SQL Server configuration and optimization
Experience with AWS Redshift, Glue, and Spark
Power BI dashboard development using DAX and M Code
Dimensional modeling with star/snowflake schemas
Nice-to-have
Experience with AI/ML workflows and SageMaker
Knowledge of Java and JavaScript programming
Familiarity with data governance frameworks
Understanding of MLOps concepts
Experience with data security and encryption
Key Requirements
4-6+ years of relevant experience in data engineering or analytics
Post-secondary degree in a related discipline or equivalent experience