Business Intelligence Architect/Data Modeler

Jobgether; Canada; À distance; CAD 110 000 - 160 000; Plein temps

Avantages offerts par ce poste

Full-time employment

Remote work within Ontario

Healthcare coverage

Family-focused benefits

Parental and caregiver benefits

Wellness resources

Professional development

AI enablement initiatives

Résumé du poste

Jobgether is seeking an experienced Business Intelligence Architect/Data Modeler in Canada to design scalable data models and advanced reporting. You will leverage Power BI, Databricks, SQL, and SSIS to transform complex data into actionable insights for stakeholders and clients.

You will contribute to AI-enabled data initiatives, develop enterprise reporting frameworks, and ensure data quality and governance across teams. Remote work is available within Ontario with occasional travel up to 5%.

Qualifications

• Bachelor's degree in information systems, computer science, data analytics, or related field.
• 7–10 years in BI, analytics, reporting, or data development.
• At least 5 years with Databricks; relevant certifications desirable.
• 5+ years Power BI experience: dashboards, DAX, Power Query, data modelling, publishing.
• Strong SQL skills for data transformation and performance optimization.
• Experience with SSIS ETL workflows and traditional ETL.
• Exposure to Databricks or similar analytics platforms.
• Knowledge of data modelling, warehousing, semantic layers, BI architecture.
• Experience delivering reports for business users, leadership, and clients.
• Excellent written and verbal communication; able to translate needs into solutions.
• Ability to work independently, manage priorities, collaborate across teams.
• Experience in pharma/healthcare is advantageous.
• Familiarity with pharmacy services or healthcare functions is a plus.
• Experience with SAP BO, Crystal Reports, or advanced Excel reporting is beneficial.
• Willingness to travel about 5%.

Responsabilités

• Design, develop, and maintain Power BI dashboards, reports, scorecards, and visuals.
• Build data transformation and reporting solutions using Databricks, SQL, and BI technologies.
• Develop, optimize, and maintain SSIS ETL workflows across systems.
• Design robust data models, semantic layers, data warehouses, and reporting datasets.
• Collaborate with stakeholders to gather requirements and translate into solutions.
• Partner with IT and business teams to deliver end-to-end BI solutions.
• Establish standardized data extraction, integration, transformation, and structuring methods.
• Analyze large datasets to identify trends and opportunities; present findings clearly.
• Prepare datasets to support AI-enabled models and analytics initiatives.
• Apply healthcare knowledge to align reporting with operational needs.
• Deliver analytics capabilities for performance management and client reporting.
• Maintain data quality, governance, and documentation standards.
• Provide end-user training and support for BI assets.
• Communicate technical concepts to technical and non-technical audiences.
• Contribute to continuous improvement of BI standards and frameworks.
• Support travel up to 5% as needed.

Connaissances

Databricks

Power BI

SQL

ETL

Data modeling

Data warehousing

Formation

Bachelor's degree in information systems / computer science / data analytics

Outils

Databricks

SSIS

Power BI

Description du poste

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.

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