Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

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
Vacancy posted 2 hours 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... 
    Suggested
    Full time
    Internship
    Work at office
    Monday to friday
    1 day per week

    Altea Healthcare

    Winnipeg, MB
    2 hours ago
  •  ...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... 
    Suggested
    Permanent employment
    Full time

    Canadian-Addiction-Treatment-Centres

    Winnipeg, MB
    7 days ago
  •  ...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... 
    Suggested
    Internship

    Rogers Communications, Inc.

    Winnipeg, MB
    7 days ago
  • 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

    Precision Technologies

    Winnipeg, MB
    2 hours ago
  • 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

    Altea Healthcare

    Winnipeg, MB
    2 hours ago
  • 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... 

    Altea Healthcare

    Winnipeg, MB
    2 hours ago
  • 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 time
    3 days per week

    VLink Inc

    Winnipeg, MB
    2 hours ago
  •  ...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

    ORBIS Corporation

    Winnipeg, MB
    2 hours ago
  • 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

    COFOMO

    Winnipeg, MB
    2 hours ago
  • $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 contract
    Work at office
    Local area
    Night shift

    Rodan Energy Solutions Inc.

    Winnipeg, MB
    2 hours ago
  •  ...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

    CPKC

    Winnipeg, MB
    2 hours ago
  • 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 work
    For contractors
    Internship
    Remote work

    NetworkPedia

    Winnipeg, MB
    2 hours ago
  • 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... 

    Kaizen Technologies

    Winnipeg, MB
    2 hours ago
  • $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

    Project X Ltd.

    Winnipeg, MB
    2 hours ago
  • $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,... 

    Lantern

    Winnipeg, MB
    2 hours ago
  • $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 time
    Work at office
    Remote work
    Flexible hours

    ices

    Winnipeg, MB
    2 hours ago
  • $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 employment
    Full time
    Contract work
    For contractors
    Internship
    Manual labor
    Work at office
    Monday to friday
    3 days per week

    Brainhunter Systems Ltd

    Winnipeg, MB
    2 hours ago
  •  ...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.... 
    Internship
    Local area
    Remote work
    Flexible hours

    Servus Credit Union

    Winnipeg, MB
    2 hours ago
  • 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... 

    Massive Insights Inc.

    Winnipeg, MB
    2 hours ago
  • $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 office
    Remote work
    Flexible hours

    Fidelity Canada

    Winnipeg, MB
    2 hours ago
  • Build data warehouse and BI solutions at Novo Nordisk using T-SQL and Power BI. Shape reporting capabilities that support business decisions.As a Senior Application Developer, you will adapt data warehouses, ETL processes, and reporting platforms for evolving analytical requirements... 

    Novo Nordisk A/S

    Winnipeg, MB
    2 hours ago
  • Job Title: Senior Data Warehouse DeveloperReports to: Data Warehouse Technical LeadAbout us: Welcome to Pinnacle, the ultimate destination for sports enthusiasts seeking an exhilarating sportsbook and gaming experience! Established in 1998, we have solidified our position... 
    Worldwide

    Pinnacle

    Winnipeg, MB
    2 hours ago
  • 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... 

    Soroc Technology

    Winnipeg, MB
    2 hours ago
  • 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 office
    Remote work

    Massive Insights Inc.

    Winnipeg, MB
    2 hours ago
  • Use advanced SQL and data visualization skills as a Remote Warehouse Data Analyst supporting worldwide operations from anywhere. Work fully remotely with an international, distributed team.This Data Analyst role focuses on warehouse and logistics data. You will analyze WMS... 
    Remote work
    Worldwide

    Placements24

    Winnipeg, MB
    2 hours ago
  • $135k - $170k per year

     ...inclusive environment where you’ll feel valued and supported to be your best - both personally and professionally.Role: Team Manager, Data Warehouse The Team Manager, Data Warehouse and BI Development and Support is responsible for managing a team of DW software developers... 
    Work at office
    Remote work
    Home office
    Flexible hours

    Fidelity International

    Winnipeg, MB
    2 hours ago
  • $70k - $105k per year

     ...deep engineering expertise, treating customer success as its own while building tomorrow’s digital infrastructure. Job Title Data Warehouse SE Job description We are seeking an experienced Data Warehouse SE (Data Platform Engineer) to lead the evolution of our... 

    Hyve Solutions

    Winnipeg, MB
    2 hours ago
  • $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

    OpsGuru

    Winnipeg, MB
    2 hours ago
  • $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

    RSM Canada Operations ULC

    Winnipeg, MB
    2 hours ago
  • $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 contract
    Immediate start

    Northland Power Inc.

    Winnipeg, MB
    2 hours ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Warehouse Architect. Be the first to apply!