Data Consultant — Data Engineer / Data Architect

Job title: Data Consultant — Data Engineer / Data Architect Client: Hunter Scouts Location: Ontario, ON, Canada - On-Site Contract type: Contract Contract duration: TBD (40 hours/week) Salary: About the role Hunter Scouts is recruiting a Data Consultant (Engineer / Architect) on behalf of a confidential national healthcare/medical-education organization. This is a hands-on, senior consulting role focused on designing and modernizing enterprise data architectures, building scalable ETL/ELT pipelines, and delivering analytics and reporting solutions. You will lead data modeling, pipeline automation, cloud adoption, DataOps and data governance initiatives to modernize legacy systems and accelerate analytics delivery. Responsibilities • Design and implement scalable data architectures, data models, and ETL/ELT pipelines using SQL and Informatica • Define As-Is and To-Be architectures and develop data roadmaps to modernize legacy systems • Build, automate and optimize end-to-end data integrations and data flows • Develop and maintain analytics and reporting solutions (Power BI and/or Tableau) • Lead cloud data platform adoption (AWS, Azure or GCP) and implement DataOps / CI-CD practices for pipelines • Establish data governance standards (data quality, lineage, catalog) and collaborate with stakeholders to translate business requirements into data solutions Requirements • Must be currently based in Ontario, Canada and authorized to work in Canada • 5+ years experience in data engineering and/or data architecture, including 3+ years designing and building ETL/ELT pipelines and 3+ years in data modeling and advanced SQL • 2+ years hands-on experience with Informatica (PowerCenter or Informatica Cloud) • 2+ years experience developing analytics dashboards using Power BI and/or Tableau • Experience defining As-Is/To-Be data architectures and delivering modernization roadmaps; 2+ years working with at least one cloud data platform (AWS, Azure, or GCP) • Experience implementing DataOps/CI-CD for data pipelines and familiarity with data governance (data quality, lineage, catalog) Preferred Skills • Experience with both Power BI and Tableau • Experience optimizing data flows and automation tooling; familiarity with OpenFlows • Experience migrating on-prem ETL/warehouses to cloud-native data platforms • Experience with orchestration/workflow tools (Azure Data Factory, Airflow) • Experience with IaC/CI-CD tooling for data (Terraform, Azure DevOps, GitHub Actions) Application process Please submit your resume and a brief summary of your relevant experience to Hunter Scouts. Qualified candidates will be contacted for next steps.