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.
Qualifications
Required 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-LjbffrVacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the Senior Data Warehouse/BI Architect in Burnaby, BC vacancy
$105.4k - $158.1k per year
...stronger, more resilient Stantec every day. We are seeking a Senior Data Architect to join a project team that will be designing new workflows... ...document and communicate these designs. Knowledge of data warehouse architecture and modelling (e.g., facts/dimensions for BI...SeniorBusiness intelligenceLong term contractFull timeTemporary workPart timeCasual workStantec Consulting International Ltd.
Burnaby, BC2 days ago$65k - $75k per year
...Burnaby, BC (Hybrid) Job Title: Power BI Developer Position Type: Full-Time (... ...Power BI Developer (Contract) to support data visualization, reporting modernization, and... ...Experience working in an Enterprise Data Warehouse environment (e.g., hybrid AWS and Azure data...Business intelligenceFull timeContract workWork at officeWork from homeMonday to friday- ...exciting journey with us! About the Role We are looking for a Data Analyst to help make our data more useful, reliable, and... ...recurring reports using tools such as Superset, Tableau, Looker, or Power BI. ~ A good foundation in analytical thinking and basic statistics...Business intelligenceFull timeLocal area
$30 per hour
Overview Languages English Education ~ Secondary (high) school graduation certificate Experience 1 year to less than 2 years On site Work must be completed at the physical location. There is no option to work remotely. Work setting Industrial...SuggestedPermanent employmentFull timeRemote work- ...commitments. An opportunity for career development across many business departments within our organization. Scope of Position The Warehouse Associate supports overall warehouse operations with a primary focus on wire and cable cutting. This role is responsible for...SuggestedFlexible hours
$30 per hour
Education: Expérience: Education Secondary (high) school graduation certificate Work setting Industrial facility or establishment Manufacture Type of product ~ Industrial supplies Computer and technology knowledge ~ MS Office Parts specialization...Permanent employmentFlexible hoursShift workNight shiftDay shiftB.C. Air Filter LTD.
Burnaby, BC3 days ago- ...opportunities for everyone. Our Burnaby studio is seeking a Landscape Architect IV – Design and Community Planning. This is a newly created... ...considerations. Collaborate with Project Managers and senior leadership to maintain strong client relationships. Participate...SeniorFull timeInternshipWork at officeLocal areaWorldwideFlexible hours
- ...hours: Monday to Friday from 8am - 4:30pm PST Onsite Role: This position is required to be onsite 5 days a week Role Summary The Warehouse Assembly Clerk assembles, boxes, labels, and bags Product and Promotional Packages. In addition, the Warehouse Assembly Clerk will...Full timeMonday to friday
- Direct and control the operations of commercial facilities Evaluate the operations of facilities and the included real estate Oversee the preparation of reports and statistics related to areas of responsibility Plan and organize the operations of the facilities and...
$18 per hour
...Responsibility: We are preparing for a busy Mother's Day and Summer season and seek to hire multiple positions (FT, PT and Temporary) for our warehouse operations. Close to transit and with a variety of schedules and a 7 day a week operation, there is lots of opportunity - join us at...Hourly payPermanent employmentFull timeTemporary workPart timeSummer workCasual workSeasonal workRelocationMonday to fridayFlexible hoursShift workAfternoon shiftEarly shift- ...Machine Learning Maestro: You don’t just work with data—you decode it, predict the future with it, and turn it into action. Your models... ...how they work under the hood. Hands-on experience with data warehouses. BigQuery or similar? Check. You understand how to design,...Casual workInternshipWork at officeRemote work
- ...complex, real world challenges. Technology is just our tool. \ The Role \ \ RedMane has a full\-time opportunity for a Technical Architect as we continue to grow our Vancouver based practice. The Technical Architect is a hands\-on role responsible for architecture and...Long term contractFull timeTemporary workWork at officeRemote workFlexible hours
$45 per hour
...Job Posting: Warehouse Manager (NOC 70012) Company: Gia Foods Ltd. Location: 104 8288 North Fraser Way Burnaby, BC V3N 0E9 Position Type: Full-time, Permanent Wage: $45 per hour + 4% vacation pay Hours: 30 hours per week Number of Vacancies:1 Start Date: As soon...Hourly payPermanent employmentFull timeImmediate start- ...day. Purpose of the Role As the Senior Financial Analyst , you will play a key role... ...and automation of Svante’s reporting, data, budgeting, and financial planning systems.... ...management projects. ~ Experience using Power BI or equivalent analytics platforms to...SeniorFull timeWork at office
$85k - $100k per year
...Position Overview We are seeking a Senior Accountant to join the Corporate Accounting... ...with Yardi, CaseWare Exposure to Power BI, automation, or AI tools $85,000 - $100... ...If you would like more information about how your data is processed, please contact us....SeniorFull time$110k - $145k per year
...Mexico. Our backend processes millions of GPS data points daily across multiple receiver... ...first, Cloud-native, Headless) and need a senior backend engineer to co-own that evolution.... ...Paid vacation, holidays, and sick days Architect-track career progression Work across the...SeniorFull timeContract work- ...edge computing. Its Codensity portfolio enables enterprise, cloud data centers, and content providers to deploy high-performance... ...design engineer, you will be responsible to work closely with system architects and design lead on the design of a sub-system in SoCs....SeniorPermanent employmentFull timeWork at officeFlexible hours
$96.4k - $142.66k per year
...tooling spanning AWS, GCP, and on-premises data centers across multiple global regions.... ...and the team takes that seriously! The Senior SRE at 2K is a hands-on technical leader —... ...partnering with network engineers, systems architects, and game studio developers. This is an ownership...SeniorTemporary workInternshipVisa sponsorship$96.4k - $142.66k per year
...encourage you to apply! What We Need We're looking for a Senior Gameplay Software Engineer to own the character movement and player... ...mechanics with prediction, rollback, and server authority ● Architect and extend character movement using CMC or Mover Plugin ●...SeniorFull timeTemporary workInternship$160k - $235k per year
...Responsibilities Infrastructure Architecture & Cluster Operations Architect Dedicated Environments: Lead the design and implementation of... ...IaC tools. Scripting & Backend: Python (primary), Bash. Data & Storage: Redis, Milvus (Vector DB), Postgres....SeniorFull timeInternshipWork at officeLocal areaImmediate startVisa sponsorshipFlexible hours$105.66k - $142.72k per year
...to level up our team, we encourage you to apply! What We Need We are seeking a highly qualified and creative Senior Gameplay Systems Engineer to architect and build our next-generation Cinematic and Narrative Tooling within the Unreal Engine 5 (UE5) framework. This pivotal...SeniorFull time$125k - $145k per year
...Starting Salary: $125,000-$145,000/annum The Opportunity: The Senior Sourcing Specialist is responsible to drive strategic sourcing... ...supply strategy; contract and supplier performance management. Data analytics, sourcing, procurement systems, and customer service....SeniorFull timeContract workWork at officeVisa sponsorshipWork visa- ...AECOM is looking for a highly organized and detail-oriented Senior Procurement Specialist to join our team in procuring water/wastewater... ...Excellent analytical skills with the ability to interpret complex data and make informed decisions. ~ Strong communication and...SeniorFull timeContract workLocal areaWorldwideFlexible hours
- ...AECOM Buildings + Places, is seeking a motivated and skilled Senior Mechanical Engineer to help lead buildings projects (commercial... ...coordinate work with engineers and technicians of other disciplines and architects. Strong communication skills, spoken and written. Able to...SeniorFull timeInternshipWork at officeLocal areaWorldwideRelocationFlexible hours
$35 - $41 per hour
...excellent opportunity to join a company that is helping shape a more connected and sustainable future across Canada. Your New Role The Data Centre Operator will be responsible for the oversight of a mission-critical facility in Burnaby. You will be responsible for monitoring...Long term contractPermanent employmentFor contractorsNight shiftDay shift- ...management with real-time Google Maps(tm) view of asset location and data, reporting, maintenance, and a variety of fleet management... ...Position Overview We're on the lookout for a full-time Senior Ruby on Rails Engineer to join our dynamic team. Whether you're...SeniorFull timeInternshipWork at officeRemote work
$48k - $94k per year
...Our team has an immediate 12-month contract opening for a Senior Technical Recruiter. About the Job: Conduct full-cycle recruitment... ...ability to make informed decisions and recommendations based on data and insights. Demonstrated ability to adapt to changing needs...SeniorContract workImmediate start$95k - $105k per year
...join us. Operating as the financial lynchpin of the project, the Senior Project Accountant (“Sr PA”) partners closely with development... ...hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us....SeniorFull timeContract workInterim roleInternshipFlexible hours$100k - $135k per year
...technologists? If so, we want to hear from you! ISL is seeking a Senior Structural Technologist to join our expanding structures team in... ...About Us We are engineers, technologists, planners, landscape architects, scientists, and support teams that work together to deliver infrastructure...SeniorFull timeInternshipWork at officeRemote workFlexible hours$75.4k - $111.58k per year
...sports, shooters, action, role-playing, strategy, casual, and family entertainment. Our team of engineers, marketers, artists, writers, data scientists, producers, thinkers and doers, are the professional publishing stewards of 2K’s portfolio currently includes several AAA,...SeniorFull timeCasual work
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 financial accountant Burnaby, BC
- senior project accountant Burnaby, BC
- construction senior project manager Burnaby, BC
- senior graphic designer Burnaby, BC
- senior business analyst Burnaby, BC
- working with seniors Burnaby, BC
- senior business data analyst Burnaby, BC
- senior designer Burnaby, BC
- senior delivery manager Burnaby, BC
- senior administrative assistant Burnaby, BC