Data Warehouse Architect
2i Solutions, Inc
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 in large scale databases.
Develop conceptual, logical, and physical data models as part of an Enterprise Data Warehouse.
Develop design standards, naming conventions, ETL processes, and test plans for the Enterprise Data Warehouse.
Standard working day is equal to 7.5 Hours.
Candidates will be expected to work onsite in Hamilton, Ontario, Canada at locations designated by HHSC from time to time;
1.0 The Digital Health Plan: Data, Analytics & Planning project is a multi-year program to invest in Hamilton Health Science’s (HHS) data and analytics capabilities.Our project team will build and operate an Enterprise Data Warehouse that integrates data from dozens of different source systems and implement a leading analytics platform for data visualization.
These tools will help HHS harness our data to make smarter decisions about how we serve our patients and how we operate our hospital system.
2.0 This agile data architecture and integration project is fast paced, collaborative and highly technical: team members will model and integrate data from dozens of systems then create complex quantitative models and high caliber visualizations in support of decision making.Candidate DescriptionCandidate must be enthusiastic about system architecture, big-data processing, data modelling, advanced quantitative data-driven models, data visualization, and performance optimization in large scale databases. Candidate can envision, and lead a team to implement architectures for high volume near-real-time ingestion, transformation and visualization of data while ensuring data quality, broad accessibility and high security, all while protecting the privacy of our most important stakeholders – our patients.
The prospect of working with large volumes of healthcare data is an ideal position for the candidate .
Specific types of deliverables for this engagement will be3.0 Develop conceptual, logical, and physical data models as part of an Enterprise Data Warehouse unifying administrative and clinical systems. The overall model should consider all source systems, but will focus on key areas initially such as Lab, Pharmacy, Patient Demographics, General Ledger;
4.0 Develop design standards, naming conventions, ETL processes, and test plans for the Enterprise Data Warehouse;
5.0 Design robust, reusable and scalable data solutions and pipeline frameworks to automate ingestion, processing and delivery of batch and real-time streaming data;
6.0 Ensure on-going alignment of new and existing data initiatives with the target state data architecture;
7.0 Define standards and best practices for enterprise data management framework;
8.0 Play an active role in all stages of a data solution life cycle: acquisition, ingestion, curation, publication, quality and metadata to ensure consistency with data management standards and best practices;
and
9.0 Assistin the selection of data management tools required to expand our platform capability.
#J-18808-Ljbffr
Candidate must be enthusiastic about system architecture, big-data processing, data modelling,
advanced quantitative data-driven models, data visualization, and performance optimization in large scale databases.
Develop conceptual, logical, and physical data models as part of an Enterprise Data Warehouse.
Develop design standards, naming conventions, ETL processes, and test plans for the Enterprise Data Warehouse.
Standard working day is equal to 7.5 Hours.
Candidates will be expected to work onsite in Hamilton, Ontario, Canada at locations designated by HHSC from time to time;
1.0 The Digital Health Plan: Data, Analytics & Planning project is a multi-year program to invest in Hamilton Health Science’s (HHS) data and analytics capabilities.Our project team will build and operate an Enterprise Data Warehouse that integrates data from dozens of different source systems and implement a leading analytics platform for data visualization.
These tools will help HHS harness our data to make smarter decisions about how we serve our patients and how we operate our hospital system.
2.0 This agile data architecture and integration project is fast paced, collaborative and highly technical: team members will model and integrate data from dozens of systems then create complex quantitative models and high caliber visualizations in support of decision making.Candidate DescriptionCandidate must be enthusiastic about system architecture, big-data processing, data modelling, advanced quantitative data-driven models, data visualization, and performance optimization in large scale databases. Candidate can envision, and lead a team to implement architectures for high volume near-real-time ingestion, transformation and visualization of data while ensuring data quality, broad accessibility and high security, all while protecting the privacy of our most important stakeholders – our patients.
The prospect of working with large volumes of healthcare data is an ideal position for the candidate .
Specific types of deliverables for this engagement will be3.0 Develop conceptual, logical, and physical data models as part of an Enterprise Data Warehouse unifying administrative and clinical systems. The overall model should consider all source systems, but will focus on key areas initially such as Lab, Pharmacy, Patient Demographics, General Ledger;
4.0 Develop design standards, naming conventions, ETL processes, and test plans for the Enterprise Data Warehouse;
5.0 Design robust, reusable and scalable data solutions and pipeline frameworks to automate ingestion, processing and delivery of batch and real-time streaming data;
6.0 Ensure on-going alignment of new and existing data initiatives with the target state data architecture;
7.0 Define standards and best practices for enterprise data management framework;
8.0 Play an active role in all stages of a data solution life cycle: acquisition, ingestion, curation, publication, quality and metadata to ensure consistency with data management standards and best practices;
and
9.0 Assistin the selection of data management tools required to expand our platform capability.
#J-18808-Ljbffr
Vacancy posted 1 hour ago
Similar jobs that could be interesting for youBased on the Data Warehouse Architect in Winnipeg, MB vacancy
- 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...SuggestedFull timeInternshipWork at officeMonday to friday1 day per week
- ...Shape CATC’s Azure SQL data warehouse using advanced SQL, relational modelling, and dbt. This permanent, full-time role connects critical business systems. The Data Engineering & Platforms Manager owns the technical operation and continuous improvement of CATC’s enterprise...SuggestedPermanent employmentFull time
- 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...Suggested
- ...being a part of this, consider applying for the following opportunity Who We're Looking For We’re looking for a hands-on Data Solution Architect to design and deliver scalable, secure, and reusable data solutions. What You’ll Do Design Data Solutions Analyze...SuggestedInternship
- 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...Suggested
- ...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...
- 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...
- Job Title: Senior Cloud Data Warehouse EngineerLocation: Montreal, QC (Hybrid – 3 days onsite every week)Employment: Full-time opportunityExperience... ...: Snowflake SnowPro Core is required; SnowPro Advanced Architect/Data Engineer is a plus.Experience with DBT is advantageous....Full time3 days per week
$150k per year
...focused problem solvers who thrive on complex data challenges. Guided by our values of Care,... ...make us great. Role SummaryAs a Data Architect at Project X Ltd., you will be providing... ...issues in Snowflake, manage virtual warehouses, implement clustering keys, and apply best...Full time$110k - $140k per year
Data. Discovery. Better Health. ICES is a world-leadinghealth research and analytics... ...Program Introduction:ICES is seeking a Data Architect to join our Data Quality and Information... ..., including data models, data warehouses, data integration frameworks, metadata management...Full timeWork at officeRemote workFlexible hours- Job Title – Senior Data Architect (Enterprise Data Warehouse & Business Intelligence) Location – Edmonton, AB (Remote) (Travel once a month for onsite meetings in Edmonton, AB) Employment Type – Contract Interview Mode – Virtual Interview About the RoleThe Government...Contract workFor contractorsInternshipRemote work
- 87378# Data ArchitectMontrealHybridArchitecture and Technology GovernanceApplyWith over 30 years of recognized expertise, COFOMO is now... ..., ETL processes, business intelligence, analytics, data warehouses, and data virtualization; - Demonstrate excellent ability to analyze...Long term contract
$130k - $180k per year
..., we transcend the ordinary and achieve extraordinary results.Data Architect Lantern is seeking an experienced, client-facing Data Architect... ..., and delivery roadmaps.Design secure, scalable lakehouse, warehouse, batch, streaming, and real-time solutions using Databricks,...- ...core platform, investing seriously in our data, and building AI solutions that help us... ...data and AI to work as one. As a Data Architect, you will decide how data is organised and... ...— ideally Snowflake and dbt — including warehouse and database structure, transformation and...Long term contract
- We are seeking a strategic Data Architect to define and implement enterprise data architecture that aligns with business objectives and supports... ...Advanced SQL and NoSQL Databases – Advanced Data Lake & Warehouse Design (Redshift, Snowflake) – Advanced ETL/ELT Frameworks...
$100 - $130 per hour
Brainhunter is currently seeking Senior Portfolio Architect to work for our valued Financial Service... ...leadership and innovation focused on the Data & Analytics Platform Technology, and... ...(Batch & Real Time), Data Storage (Data Warehouse & Data Lake), Master Data Management (MDM...Permanent employmentFull timeContract workFor contractorsInternshipManual laborWork at officeMonday to friday3 days per week- ...We are hiring for a Data Architect in our Data Tech & Infrastructure team! Posting Closes: November 16, 2026 For Internal Use Only:... ...logical, and physical models. ~ Experience with lakehouse, data warehouse, data integration, APIs, ETL/ELT, and governed data products....InternshipLocal areaRemote workFlexible hours
$115k - $140k per year
...technical direction for Rodan's Databricks data platform while staying hands-on with the... ...-on experience delivering a data warehouse, data lake, or lakehouse project that centralized... ..., such as the Databricks Azure Platform Architect accreditation or Data Engineer ProfessionalExperience...Long term contractWork at officeLocal areaNight shift- ...change. Your future starts here.PURPOSE OF THE POSITION: The Data Architect, you will play a key role in driving the organization's data... ...maintain, and continuously evolve scalable data architecture, data warehouse frameworks, and end-to-end data pipelines that support...Fixed term contract
- Company Description We are innovative data and analytics professionals who accelerate the... ...Description The Technical Lead - Cloud Data Warehouse provides overall leadership to the team of data engineers, analysts and architects to implement world-class data solutions that...Work at officeRemote work
$111k - $129k per year
Job DescriptionBusiness Analyst - Data Warehouse & BI ReportingJob SummaryThe Business Analyst - Data Warehouse & BI Reporting serves as a... ...criteria. The BA collaborates closely with the Product Owner, Data Architect, Data Analyst, DW Developers, BI Developers, and business...Work at officeRemote workFlexible hours- Lead Snowflake data warehouse delivery through Python development, ETL design, and technical direction in a hybrid consulting environment.... ...Technical Lead provides leadership to data engineers, analysts, and architects. The client-facing consulting role combines hands-on...
- Lead data warehouse delivery through Tableau, AWS, SQL, and PL/SQL expertise. Build scalable ETL/ELT processes and analytics solutions for business needs.This Business System Analyst role focuses on data manipulation, transformation, and warehouse modeling. You will collaborate...
- About the Role Our client, a reputable analytics firm, is seeking an experienced Senior Data Warehouse Developer to join their growing business intelligence team in Kimberley. This role is critical in designing, developing, and maintaining the organization's data warehouse...Work at officeRemote work
$88k - $162k per year
...like RSM. We are seeking a skilled Business Intelligence and Data Engineering professional with a strong background in design and... ...transform, and load data from multiple sources into data lakes and data warehouses Proficient in SQL Experience with Python/Scala Proven...Work at office$140k - $170k per year
...office at 3 Robert Speck Parkway. How You’ll Make An ImpactThe Data Architect will help establish and evolve data standards, models, and... ...data streams, integrations, transformations, databases, and data warehouses. Define the data architecture framework, standards, and...Work at officeRemote workHome officeFlexible hours$170k - $180k per year
...skilled individuals to each client. Within these teams, the Data Solutions Architect is responsible for providing technical expertise and... ...data solutions on Microsoft Fabric, including Lakehouse, Data Warehouse, Real-Time Intelligence, and Data Factory components - Lead...Flexible hours- ...exceeds 25%. Job DescriptionWe are looking for a Senior Data Architect to design the end-to-end data platform for APEX. The platform... ...Choose between pure lakehouse and hybrid lakehouse-to-data-warehouse patterns based on source characteristics, volumes and performance...Hourly payInternshipWork at officeRemote workRelocation2 days per week
- New Value Solutions is recruiting experienced Senior Data Architects to support Government of Canada IT consulting engagements focused on enterprise... .... Define architecture patterns and standards for data warehouses, data lakes, lakehouses, operational data stores, and...Remote work
$133k - $150k per year
...applications including server, storage, data center, mobile, RF, networking, industrial... ...SUMMARYWe are seeking an Enterprise Data Architect to join our IT Applications team. This role... ...Fabric, Azure SQL, OneLake, Lakehouse, Warehouse, and related technologies. Develop architecture...Long term contractTemporary work
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Data Warehouse Architect. Be the first to apply!
Related searches

