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
- ...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
- ...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
- ...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...Suggested
- 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...Suggested
$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$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
- 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
- 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...
$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- ...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
$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$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- ...better tomorrows for all. Job Title: Data ArchitectWho You'll Work WithOur Data Architecture... ...fit for you. What You'll DoAs a Data Architect, you will help clients design and deliver... ..., including data lakes, lakehouses, data warehouses, and real‑time data platforms....InternshipWork at office
- ...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
$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$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- ...annual growth rate exceeds 25%. We are looking for a Senior Data Architect to design the end-to-end data platform for APEX. The... ...reporting. Choose between pure lakehouse and hybrid lakehouse-to-data-warehouse patterns based on source characteristics, volumes and...Hourly payFull timeInternshipWork at officeRemote workRelocation2 days per week
- 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...
$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- 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
$88k - $162k per year
...you and that's why there's nowhere like RSM.Create and maintain data models (dimensional and 3NF) aligned with business requirements.... ...transform, and load data from multiple sources into data lakes and data warehouses.Proficient in SQL.Experience with Python/Scala.Proven experience...Work at office$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- ...help them with Cloud Transformation, Security, Analytics, ML, and Data Governance. Clients usually engage us to solve their most... ...designing, executing, and supporting data environments as a Data Architect, Data Scientist, Data Analyst or similar role ~ In-depth understanding...InternshipFlexible hours
- ...solutions de données techniques. Collaborer avec les ingénieurs de données, les ingénieurs en IA, les équipes d’analytique et les architectes technologiques afin de mettre en œuvre des solutions intégrées. Orienter les décisions d’architecture liées à la sécurité, à la protection...ApprenticeshipRemote work
- ...The Data Architect will be responsible for collecting, documenting, and maintaining metadata and data lineage across systems, business processes, and data domains. This role ensures that data governance requirements are incorporated into business and technology initiatives...
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Data Warehouse Architect. Be the first to apply!
Related searches

