Rate :
- $60–65 / hour (Incorporated)
- $45–52 / hour (T4)
Location & Work Model :
Full-time onsite for the first 3 monthsHybrid work may be considered after, with manager approvalEligibility
Canadian Citizen or Permanent ResidentAble to obtain Reliability Status and Controlled Goods Security ClearanceAbout the Role
We are seeking an experienced Senior Data Analyst to design, build, and support advanced business intelligence and analytics solutions. This role focuses on transforming complex enterprise data into high-quality, high-performance Power BI reporting used to support large programs and decision-making.
You will work across the full data lifecycle—from data sources and warehousing to modeling and visualization—while collaborating closely with business and technical stakeholders.
Key Responsibilities
Design, develop, and maintain complex Power BI dashboards and reportsBuild optimized Gold-layer views in Databricks for BI consumptionDevelop advanced Power BI data models using DAX and Power Query (M)Write and optimize complex SQL queries for large datasetsDefine and document data lineage and transformation strategiesIntegrate data from multiple enterprise systems into unified reporting modelsValidate data accuracy, transformations, and calculationsCreate clear technical and business documentationAct as a Power BI subject matter expert , supporting and mentoring usersEnsure BI solutions meet performance, governance, and deployment standardsRequired Skills & Experience
7–10 years of experience in data analysis or business intelligenceExpert-level Power BI experience (data modeling, DAX, Power Query, RLS)Strong SQL skills, including performance tuningHands‑on experience with Databricks and Delta LakeSolid understanding of data modeling (star / snowflake schemas, SCDs)Experience working in large enterprise or complex data environmentsNice to Have
Experience with Azure analytics services (Azure SQL DW, Azure Analysis Services)Python and / or Spark experienceBackground in manufacturing, engineering, or project‑based environmentsEducation
Bachelor’s degree in Computer Science, Data Science, Analytics, or a related fieldMaster’s degree is an asset#J-18808-Ljbffr