Business Intelligence Architect/Data Modeler

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 BI 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.