Remote Senior BI 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

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