Senior Data Warehouse/Bi Architect
Altea Healthcare
Job Title : Senior Data Warehouse/BI Architect
Location : Burnaby, BC
Work Setting : Hybrid, Monday to Friday. This role requires working onsite at our Burnaby, BC office
four days per week, with one day per week working from home.
Compensation : $140,000k CAD
Data Warehouse / BI Architect
Our mission is to improve outcomes for Chronic Care patients who are dependent on multiple daily medications. Our proprietary and vertically integrated EMR and RCM technology solutions enable providers to enhance medication adherence through improved access, owned physician network, information sharing, data analytics, and customizable insights.
We are looking for a highly skilled and experienced Data Engineer / Architect to join our team. In this role, you will be responsible for architecting and developing enterprise data models, data governance frameworks, ETL/pipelines, and analytics/reporting platforms to support performance measurement and business intelligence solutions for clinical, operation, finance and other revenue generated product lines.
Responsibilities
Design, build, and maintain data models to support metadata governance, request submissions, audit tracking, version control, and production publishing pipelines.
Architect multi-stage models for metadata lifecycle management, including intake submissions, staging, review, audit trail snapshots, approval tracking, and final publishing structures.
Develop and maintain ETL pipelines for metadata ingestion, transformation, validation, auditing, staging, and publishing processes supporting multi-layered data warehouse architectures.
Apply hybrid cloud integration expertise utilizing Azure SQL, Azure Data Factory, Databricks, Synapse Analytics, Azure Fabric and any other approved tools to develop and support scalable data pipelines and platform modernization initiatives.
Collaborate closely with business stakeholders to gather requirements and translate functional business needs into scalable technical data solutions.
Build Power Platform integrations (Power BI, PowerApps, Power Automate) connecting to data repository and cloud data services;
implement identity-based row-level filtering using Power Platform user context for submission-level security and role-based access control.
Maintain fully auditable data models including metadata change tracking, approval lineage, governance version control, and compliance documentation to support ATO certification, PMO audit packages, and federal regulatory standards.
Conduct advanced query tuning, stored procedure optimization, index management, query plan evaluation, blocking and deadlock resolution, and performance troubleshooting across large data platforms.
Develop and maintain comprehensive technical documentation including data dictionaries, entity-relationship diagrams (ERDs), data flow diagrams, process workflows, system architecture diagrams, metadata catalogs, data lineage models, dependency mappings, and PMO governance documentation packages.
Provide full lifecycle production support including ETL pipeline monitoring, failure remediation, long-running job resolution, scheduled job support, troubleshooting, and incident management across data environments.
QualificationsRequired Skills and Experience
Bachelor's degree in Computer Science, Information Technology, or related field with 15+ years (or commensurate experience)
10+ years of experience in relevant database development, data architecture, and ETL design.
8+ years of experience in data warehouse architecture, metadata governance, and analytics platforms.
Cloud experience with Azure.
Proficiency in Azure Data Factory, Databricks, Synapse Analytics, and hybrid cloud integration for modernizing ETL pipelines.
Experience with Azure DevOps for version control, CI/CD pipeline automation, and release management.
Experience with additional data platforms including Sql Server, Azure SQL, Mongo DB, Databrick.
Power Platform experience integrating Power BI, PowerApps, and Power Automate into enterprise reporting and data governance solutions.
Knowledge of metadata-driven design patterns, audit trail frameworks, and enterprise governance architecture aligned to federal PMO standards.
Strong technical documentation skills, including ERDs, data dictionaries, data flows, and process mapping.
Strong experience in performance tuning, query optimization, and long-running job remediation.
Excellent troubleshooting, problem-solving, and analytical skills across full data pipeline lifecycle.
Familiarity with federal compliance frameworks (ATO, FISMA, NIST 800-53, FedRAMP).
Expert in both relational data modeling and Star Schema
Skills Considered a Plus:
Microsoft Fabric platform (Power BI Premium, Data Warehousing, RLS security models).
Additional experience with MongoDB or Azure SQL
Python, PowerShell, or other scripting for ETL and automation.
experience working within federal data governance or VA PMO environments.
Job Types: Full-time
Pay: Competitive pay and benefits and invaluable startup stock options
#J-18808-Ljbffr
Location : Burnaby, BC
Work Setting : Hybrid, Monday to Friday. This role requires working onsite at our Burnaby, BC office
four days per week, with one day per week working from home.
Compensation : $140,000k CAD
Data Warehouse / BI Architect
Our mission is to improve outcomes for Chronic Care patients who are dependent on multiple daily medications. Our proprietary and vertically integrated EMR and RCM technology solutions enable providers to enhance medication adherence through improved access, owned physician network, information sharing, data analytics, and customizable insights.
We are looking for a highly skilled and experienced Data Engineer / Architect to join our team. In this role, you will be responsible for architecting and developing enterprise data models, data governance frameworks, ETL/pipelines, and analytics/reporting platforms to support performance measurement and business intelligence solutions for clinical, operation, finance and other revenue generated product lines.
Responsibilities
Design, build, and maintain data models to support metadata governance, request submissions, audit tracking, version control, and production publishing pipelines.
Architect multi-stage models for metadata lifecycle management, including intake submissions, staging, review, audit trail snapshots, approval tracking, and final publishing structures.
Develop and maintain ETL pipelines for metadata ingestion, transformation, validation, auditing, staging, and publishing processes supporting multi-layered data warehouse architectures.
Apply hybrid cloud integration expertise utilizing Azure SQL, Azure Data Factory, Databricks, Synapse Analytics, Azure Fabric and any other approved tools to develop and support scalable data pipelines and platform modernization initiatives.
Collaborate closely with business stakeholders to gather requirements and translate functional business needs into scalable technical data solutions.
Build Power Platform integrations (Power BI, PowerApps, Power Automate) connecting to data repository and cloud data services;
implement identity-based row-level filtering using Power Platform user context for submission-level security and role-based access control.
Maintain fully auditable data models including metadata change tracking, approval lineage, governance version control, and compliance documentation to support ATO certification, PMO audit packages, and federal regulatory standards.
Conduct advanced query tuning, stored procedure optimization, index management, query plan evaluation, blocking and deadlock resolution, and performance troubleshooting across large data platforms.
Develop and maintain comprehensive technical documentation including data dictionaries, entity-relationship diagrams (ERDs), data flow diagrams, process workflows, system architecture diagrams, metadata catalogs, data lineage models, dependency mappings, and PMO governance documentation packages.
Provide full lifecycle production support including ETL pipeline monitoring, failure remediation, long-running job resolution, scheduled job support, troubleshooting, and incident management across data environments.
QualificationsRequired Skills and Experience
Bachelor's degree in Computer Science, Information Technology, or related field with 15+ years (or commensurate experience)
10+ years of experience in relevant database development, data architecture, and ETL design.
8+ years of experience in data warehouse architecture, metadata governance, and analytics platforms.
Cloud experience with Azure.
Proficiency in Azure Data Factory, Databricks, Synapse Analytics, and hybrid cloud integration for modernizing ETL pipelines.
Experience with Azure DevOps for version control, CI/CD pipeline automation, and release management.
Experience with additional data platforms including Sql Server, Azure SQL, Mongo DB, Databrick.
Power Platform experience integrating Power BI, PowerApps, and Power Automate into enterprise reporting and data governance solutions.
Knowledge of metadata-driven design patterns, audit trail frameworks, and enterprise governance architecture aligned to federal PMO standards.
Strong technical documentation skills, including ERDs, data dictionaries, data flows, and process mapping.
Strong experience in performance tuning, query optimization, and long-running job remediation.
Excellent troubleshooting, problem-solving, and analytical skills across full data pipeline lifecycle.
Familiarity with federal compliance frameworks (ATO, FISMA, NIST 800-53, FedRAMP).
Expert in both relational data modeling and Star Schema
Skills Considered a Plus:
Microsoft Fabric platform (Power BI Premium, Data Warehousing, RLS security models).
Additional experience with MongoDB or Azure SQL
Python, PowerShell, or other scripting for ETL and automation.
experience working within federal data governance or VA PMO environments.
Job Types: Full-time
Pay: Competitive pay and benefits and invaluable startup stock options
#J-18808-Ljbffr
Vacancy posted 1 hour ago
Similar jobs that could be interesting for youBased on the Senior Data Warehouse/Bi Architect in Winnipeg, MB vacancy
- Precision Technologies is seeking an experienced Power BI Developer with a strong BI and data warehousing background in Canada. You will design scalable data solutions, develop ETL processes, and transform complex data into actionable insights. Proficiency in DAX, SQL, Snowflake...SeniorBusiness intelligence
- A healthcare technology company in Burnaby is seeking a Senior Data Warehouse/BI Architect to lead the design and development of enterprise data models and ETL pipelines. The ideal candidate will have over 15 years of experience in data architecture and a strong background in...SeniorBusiness intelligence
- ...client is looking for a highly experienced BI professional to take on a senior architecture-focused role within a complex enterprise data environment. This is an opportunity for... ...reporting applications and the underlying data warehouse. The candidate will help determine how...SeniorBusiness intelligenceRemote workFlexible hours
- Advance your career as a Senior Data Warehouse & BI Architect focused on building innovative data solutions in a hybrid work setting. Your expertise will drive impactful decisions in healthcare by enhancing data accessibility and governance. In this role, you’ll leverage...SeniorBusiness intelligence
- ...Kraft Heinz in Toronto is seeking a Senior Data Architect to lead domain data architecture and develop scalable data products. You will collaborate... ...deliver robust data models and semantic layers that support BI and AI use cases. The role emphasizes data warehouse expertise...SeniorBusiness intelligence
- Teacup Tech Systems Inc in Toronto, ON is seeking a Senior Business Intelligence Specialist. You will design, develop and optimize BI dashboards, working closely with PMs, designers and QA to deliver data-driven insights for business decisions. The role requires 3+ years in...SeniorBusiness intelligence
- ...teamwork and collaboration, we’re building a stronger, more resilient Stantec every day. Your OpportunityWe are seeking an Oracle BI/Data Warehouse Developer with strong experience across the Oracle analytics and reporting ecosystem. This role focuses on translating business...Business intelligenceLong term contractFull timeTemporary workPart timeCasual work
- ...seeking a Sr. Business Intelligence Specialist to deliver and support advanced BI solutions across various sectors. The ideal candidate will have over 10 years of experience in analytics and data management, a strong background in tools such as Power BI and Tableau, and excellent...SeniorBusiness intelligence
- ...Simons is seeking a senior data & BI professional to maximize enterprise data value, report to the Director, IT – Data, BI & AI, and design analytical solutions to support strategic business decisions. You will develop dashboards, KPIs, and BI reports, ensuring data quality...SeniorBusiness intelligence
- There is a 6 months contract opportunity for Data Warehouse Architect in Hamilton, Ontario. Candidate must be enthusiastic about system architecture, big-data processing, data modelling, advanced quantitative data-driven models, data visualization, and performance optimization...Contract workInternship
- Astra-North Infoteck Inc. seeks a senior data engineer to design and develop scalable ETL/ELT processes, and to optimize loading and transformation... .... You will collaborate with stakeholders to model data warehouses and build dashboards using Tableau. The role requires strong...SeniorBusiness intelligence
- We are looking for a Senior Data and BI Analyst who will report to the team lead of the Data Quality to Insights team, and who’ll be tasked with... ...(commercial team, product owners, projects owner, data architect,data engineer) to align the needs and coordinator the efforts...SeniorBusiness intelligenceSummer workFlexible hours
- ...enterprise business intelligence with Power BI, Snowflake, and modern data architecture across Canada and the... ...Director, Data and Analytics, this senior role builds trusted, consistent, self... ...SQL, ETL, dimensional modelling, and warehouse expertiseBilingual French and English...SeniorBusiness intelligence
- A leading consulting firm in Toronto is looking for a Senior Information Architect to enhance their data models and oversee project requirements. You will lead assessments and present findings, requiring a strong background in information architecture principles and tools like...SeniorBusiness intelligence
- ...Architect contact centre reporting for APEX at Miratech, combining Genesys, Verint, Databricks, and Kimball modeling in hybrid Toronto work. The Senior Data Architect will turn complex telephony and quality requirements into auditable data solutions. You will design ingestion...Senior
- ...Shape CATC’s Azure SQL data warehouse using advanced SQL, relational modelling, and dbt. This permanent, full-time role connects critical business... ...ETL/ELT processes from multiple source systems Support Power BI developers and business analysts with warehouse datasets...Business intelligencePermanent employmentFull time
- Fidelity Canada is seeking a Data Analyst and Reporting Tools Developer to support executives and business units with advanced reporting... ...tools and enhance existing databases, using SQL, VBA, Excel, and BI platforms. The role emphasizes data integrity, efficiency, and collaboration...Business intelligenceRemote work
- The Government of Alberta is seeking a Senior Data Architect to lead data architecture, modelling, profiling, and data warehouse activities for the JIMS 3.0 project. You will assess existing data marts, define future-state architecture, develop data models and mapping specifications...SeniorRemote work
- # Senior BI & Data AnalystMontreal, QC (Hybrid)Full-timeAt Flex Travel Solutions, we foster an environment of passion, innovation and collaboration... ...with the data engineering team to ensure data pipelines and warehouse structures meet analytical needs.* Conduct ad hoc analyses to...SeniorBusiness intelligenceWork at office
- ...Oracle database, OBIEE tools, dimensional data modeling, data warehouse design, ETL design and development... ...· Takes directions from and works with senior members of the Application Management team... ...knowledge of ODI· Solid knowledge of BI Publisher· Solid knowledge of PL/SQL and...SeniorBusiness intelligence
- ...Pathlion is looking for a Senior Data Architect to lead a crucial data integration project focused on the Justice Information Management System (... ...architecture, oversee ETL processes, and develop interactive Power BI reports while ensuring data quality and governance. This role...SeniorBusiness intelligence
$110 per hour
SENIOR DATA ARCHITECT (JIMS 3.0 – Justice Data Warehouse) Requisition #: R26-3576 (GOAPRDJP00000995) Location: Primarily Remote (within Canada – *See Work Model below) Engagement Type: Contract Number of Resources required: 1 Rate (CAD): Up to $110.00...SeniorBusiness intelligenceHourly payContract workFor contractorsInternshipRemote work- Role Summary As a Data Architect, you will be providing our clients with your knowledge and experience... ...issues in Snowflake, manage virtual warehouses, implement clustering keys, and apply... ...governance frameworks. Familiarity with BI tools like Microstrategy, Tableau, or Power...SeniorBusiness intelligence
$96.2k - $120.2k per year
Job DescriptionSenior Data Architect at a glance... LocationToronto, ON Hybrid3 days/week... ...following established standards, supporting BI reporting, AI applications, and... ...actionable insights. Strong background in data warehouse implementation. Experience in designing...SeniorBusiness intelligenceFlexible hours- About the Job: how we work by harnessing the power of AI, data, and digital innovation to accelerate the discovery and development of... ...our customers and, ultimately, improve patients’ lives.As a Senior BI & Data Analyst, you’ll be a key driver of insight and innovation...SeniorBusiness intelligenceInternship
- Power BI expertise meets business intelligence at Michelin’s Magog research center, with... ...work and three weekly onsite days.As Senior Data Analyst for Steering Beyond Road, you will... ...prepare actionable analysesManage Data Lake, warehouse, and external database sourcesProvide...SeniorBusiness intelligence
- Power BI expertise meets business impact in Michelin’s hybrid Senior Data Analyst position, based at the Magog research center three days weekly.As Senior Data Analyst... ...data for business reportingManage Data Lake, warehouse, and external database sourcesPromote governance...SeniorBusiness intelligence
- Role OverviewAs a Senior Data Architect, you'll lead the design and implementation of modern data platforms for enterprise clients across Energy... ...-state architectures (lakehouse, data mesh, modern data warehouse) Create detailed technical roadmaps with phased implementation...SeniorBusiness intelligenceWork at officeRemote workHome officeFlexible hours2 days per week
- ...Analyst Technical Solutions seeks a skilled data warehousing/BI professional to design, develop and test ETL processes, reports and dashboards... ...Agile environment. The successful candidate will craft data warehouse solutions, contribute to dimensional modeling and deploy BI systems...SeniorBusiness intelligence
- Power BI expertise meets hybrid work at Michelin’s Magog research center for a Senior Data Analyst supporting business decisions through actionable insights.As Senior Data Analyst... ...supporting decision-makingManage Data Lake, warehouse, and external database sourcesPromote...SeniorBusiness intelligence
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Senior Data Warehouse/Bi Architect. Be the first to apply!
Related searches
- senior disability case manager Winnipeg, MB
- senior hardware engineer Winnipeg, MB
- senior cook Winnipeg, MB
- amica senior lifestyles Winnipeg, MB
- senior building operator Winnipeg, MB
- senior project manager Winnipeg, MB
- senior communications Winnipeg, MB
- sr. IT support analyst Winnipeg, MB
- senior marketing Winnipeg, MB
- senior manager investigations Winnipeg, MB

