Data Warehouse Architect

3 weeks ago

ON Canada 2i Solutions, Inc Full time

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 Description:

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. 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 be: Working with the development team, the candidate will:

3.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 Assist in the selection of data management tools required to expand our platform capability.

#J-18808-Ljbffr

  • Data Architect

    1 month ago

    Toronto, ON, Canada Blanc Labs Inc. Full time

    Blanc Labs is a premier partner for global enterprises, leading the way in digitization, automation, and the development of next-generation digital products and services. Our expertise in digital transformation powers businesses to accelerate service delivery, drive customer engagement, and foster growth. The Data Architect will be responsible for...

  • Data Architect

    6 days ago

    Toronto, ON, Canada Tiger Analytics, LLC Full time

    Tiger Analytics is pioneering what AI and analytics can do to solve some of the toughest problems faced by organizations globally. We develop bespoke solutions powered by data and technology for several Fortune 100 companies. We have offices in multiple cities across the US, UK, India, and Singapore, and a substantial remote global workforce. If you are...

  • Data Architect

    7 days ago

    Toronto, ON, Canada Kumaran Systems Full time

    We are looking for a Data Architect to build, optimize and maintain conceptual and logical database models. Must Have10+ years with data warehouses (working in the data space)2+ years working with Apache Spark / Scala.2+ Years working experience on Azure DataBricks, Data Lake / Delta Lake, Blob Storage, etc5+ years of architecture & solutions in the data...

  • Data Architect

    7 days ago

    Toronto, ON, Canada Kumaran Systems Full time

    We are looking for a Data Architect to build, optimize and maintain conceptual and logical database models. Must Have10+ years with data warehouses (working in the data space)2+ years working with Apache Spark / Scala.2+ Years working experience on Azure DataBricks, Data Lake / Delta Lake, Blob Storage, etc5+ years of architecture & solutions in the data...

  • Data Architect Data Analytics

    4 days ago

    Toronto, ON, Canada Bitstrapped Full time

    We are looking for a hands-on Senior Data Engineer in a full-time salaried position. The Data Engineer will work with our Data Services Practice and work alongside our talented cloud architects to play a key role in our delivery teams. The Data Engineer will be involved in the design, programming, and implementation of data platform components and serve...

  • SAP BI Data Architect

    1 month ago

    Toronto, ON, Canada Blanc Labs Inc. Full time

    Blanc Labs is a premier partner for global enterprises, leading the way in digitization, automation, and the development of next-generation digital products and services. Our expertise in digital transformation powers businesses to accelerate service delivery, drive customer engagement, and foster growth. The Data Architect will be responsible for...

  • Data Architect

    4 days ago

    Toronto, ON, Canada Kumaran Systems Full time

    We are looking for a Data Architect to build, optimize and maintain conceptual and logical database models. Must Have 10+ years with data warehouses (working in the data space)2+ years working with Apache Spark / Scala. 2+ Years working experience on Azure DataBricks, Data Lake / Delta Lake, Blob Storage, etc 5+ years of architecture & solutions in the...

  • Data Architect

    3 weeks ago

    Toronto, ON, Canada Equifax, Inc. Full time

    Synopsis of the role The Data Architect is an organizational thought leader recognized internally and externally as the lead designer of our data assets. Leveraging Data Fabric as an enabler for business transformation, this leader is responsible for designing high level data architecture that enables the organization's transformation from a credit...

  • Data Science Solutions Architect

    2 weeks ago

    Toronto, ON, Canada Nexus Systems Group Inc. Full time

    Solution Architect Data & Analytics Our client is looking for a Solution Architect Data & Analytics to join their growing team! Be part of a high-profile team with a multitude of opportunities to deliver transformative data solutions to our business customers. Continue to develop and evolve the Enterprise Data Platform architecture and integrations with...

  • Data Solution Architect

    2 weeks ago

    Toronto, ON, Canada Nexus Systems Group Inc. Full time

    Solution Architect Data & Analytics Our client is looking for a Solution Architect Data & Analytics to join their growing team! What you'll do here: Be part of a high-profile team with a multitude of opportunities to deliver transformative data solutions to our business customers. Continue to develop and evolve the Enterprise Data Platform...

  • Principal Architect, Data Engineer

    6 days ago

    Canada Lovelytics, LLC Full time

    We are seeking an accomplished Principal Consultant with specialized expertise in delivering strategic Databricks and data engineering solutions for our clients at Lovelytics. As a pivotal member of our team, you will serve as a data and analytics solution architect, leading technical engagement and architecture initiatives encompassing data warehousing, ETL...

  • Data Protection Solution Architect

    3 weeks ago

    Toronto, ON, Canada Tundra Technical Solutions Inc. Full time

    What You'll Do Here Be part of a high-profile team with a multitude of opportunities to deliver transformative data solutions to our business customers. Collaborate with members of various technical teams to develop solutions that address the needs of our key data customers. Collaborate with Enterprise Architecture to ensure adherence to EA principles...

  • Data Solutions Architect

    3 weeks ago

    , , Canada OpsGuru Full time

    Position OpsGuru is a global engineering and consulting group. We are experts in the container ecosystem, data processing and analytics, and cloud-native technologies. Our team is formed by network, data, security, DevOps specialists, and application developers. OpsGuru empowers customers with technology to solve their business problems and provides the...

  • Data Solutions Architect

    1 month ago

    Canada OpsGuru Full time

    Position OpsGuru is a global engineering and consulting group. We are experts in the container ecosystem, data processing and analytics, and cloud-native technologies. Our team is formed by network, data, security, DevOps specialists, and application developers. OpsGuru empowers customers with technology to solve their business problems and provides the...

  • Data Architect Data Analytics

    1 month ago

    Kitchener, ON, Canada ApplyBoard Full time

    The data engineering team is an experienced team, responsible for supporting our product development and the entire organization. In addition to building ETL pipelines to automate analytics and building integrations between systems , the team is responsible for building and maintaining the infrastructure used to host these pipelines and integrations. The...

  • Principal Architect, Data Engineer

    4 weeks ago

    Canada Lovelytics, LLC Full time

    We are seeking an accomplished Principal Consultant with specialized expertise in delivering strategic Databricks and data engineering solutions for our clients at Lovelytics. As a pivotal member of our team, you will serve as a data and analytics solution architect, leading technical engagement and architecture initiatives encompassing data warehousing,...

  • Data Solution Architect

    3 weeks ago

    Toronto, ON, Canada Tundra Technical Solutions Inc. Full time

    What You'll Do Here Be part of a high-profile team with a multitude of opportunities to deliver transformative data solutions to our business customers. Collaborate with members of various technical teams to develop solutions that address the needs of our key data customers. Collaborate with Enterprise Architecture to ensure adherence to EA...

  • Data Architect Data Analytics

    2 days ago

    Toronto, ON, Canada Robert Half Full time

    Our client is looking for a Cloud Data Engineer with a deep understanding of GCP cloud infrastructure, automation principles, and a security-first mindset. In this role, you’ll take the lead in designing, implementing, and maintaining our cloud-based platforms and CI/CD pipelines, ensuring optimal performance, reliability, and security. 4+ years of...

  • Data Architect Data Analytics

    2 days ago

    Toronto, ON, Canada Robert Half Full time

    Our client is looking for a Cloud Data Engineer with a deep understanding of GCP cloud infrastructure, automation principles, and a security-first mindset. In this role, you’ll take the lead in designing, implementing, and maintaining our cloud-based platforms and CI/CD pipelines, ensuring optimal performance, reliability, and security. 4+ years of...

  • Architect, Data

    3 hours ago

    Toronto, ON, Canada Aecon Concessions Full time

    Select how often (in days) to receive an alert: It has come to our attention that various international organizations or individuals have been offering false employment opportunities at Aecon Group Inc. Aecon Group Inc. employment policies and processes involve interviews, and candidates who seek employment are never required to pay us any sum of money. To...