Cube Dev & Power BI Analytics Architect

Precision Technologies; Mississauga; On-site; CAD 90,000 - 130,000; Full time

Job summary

Precision Technologies seeks a BI and Analytics Developer to design Cube Dev semantic models using YAML-based cube definitions and to build dimensions, facts, measures, and pre-aggregation logic. You will design Power BI reports, measures, and manage security with RLS while optimizing semantic layer performance.

Collaborate with stakeholders to translate requirements, integrate with Snowflake/Databricks, and implement governance standards. Strong Git/CI/CD experience is preferred.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field.
• 5 to 10 years of experience in BI and Analytics development.
• 4+ years of hands-on Power BI development experience.

Responsibilities

• Design and develop Cube Dev semantic models using YAML configurations and define cubes with dimensions, facts, measures, joins, and pre-aggregation logic.
• Create and maintain Cube Views and access policies, implement security controls including RLS, CLS, and role-based access management.
• Develop solutions leveraging DAX, MDX, SQL, and GraphQL APIs for analytics consumption and optimize semantic layer performance through caching and pre-aggregation.
• Design, develop, and maintain Power BI reports, dashboards, scorecards, complex DAX measures, calculated columns, and KPIs; manage Power BI Service workspaces and deployment pipelines; troubleshoot reports, gateways, and datasets.
• Work with Snowflake, SQL Server, Databricks, Dataiku, or similar platforms; design star and snowflake schemas; develop ETL/ELT processes; ensure data quality and governance.

Skills

Cube Dev modeling

YAML configuration

GraphQL

MDX

Semantic modeling

Power BI Service

DAX

Power Query (M)

SQL

Data Modeling

Snowflake

Security/RLS

Git

CI/CD

Education

Bachelor's degree in Computer Science/IS/Engineering

Tools

Git

CI/CD

Job description

Precision Technologies seeks a BI and Analytics Developer to design Cube Dev semantic models using YAML-based cube definitions and to build dimensions, facts, measures, and pre-aggregation logic. You will design Power BI reports, measures, and manage security with RLS while optimizing semantic layer performance.

Collaborate with stakeholders to translate requirements, integrate with Snowflake/Databricks, and implement governance standards. Strong Git/CI/CD experience is preferred.