Data & BI Analyst

Salary: $68,000 - 108,000 per year

Requirements:

• Post-secondary education in data analytics, computer science, information systems, business intelligence, or a related discipline, or an equivalent blend of education and experience.
• 4–6 years of experience in business intelligence, reporting, or analytics, including at least 3 years building Power BI reports and semantic models in a production environment.
• Advanced knowledge of Power BI, including dimensional modelling, DAX, Power Query (M), report design, and Power BI Service.
• Experience administering Power BI or Microsoft Fabric workspaces, refresh schedules, gateways, deployment pipelines, application publishing, and row-level security.
• Practical Microsoft Fabric experience, or experience with Power BI Premium capacity and the ability to develop Fabric expertise quickly.
• Strong working knowledge of SQL, relational databases, and data modelling principles.
• Experience validating and reconciling data across systems and resolving complex reporting issues.
• Strong analytical, problem-solving, and organizational abilities, with exceptional attention to detail.
• Ability to document technical processes and explain technical concepts clearly to both technical and non-technical audiences.
• Assets include experience with Microsoft Fabric data engineering tools such as lakehouses, warehouses, data pipelines, Dataflows Gen2, or notebooks using PySpark or Spark SQL.
• Assets include Microsoft certifications such as PL-300 or DP-600.
• Assets include familiarity with Git integration, Tabular Editor, DAX Studio, ETL/ELT processes, or APIs.
• Assets include exposure to emerging Microsoft Fabric capabilities such as Fabric IQ, data agents, or Copilot in Power BI.
• Assets include experience with ERP, CRM, or Salesforce data, including large historical datasets or legacy systems.
• Assets include previous experience in residential construction, real estate, or a similarly complex operational environment.
• We value an analytical, technically curious approach, practical problem-solving, clear communication, organization when handling competing priorities, and a commitment to accurate, well-documented work.

Responsibilities:

• Design, develop, and maintain Power BI reports, dashboards, and semantic models that turn business needs into accurate, actionable insights.
• Build and optimize DAX measures, Power Query transformations, and data models to improve report accuracy and performance.
• Validate reporting outputs, investigate discrepancies, and troubleshoot issues involving data sources, models, and reports.
• Assist Power BI users with troubleshooting, guidance, and training, and keep reporting documentation clear and current.
• Oversee day-to-day Microsoft Fabric and Power BI operations, including workspaces, refresh schedules, gateways, deployments, and application publishing.
• Monitor platform performance, capacity, and costs, and identify ways to improve efficiency and reliability.
• Maintain semantic model security, including row-level security, and coordinate access requirements with Information Systems.
• Establish and maintain platform standards, documentation, and best practices, and assess new Microsoft Fabric capabilities.
• Create and maintain reusable data models, standardized reporting definitions, and documentation of enterprise data structures and relationships.
• Use SQL to validate and reconcile data, investigate data quality concerns, and work with system owners toward resolution.
• Partner with business teams, internal technology colleagues, and external specialists on data integrations, system changes, and reporting improvements.
• Contribute to data governance initiatives covering quality, consistency, documentation, and reporting standards.

Technologies:

• Business Intelligence
• Copilot
• CRM
• DAX
• ETL
• ERP
• Fabric
• Git
• Power BI
• Power Query
• PySpark
• SQL
• Salesforce
• Security
• Spark
• Support

More:

We are Hopewell Residential Management LP, an Alberta home builder and community developer with more than 30 years of experience. Our work focuses on building better homes and neighbourhoods by prioritizing customer needs, operational excellence, thoughtful design, and customer service. We pair a collaborative, accountable approach with ESG practices, a world-class team, and a strong workplace culture. This is a full-time Data & Business Intelligence Analyst role based in Calgary, Alberta, reporting to our Senior Manager, Innovation & Technology. In this position, you will help us strengthen how we manage and use data, own key aspects of our Power BI reporting and Microsoft Fabric environment, and work with colleagues and external specialists to improve data quality and reporting capabilities.

last updated 44 week of 2026