Senior Power BI & Data Warehouse Architect

Precision Technologies; Mississauga; On-site; CAD 110,000 - 140,000; Full time

Job summary

Precision Technologies is seeking an experienced Power BI Developer with a strong BI and data warehousing background in Canada. You will design scalable data solutions, develop ETL processes, and transform complex data into actionable insights. Proficiency in DAX, SQL, Snowflake, and Python is essential.

You will build and optimize Power BI dashboards, collaborate with cross-functional teams, and ensure data quality, performance, and accessibility across platforms.

Qualifications

• 10+ years of BI development, data warehousing, and analytical query development.
• Mandatory hands-on experience with DAX for Power BI calculations and data analysis.
• Strong proficiency in advanced SQL, including complex queries, transformations and performance optimization.
• Hands-on experience with Snowflake and cloud-based data warehousing solutions.
• Practical experience using Python for data processing, manipulation, and automation.
• Experience developing Power BI reports, dashboards, data models, and visualizations.
• Understanding of ETL processes, data quality, and data integrity.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication and collaboration skills with business stakeholders.

Responsibilities

• Design, develop, and maintain scalable data warehousing solutions to support BI and reporting.
• Develop and manage ETL processes to ensure data accuracy and integrity.
• Write and optimize complex SQL queries for data extraction, transformation, analysis, and reporting.
• Apply advanced SQL techniques to improve query performance for analytics.
• Develop and maintain data models to optimize performance and data retrieval.
• Integrate and manage Snowflake data solutions across enterprise systems.
• Develop Python scripts to automate data processing and analytics workflows.
• Create, enhance, and maintain Power BI dashboards, reports, and visualizations.
• Develop and optimize DAX calculations, measures, and expressions for reporting.
• Collaborate with stakeholders to gather requirements and deliver actionable insights.
• Support API development and integration using PowerShell and REST APIs.
• Ensure data accessibility and interoperability across systems.

Skills

Power BI

DAX

Advanced SQL

Snowflake

Python

Data Warehousing

ETL

Data Modeling

BI Reporting and Analytics

Tools

PowerShell

REST APIs

OLAP Cube Development

Cloud Data Solutions

Job description

Precision Technologies is seeking an experienced Power BI Developer with a strong BI and data warehousing background in Canada. You will design scalable data solutions, develop ETL processes, and transform complex data into actionable insights. Proficiency in DAX, SQL, Snowflake, and Python is essential.

You will build and optimize Power BI dashboards, collaborate with cross-functional teams, and ensure data quality, performance, and accessibility across platforms.