Senior BI & Data Engineer: Cloud, ETL & Data Lakes

RSM US LLP; Calgary; Hybrid; CAD 79,000 - 137,000; Full time

Job summary

RSM US LLP in Calgary, Canada seeks a skilled Business Intelligence and Data Engineering professional to design data models, build ETL pipelines, and develop semantic models and dashboards. You will collaborate with our Data Analytics team to deliver data-driven insights across regions.

The role requires 3+ years in data modeling and BI development, proficiency in SQL and Python/Scala, and experience with cloud platforms and BI tools. Hybrid work arrangement and travel as needed are offered.

Qualifications

• Bachelor’s degree or equivalent in Math, CS, IS, Finance, Economics, or Analytics.
• 3+ years designing data models across multiple domains.
• 3+ years designing and developing BI solutions.
• 3+ years designing scalable data pipelines to ingest/transform/load data into data lakes and data warehouses.
• Proficient in SQL.
• Experience with Python/Scala.
• Experience with major cloud platforms (Azure, AWS or GCP).
• Experience with data platforms like Fabric, Databricks or Snowflake.
• Experience with Git, DevOps, CI/CD and version control.
• Experience with BI visualization tools (Power BI, QuickSight or Tableau).
• Strong communication and problem-solving abilities.
• Team-oriented with the ability to work independently and travel as needed.

Responsibilities

• Create and maintain data models aligned with business requirements.
• Design and develop ETL pipelines consolidating data from various sources into a unified data platform.
• Develop Semantic Models and Reports/Dashboards based on business requirements.
• Facilitate business requirements sessions and conduct data analysis to identify data needs.
• Collaborate effectively with clients and team members across regions.

Skills

SQL

Python/Scala

Data Modeling

ETL Development

Data Warehouses

Power BI

Databricks

Cloud Platforms

Git/CI-CD

Communication

Education

Bachelor's degree or equivalent in Math/CS/IS/Finance/Economics/Analytics

Tools

Databricks

Snowflake

Fabric

Collibra

Informatica

Talend

Alation

Purview

Git

Job description

RSM US LLP in Calgary, Canada seeks a skilled Business Intelligence and Data Engineering professional to design data models, build ETL pipelines, and develop semantic models and dashboards. You will collaborate with our Data Analytics team to deliver data-driven insights across regions.

The role requires 3+ years in data modeling and BI development, proficiency in SQL and Python/Scala, and experience with cloud platforms and BI tools. Hybrid work arrangement and travel as needed are offered.