Business Intelligence Architect/Data Modeler

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 environment. The position is full-time, with remote work available within Ontario and occasional travel as required.

• 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.
• Strong knowledge of data modelling, data warehousing principles, semantic layers, and end-to-end business intelligence architecture.
• Experience delivering reporting and analytics solutions for diverse stakeholders, including business users, senior leadership, and external clients.
• Excellent written and verbal communication skills, with the ability to explain complex technical concepts and analytical findings in clear, accessible language.
• Strong analytical thinking, problem-solving, and requirements-gathering skills, with the ability to translate business needs into practical technical solutions.
• Demonstrated ability to work independently, manage competing priorities, and collaborate effectively across business and technical teams.
• Experience in the pharmaceutical, healthcare, or another regulated industry is an advantage.
• Familiarity with pharmacy services, specialty pharmacy operations, patient support programs, reimbursement services, or related healthcare functions is preferred.
• Experience with additional reporting tools such as SAP BusinessObjects, Crystal Reports, or advanced Excel-based reporting is beneficial.
• Familiarity with data governance, reporting controls, enterprise reporting standards, and quality assurance processes is an asset.
• Experience supporting internal operational reporting and external client-facing analytics, as well as training end users and encouraging BI adoption, is desirable.
• Willingness to travel occasionally, up to approximately 5%, as business needs require.

Benefits

• Full-time employment: A stable, full-time opportunity within a data-driven professional environment.
• Flexible work arrangements: Remote work options within Ontario, with Oakville also listed as a work location.
• Comprehensive healthcare coverage: Medical, dental, and vision benefits.
• Family-focused support: Potential access to backup dependent care, adoption assistance, infertility coverage, and family-building resources, subject to eligibility.
• Parental and caregiver benefits: Paid parental leave and paid caregiver leave, subject to applicable policies.
• Wellness resources: Access to behavioral health solutions and programs supporting physical, emotional, financial, and social well-being.
• Professional development: Training programs, career development resources, and opportunities to participate in mentorship initiatives.
• Employee engagement: Opportunities to join employee resource groups and participate in volunteer activities.
• Technical and professional growth: The opportunity to work with modern data platforms, enterprise analytics, data modelling, and AI-enablement initiatives.
• Meaningful impact: Help improve business decision-making and operational performance through reliable data, insightful reporting, and scalable analytics solutions.
• Inclusive workplace: Join an environment committed to equal employment opportunities, accessibility, diversity, and professional development.