linkedin
Data Solutions Specialist
SMART Technologies
Calgary, CAN
Full Time
Senior
Onsite
Today
Power BIDAXData ModelingData GovernanceSQLSnowflake
Free
Job Fit Check
Base Career helps you apply smarter for this job.
?%
Ready to ScanKey skills for this role
Power BIDAXData Modeling
About the Role
SMART Technologies is hiring a Data Solutions Specialist to act as the bridge between business, data engineers, and reporting. The role involves designing Power BI semantic models, stewarding metrics, performing QA, and enabling AI/automation.
Key Skills for This Role
Power BIDAXData ModelingData GovernanceSQLSnowflake
Responsibilities
- Design, build, and maintain Power BI semantic models on top of analytics ready data assets
- Steward the single source of truth for metric and KPI definitions
- Engage cross functional stakeholders to gather requirements and define trusted KPIs
- Serve as the QA partner across the full data pipeline, validating models before promotion
- Champion enterprise Data Governance standards and maintain documentation
- Structure and maintain semantic context for AI agents
- Provide overflow Power BI report development support as needed
Requirements
- Bachelor’s degree in Computer Science, Data Analytics, Information Systems, or a related quantitative field
- 5+ years preferred in BI Development, Analytics Engineering, or a closely related data role
- Minimum 3+ years of demonstrated depth in Power BI semantic modelling, DAX programming, and data governance frameworks
- Working knowledge of SQL and cloud data warehouses like Snowflake
- Solid grasp of dimensional modeling (Star Schema, Kimble)
- Excellent communication and facilitation skills
Full Job Posting
About The Role
- As a Data Solutions Specialist at SMART Technologies, you are the connective tissue between the business, our data engineers, and the reporting that reaches decision makers.
- Working within our Data Lakehouse, you will turn our governed data into a well modelled, thoroughly documented semantic layer, forming the single source of truth that every report, self serve query, and AI agent depends on.
- This is a technical role spanning the full analytics lifecycle, including capturing business use cases, modelling and stewarding the semantic layer, and acting as a dedicated QA and validation partner.
Key Responsibilities
- Design, build, and maintain Power BI semantic models on top of analytics ready data assets — managing relationships, complex DAX measures, calculation logic, and Row Level Security (RLS).
- Steward the single source of truth for metric and KPI definitions, ensuring a given measure resolves the same way across every report, self serve query, and AI agent.
- Optimize semantic models for accuracy, performance, and scalability, and partner closely with Data Engineers.
- Engage cross functional stakeholders across Sales, Marketing, Operations, Product, and Finance to gather requirements and define trusted KPIs.
- Translate business questions into modelled, testable data solutions, ensuring consistency in business rules and definitions across departments.
- Create and manage user stories on the Azure DevOps (ADO) board with clear requirements and acceptance criteria.
- Serve as the QA partner across the full data pipeline, validating ingestion, transformations, aggregates, and measure/model changes.
- Log, track, and partner with data engineers to resolve issues found in QA.
- Champion strong enterprise Data Governance standards — maintaining version control, access standards, and data integrity.
- Create and maintain a living enterprise data dictionary, measure catalogue, and semantic layer documentation.
- Structure and maintain the semantic context that grounds SMART's AI agents so they return consistent, trustworthy answers.
- Identify and implement opportunities to automate recurring documentation, data analysis, QA, and semantic model maintenance using AI assisted tooling.
Qualifications & Experience
- Bachelor’s degree in Computer Science, Data Analytics, Information Systems, or a related quantitative field.
- 5+ years preferred in BI Development, Analytics Engineering, or a closely related data role (ideally in technology or manufacturing).
- A minimum of 3+ years of demonstrated depth in Power BI semantic modelling, DAX programming, and data governance frameworks.
- Working knowledge of SQL — able to read, write, and reason about database queries well enough to validate backend results on cloud data warehouses like Snowflake.
- Solid grasp of dimensional modeling (Star Schema, Kimble) and how data should be shaped for enterprise reporting.
- Working knowledge of dbt (Data Build Tool) and Medallion Architecture (Bronze, Silver, Gold structures) is a major asset.
- Demonstrated experience acting as a data QA/validation resource, plus experience using Azure DevOps (ADO) or Jira for sprint planning and requirement gathering.
- Familiarity with ERP (Microsoft Dynamics 365 F&O) and CRM (Salesforce / D365 CRM) data structures is a strong asset.
- Comfort using AI assisted tooling with the discernment to validate outputs rather than trust them blindly.
- Excellent communication and facilitation skills; able to translate between business and technical audiences.
Other
- Office based role
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career