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 2 hours ago
Similar jobs that could be interesting for youBased on the Data Warehouse Architect in Winnipeg, MB vacancy
- ...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
- 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
- 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
$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,...Suggested- 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$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- ...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
- 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
- ...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
$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- ...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
- 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
- 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...
- Role OverviewAs a Senior Data Architect, you'll lead the design and implementation of modern data platforms for enterprise clients across Energy... ...target-state architectures (lakehouse, data mesh, modern data warehouse) Create detailed technical roadmaps with phased...Work at officeRemote workHome officeFlexible hours2 days per week
- We are seeking an experienced AWS Data Architect to design, build, and optimize scalable data solutions on Amazon Web Services (AWS).... ...expertise in cloud‑based data architectures, data lakes, data warehouses, streaming platforms, and advanced analytics, along with the ability...
- ...dream bigger, and build better tomorrows for all. Job Title: Data Architect (For Vacant Role)Who You'll Work WithOur Data Architecture &... ...native data architectures, including data lakes, lakehouses, data warehouses, and real-time data platforms. Translate business...InternshipWork at office
$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....Hourly payContract workFor contractorsInternshipRemote work$96.2k - $120.2k per year
Job DescriptionSenior Data Architect at a glance... LocationToronto, ON Hybrid3 days/week This position implements and maintains domain... ...generating actionable insights. Strong background in data warehouse implementation. Experience in designing data models (...Flexible hours$100k - $125k per year
...globe, Northland is powered by our people.What You’ll Do: The Data Architect / Data Engineer is responsible for designing, developing, and... .... This role will own the organization’s Azure-based data warehouse environment, ensuring data from enterprise systems is integrated...Long term contractImmediate start$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- ...Assistance ProgramOverview Within the Data, AI & Automation team of Bombardier, reporting... ...Intelligence CoE, the Data Solution Architect is responsible for defining, governing, and... ...pipeline development (ETL/ELT), data warehouse and lakehouse administration.You have 5 years...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
- ...is one of North America’s fastest-growing data-focused consultancies.Within 18 months of... ....Job Summary: As a Data Governance Architect at Infostrux, you will own the delivery of... ...Apache Spark, Presto, Amazon EMR)Cloud Data Warehouses (Snowflake, Google BigQuery, Databricks...Full timeContract workRemote workFlexible hours
- 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
$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$170k - $180k per year
...skilled individuals to each client. Within these teams, the Data Solutions Architect is responsible for providing technical expertise and... ...services such as relational databases, NoSQL databases, and Data Warehouses (heterogeneous and homogeneous)Designing, building,...Long term contract$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- Data Solution ArchitectTransLink is dedicated to building a workforce that reflects the... ...implements and maintains customized data warehouse, business intelligence and analytics (DW/... ...cost of ownership. Works with Enterprise Architects, Solution Architects, Security Architects...Long term contractTemporary workImmediate start
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Data Warehouse Architect. Be the first to apply!

