This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Business Intelligence Architect/Data Modeler based inCanada. We are seeking an experienced Business Intelligence Architect/Data Modeler to design and deliver scalable data models, advanced reporting solutions, and actionable business intelligence that supports strategic decision-making. In this role, you will leverage Power BI, Databricks, SQL, and ETL technologies to transform complex data into meaningful insights for business stakeholders and clients. You will play a key role in developing enterprise reporting frameworks, strengthening data quality, and enabling self-service analytics across multiple business functions. Working closely with data engineering, IT, application development, and business teams, you will translate operational needs into reliable, high-performing analytics solutions. You will also contribute to AI enablement by preparing structured datasets and supporting modern data transformation initiatives. This opportunity is ideal for a technically strong, analytical professional who enjoys solving complex data challenges and communicating insights in a collaborative, business-focused workplace. The position is full-time, with remote work available within Ontario and occasional travel as required. Accountabilities
- Design, develop, and maintain Power BI dashboards, reports, scorecards, and visual analytics solutions that deliver accurate, actionable insights to business stakeholders.
- Build, enhance, and support modern data transformation and reporting solutions using Databricks, SQL, and enterprise business intelligence technologies.
- Develop, optimize, and maintain SSIS ETL workflows to extract, transform, and load data from multiple internal and external systems.




- Design and maintain robust data models, semantic layers, data warehouses, and reporting datasets that enable scalable analytics, consistent reporting, and self-service business intelligence.
- Collaborate with internal stakeholders and external clients to gather business requirements, understand reporting needs, and translate them into effective technical solutions.
- Partner with data engineering, infrastructure, networking, web development, application development, and other IT teams to design and deliver end-to-end BI solutions.
- Establish standardized approaches for extracting, integrating, transforming, and structuring data from diverse enterprise and operational sources.
- Analyze large and complex datasets to identify trends, patterns, risks, and performance opportunities, presenting findings in clear, business-oriented formats.
- Prepare and structure high-quality datasets to support AI-enabled models and emerging analytics initiatives.
- Apply relevant healthcare, pharmaceutical, and pharmacy services knowledge to develop reporting solutions aligned with operational requirements and business priorities.
- Deliver analytics and reporting capabilities that support business performance management, customer reporting, operational insights, and strategic initiatives.
- Maintain data quality, integrity, consistency, and governance through established validation processes, documentation standards,



and reporting best practices.
- Produce and maintain comprehensive technical and functional documentation, including data definitions, report logic, ETL workflows, and solution specifications.
- Provide end-user training, technical support, and knowledge transfer to improve adoption and effective use of BI tools and reporting assets.
- Communicate technical concepts and analytical findings clearly to technical and non-technical audiences, helping stakeholders understand data-driven recommendations.
- Contribute to continuous improvement of BI development standards, reporting frameworks, analytics processes, and enterprise data capabilities.
- Support additional projects and business priorities as required, including occasional travel of up to 5%. Requirements
- A bachelor's degree in information systems, computer science, data analytics, or a related discipline.
- Between 7 and 10 years of relevant experience in business intelligence, business analytics, reporting, data development, or related technical roles.
- At least five years of hands‑on experience with Databricks; relevant certifications are highly desirable.
- At least five years of practical Power B I experience, including dashboard development, report design, DAX, Power Query, data modelling, and publishing best practices.
- Strong SQL skills, including complex querying, data transformation, data validation, and query performance optimization.
- Demonstrated experience developing and maintaining SSIS workflows and traditional ETL or data integration solutions.
- Experience with modern data platforms, particularly Databricks or comparable technologies used for analytics engineering and data transformation.
- S

📌 Business Intelligence Architect/Data Modeler (Canada)
🏢 Jobgether
📍 Canada