Business Intelligence Architect/Data Modeler

Jobgether; United States; Remote; USD 68,000 - 100,000; Full time

Benefits offered by this job

Remote work (Ontario) or flexible work

Healthcare coverage

Parental and caregiver benefits

Professional development

Mentorship opportunities

Employee engagement

Job summary

Jobgether is seeking a senior BI professional to design and maintain Power BI dashboards and data solutions. You will transform data from Databricks and other sources, build robust data models, and deliver enterprise BI reporting for stakeholders and clients.

You will collaborate across IT and business teams, ensure data quality, and drive analytics initiatives including AI-ready datasets, with occasional travel up to 5%.

Qualifications

• Bachelor's degree in information systems, computer science, data analytics, or related discipline.
• 7–10 years of relevant BI/analytics experience.
• 5+ years with Databricks and Power BI.
• Strong SQL, including data transformations, validation, and performance optimization.
• Experience with SSIS workflows and traditional ETL.
• Experience with modern data platforms (Databricks) for analytics engineering.
• Knowledge of data warehousing, data modeling, and semantic layers.
• Experience delivering BI solutions to diverse stakeholders.

Responsibilities

• Design, develop, and maintain Power BI dashboards, reports, scorecards, and analytics solutions.
• Build and support data transformation and reporting using Databricks, SQL, and BI technologies.
• Develop and maintain SSIS ETL workflows across multiple data sources.
• Create robust data models, semantic layers, data warehouses, and datasets for scalable analytics.
• Collaborate with stakeholders to gather requirements and translate them into technical solutions.
• Partner with IT teams to deliver end-to-end BI solutions.
• Establish standardized data extraction, integration, and structuring processes.
• Analyze large datasets to identify trends and opportunities and present findings clearly.
• Prepare data for AI-enabled models and emerging analytics initiatives.
• Apply healthcare/pharmacy domain knowledge to reporting aligned with operations.
• Maintain data quality, governance, and documentation standards.
• Provide user training and support for BI tools and assets.
• Communicate complex concepts clearly to technical and non-technical audiences.
• Contribute to continuous improvement of BI standards and processes.
• Travel up to 5% as needed.

Skills

Power BI

Databricks

SQL

SSIS

Data modeling

ETL

BI reporting

Stakeholder communication

Education

Bachelor's degree in information systems, computer science, data analytics, or related discipline

Tools

Databricks

SQL Server Integration Services (SSIS)

Power BI

SAP BI tools

Crystal Reports

Excel

Job description

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.