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-Ljbffr
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 Azure technologies, including Azure Data Factory and Databricks. This hybrid position requires onsite work four days a week. The role offers a competitive salary and stock options, contributing to improving outcomes for chronic care patients. #J-18808-Ljbffr
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 your extensive background in data warehouse architecture to develop and maintain effective ETL processes that support business intelligence efforts. Your collaborative work with stakeholders will ensure the alignment of technical solutions with strategic goals. This is your chance to innovate within the healthcare sector through data integration and governance.
Key Responsibilities:
• Design enterprise data models supporting governance
• Build ETL processes leveraging Azure Data tools
• Collaborate with teams to gather technical requirements
• Conduct performance tuning and issue resolution
• Maintain comprehensive technical documentation
Requirements:
• 15+ years in a related field with a degree
• 10+ years in data architecture and ETL design
• Cloud experience specifically with Azure
• Proficiency in Power Platform and Azure DevOps
• Strong analytical and problem-solving skills
Play a key role in enhancing data infrastructure and governance to drive better healthcare outcomes through innovative solutions.
#J-18808-Ljbffr
A healthcare technology company seeks a passionate individual for the role of Talent Acquisition Partner. Located in Burnaby, BC, this full-time position involves supporting and developing RCM software using Golang and MongoDB. Candidates should thrive in a team environment and possess a strong problem-solving ability. You will engage in architectural design and code reviews to ensure innovative solutions that enhance patient care. Join a mission-driven firm aiming to improve medication adherence for chronic care patients. #J-18808-Ljbffr
Base Pay Range
$120,000.00/yr - $175,000.00/yr
Talent Acquisition Partner at Altea Healthcare
Location:
This role is onsite at our office in Burnaby, BC.
Job Type:
Full-Time
Compensation Range:
$120,000-$175,000 CAD, depending on experience.
Our mission is to improve outcomes for Chronic Care patients who are dependent on multiple daily medications. Our proprietary and vertically integrated EMR technology solutions enable providers to enhance medication adherence through improved access, owned physician network, information.
Your Role
Support, design and develop RCM software covering the full stack Golang, React (TypeScript), Mongo DB.
Brainstorm with your team to conceptualize and build new features.
Experience with the Azure-based infrastructure and help us to leverage cloud technologies to ensure we can scale in line with customer adoption.
Partner with business analysts and other developers in order to fully understand product requirements and implement solutions which meet these requirements.
Provide technical leadership including architecture design, coding, code review, practices and skills development.
Candidate Profile
You thrive in a team environment but can also work independently.
You are passionate about using your technical knowledge and skills to solve real business problems and are motivated by understanding the value that your work adds.
A self‑starter that can manage their own workload and an ever‑growing task list.
A team player and leader.
Problem solving of potential roadblocks which could potentially impact patient care, strategic, and technical goals of the business.
Very proficient with server‑side languages Golang.
Proficiency with MongoDB.
Working knowledge of relational databases such as SQL Server, Azure SQL.
You are passionate about creating innovative and exciting new technology and want to provide end users with the best possible experience.
Have experience with Software Development Lifecycle (SDLC) including system requirements collection, architecture, design, development, testing, maintenance and enhancement across a variety of technologies.
Skills
Required Experience:
Golang
Solid web service: RESTful and SOAP
Nice to have:
Data modeling, UML and Design Patterns
Seniority Level
Mid-Senior level
Employment Type
Full-time
Job Function
Information Technology and Engineering
Industries
Hospitals and Health Care
Referrals increase your chances of interviewing at Altea Healthcare by 2x.
Get notified about new Full Stack Engineer jobs in Burnaby, British Columbia, Canada.
#J-18808-Ljbffr
Location:
This role is onsite 4 days a week at our office in Burnaby, BC and work from home one day a week.
Job Type:
Full-Time
Be a part of Aarista Technology growth, where we're reshaping the landscape of outpatient care and creating a space where innovation fosters better patient experiences and optimal health outcomes. Our mission is to bring hospital-quality technology, skilled clinicians, and value-based care management into the post-acute world. We offer an innovative compensation structure including competitive salaries, comprehensive benefits, bonuses, and stock options.
At the heart of our transformative approach lies our proprietary technology platform, Aarista. This cutting-edge platform has garnered recognition for its exceptional ability to reduce the overall cost of care while proactively elevating patient outcomes. Powered by artificial intelligence, unique clinical insights, and real-time data analytics, Aarista drives our connected model, enabling us to deliver unparalleled healthcare solutions.
Join the team that is redefining healthcare!
As a BI developer, you will step into a pivotal role within our organization, leveraging your extensive experience and expertise to lead the development of advanced Power BI solutions. You will be responsible for designing, developing, and deploying business intelligence solutions using Microsoft Power BI. You will collaborate closely with data analysts, stakeholders, and other Tech professionals to ensure data accuracy, optimize performance, and deliver insightful dashboards and reports that support decision‑making processes.
Responsibilities
Develop interactive and visually compelling Power BI reports, dashboards, and visualizations based on business requirements.
Create and optimize data models, DAX calculations, and queries to ensure efficient and reliable reporting.
Optimize report performance through proper data model design, query optimization, and report configuration.
Work with stakeholders to understand requirements, gather feedback, and iteratively enhance reports and dashboards.
Ensuring data security and compliance.
Partner with other Data Team members preparing scalable data sets for visualization ensuring data quality at each phase.
Create documentation for data models, processes, and reports. Conduct training sessions to empower users to leverage Power BI effectively.
Address any issues related to data accuracy, visualizations, and report performance.
Qualifications
2+ years of experience as a BI developer with excellent track record.
Experience in developing and optimizing complex Power BI solutions.
Having Experience with Microsoft Fabric/Azure Synapse
Proven ability to design and implement scalable data models.
In-depth knowledge of data integration techniques and tools.
Experience with data pipeline orchestration and automation.
Knowledge of DAX calculations, Power Query, and data modeling in Power BI.
Proficiency in SQL and data warehouse concepts.
Expertise in performance tuning and optimization of Power BI reports and SQL queries.
Expertise in implementing Row-Level Security (RLS) for both internal and external users, ensuring data access control and compliance.
Ability to architect end-to-end BI solutions, including data ingestion, storage, and presentation layers.
Ability to transform business requirements into technical specifications and intuitive visualizations.
Strong analytical thinking and problem-solving skills.
Excellent communication skills, with the ability to articulate complex data insights to non-technical stakeholders.
Ability to manage complex projects and deliver results.
Having a strong sense of data visualization and the ability to "tell a story" with data.
Attention to detail and ability to work independently.
Experienced in Power BI Embedding.
Certifications in Power BI are highly desirable.
Additional Skills
Having experience working with Microsoft Suite.
Familiarity with Agile tools such as Azure DevOps, GitHub, and SharePoint.
Understanding of data warehousing concepts and best practices.
Familiarity with ETL Processes.
Preferred Qualifications
Master's degree in a relevant field would be an asset.
#J-18808-Ljbffr
Join a vibrant research and development team as a Data Scientist in Burnaby, BC. This permanent, full-time position focuses on data analysis, software testing, and generating impactful reports.
As a Data Scientist, you will assess software applications and perform technical studies to support system upgrades. Your role will involve developing queries, optimizing network models, and conducting tests to maintain high quality. Familiarity with Java, MySQL, and Python is crucial for success in this position.
Key Responsibilities:
• Troubleshoot application software effectively
• Analyze business methods for effective system changes
• Create models to enhance data architecture
• Develop reports from extracted datasets
• Perform comprehensive tests and document outcomes
Requirements:
• Strong Java, MySQL, and Python skills
• Ability to thrive in fast-paced work settings
• Experience in business process management
• Proven capabilities in testing and quality assurance
• Authorized to work in Canada is mandatory
Utilize your data analysis expertise to contribute significantly in this full-time role in Burnaby.
#J-18808-Ljbffr
Job details
Location Burnaby , BC V5H 4W4
Salary 48.10 hourly / 32 to 40 hours per week
Terms of employment Permanent employment Full time
Work must be completed at the physical location. There is no option to work remotely.
Work setting
Research and development institution
Responsibilities
Assess and troubleshoot application software
Conduct business and technical studies to aid in decisions on system implementation or migration
Conduct research regarding availability and suitability of data
Data Science
Develop process and network models to optimize architecture
Develop queries and logic to generate reports
Extract information from unstructured sets of data
Write scripts related to stored procedures and triggers
Resolve conflict situations
Conduct tests and perform security and quality controls
Execute and document results of software application tests and information and telecommunication systems tests
Computer and technology knowledge
Java
MySQL
Python
Area of specialization
Business process management
Testing
Business methods analysis
Work conditions and physical capabilities
Ability to work independently
Fast-paced environment
Work under pressure
Who can apply for this job?
You can apply if you are:
a permanent resident of Canada
a temporary resident of Canada with a valid work permit
Do not apply if you are not authorized to work in Canada. The employer will not respond to your application.
#J-18808-Ljbffr
Transform healthcare analytics with Aarista Technology as a Business Intelligence Developer based in Burnaby, BC. This hybrid role emphasizes creating powerful Power BI solutions.
In this pivotal role, you will leverage your BI expertise to design innovative Power BI dashboards that drive business insights. Working directly with data analysts and stakeholders, you will ensure data accuracy and optimize performance. Your role is crucial in enhancing patient care and operational excellence.
Key Responsibilities:
• Craft interactive Power BI visualizations from business needs
• Optimize reports for performance and data quality
• Engage with stakeholders to refine reporting techniques
• Secure data compliance and integrity across solutions
• Train users on effective Power BI utilization
Requirements:
• 2+ years experience as a BI developer
• Expertise in Power BI, SQL, and data modeling
• Experience with Azure Synapse is a plus
• Strong analytical and communication abilities
• Familiar with performance tuning techniques
Utilize your skills in data visualization and storytelling to contribute to Aarista Technology's mission.
#J-18808-Ljbffr
