Power BI and Databricks expertise define this full-time Business Intelligence Architect role with Cencora in Oakville, Ontario, or remotely within Ontario.
This role designs business intelligence solutions for stakeholders, clients, and cross-functional teams. You will build dashboards, data models, semantic layers, and reporting datasets. SQL, SSIS, DAX, Power Query, data warehousing, and ETL development support scalable analytics and trusted decision-making.
Key Responsibilities:

Design Power BI dashboards, reports, scorecards, and visual analytics
Build Databricks, SQL, and enterprise reporting solutions
Create data models, semantic layers, and reporting datasets
Gather requirements and translate needs into technical solutions
Analyze complex datasets and present business-relevant findings
Requirements:

Bachelor’s degree in a related technical or analytical field
Seven to ten years of directly related experience
Five-plus years of hands-on Databricks experience
Five-plus years using Power BI, DAX, and Power Query
Strong SQL, SSIS, data modelling, and warehousing knowledge
Apply Power BI architecture, Databricks transformation, SQL, and data modelling expertise to Cencora’s business intelligence solutions.

#J-18808-Ljbffr

Business Intelligence Architect Power BI