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 role involves designing and maintaining robust 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 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 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 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
ETL pipeline design and maintenance
Dimensional modeling star snowflake schemas
AWS Redshift Glue experience
Nice-to-have
Java or JavaScript programming skills
AI ML workflows with AWS SageMaker
Data security encryption best practices
Apache Spark Hadoop familiarity
MLOps concepts knowledge
Key Requirements
4-6+ years of relevant experience in data engineering