Senior Data Engineer
Senior Data Engineer at RSM Canada, a professional services firm, in Toronto. Day to day they design dimensional/3NF data models, build ETL pipelines into a unified data platform, and develop semantic models and dashboards using SQL, Python/Scala, cloud platforms (Azure/AWS/GCP), Fabric/Databricks/Snowflake, and BI tools like Power BI or Tableau. Up to 20% travel to the US.
- Compensation
- CA$79K–CA$136.7K / yr
- Location
- Toronto, Canada
- Work setup
- Not specified
- Seniority
- Senior
- Employment
- Not specified
- Experience
- 3+ years
- Category
- Data engineering
- Posted
Skills
Must have
- Bachelor's degree or equivalent experience in Math, Computer Science, Information Systems, Finance, Accounting, Economics, or Analytics
- 3+ years of experience designing data models across multiple subject areas and business domains
- 3+ years of experience designing and developing business intelligence solutions
- 3+ years designing and developing scalable data pipelines to ingest, transform, and load data into data lakes and warehouses
- Proficient in SQL
- Experience with Python/Scala
- Experience with major cloud platforms such as 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 such as Power BI, QuickSight or Tableau
- Strong communication skills, both written and verbal
- Excellent critical thinking and problem-solving abilities
- Team-oriented, able to work independently and in virtual teams
- Able to travel to the United States up to 20% for business purposes
Nice to have
- Experience conducting solution / technical assessments
- Experience with DBT, Spark and BigData technologies
- Knowledge of Databricks
- Working knowledge of modernized information management tools (e.g., Collibra, Informatica, Talend, Alation, Purview)
Full description
We are the leading provider of professional services to the middle market globally, our purpose is to instill confidence in a world of change, empowering our clients and people to realize their full potential. Our exceptional people are the key to our unrivaled, inclusive culture and talent experience and our ability to be compelling to our clients. You’ll find an environment that inspires and empowers you to thrive both personally and professionally. There’s no one like you and that’s why there’s nowhere like RSM.
We Are Seeking a Skilled Business Intelligence And Data Engineering Professional With a Strong Background In Design And Development, Data Modeling, And Business Analytics. This Individual Will Collaborate Closely With Our Data Analytics Team To
- Create and maintain data models (dimensional and 3NF) aligned with business requirements.
- Design and develop ETL pipelines that consolidate data from various source systems into a unified data platform, including defining source-to-target mappings, business rules, and any necessary data transformations.
- Develop Semantic Models and Reports / Dashboards based on business requirements.
- Facilitate business requirements sessions and conduct data analysis to accurately identify and specify the data needed to support impactful business objectives.
- Collaborate effectively with clients and team members across regions.
Basic Qualifications
- Bachelor’s degree or equivalent experience in Math, Computer Science, Information Systems, Finance, Accounting, Economics, or Analytics.
- 3+ years of experience designing data models across multiple subject areas and business domains.
- 3+ years of experience in designing and developing business intelligence solutions.
- 3+ years of designing and developing scalable, efficient data pipelines to ingest, transform, and load data from multiple sources into data lakes and data warehouses
- Proficient in SQL
- Experience with Python/Scala
- Proven experience with major cloud platforms such as Microsoft 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 such as Power BI, Quick Sight or Tableau.
- Strong communication skills, both written and verbal.
- Excellent critical thinking and problem-solving abilities.
- Team-oriented with the ability to work independently and in virtual teams.