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 Robust SQL, SSIS, data modelling, and warehousing knowledge Apply Power BI architecture, Databricks transformation, SQL, and data modelling expertise to Cencora’s business intelligence solutions.

📌 Business Intelligence Architect Power BI (Oakville)
🏢 Cencora
📍 Oakville