12/01/2025 Data Engineer
About the role
Contract Duration Senior Data Engineer – Job Description
- Start Date: Immediate upon selection
- End Date: March 31, 2027
- Extension Option: additional 12-month term under the same terms and conditions
Overview This role involves working with data across various healthcare domains, refining requirements with data models, extracting data from various source systems and database formats, and providing data in a number of formats including Extract, Transform, Load (ETL) aligned with Informatica software. The Senior Data Engineer(s) will report to the Manager of Data Management, work with a project team lead by a Project Manager and will provide the required leadership and communication to ensure deliverables are met on time and on budget. This is a highly visible, busy, and challenging role that will be focused on supporting major analytics projects.
Key Responsibilities
- Design and build the infrastructure required for optimal extracting, transformation, and loading of data from a wide variety of data sources using Informatica, Structured Query Language (SQL), SQL Server Integration Services (SSIS), Application Programming Interface (API) and other technologies.
- Architect relational and multi-dimensional databases from structured, semi-structured and unstructured data with development techniques including star and snowflake schemas, ETL, Slow Changing Dimensions (SCD), Fact and Cube development in a data management framework in conjunction with the Provincial Data Platform Infrastructure.
- Identify, design and implement internal process improvements: automate manual processes, optimize data delivery, re-design data pipelines for greater scalability.
- Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiencies, and other key business performance metrics.
- Develop, maintain, optimize, troubleshoot, debug, monitor, backup and recovery operations for the ETL environment.
- Analyze datasets to ensure compliance with data sharing agreements and legislation restrictions, and for alignment with data architecture guidelines.
- Mentor, support and train Information Analyst and Junior Data Management resources, as required
Mandatory Qualifications The proposed Resource(s) must:
- Have a minimum of five (5) years of proven experience working as a Data Engineer or similar role.
- Possess a bachelor’s degree in information technology, Engineering or Computer Science, or a diploma in related data management/information technology stream with three (3) additional years of experience (over the required five (5) years) working as a Data Engineer or similar role.
- Have a minimum of two (2) years of proven experience using Informatica software (i.e., Power Centre, Integration Services, Workflow Manager, IDMC and TDM) in an integrated support environment.
Qualifications/Requirements The proposed Resource(s) should have the following qualifications and have experience fulfilling the following job requirements:
Expert Knowledge Of
- Oracle and SQL Server Database Management Systems and tools.
- ETL and data pipeline development experience; providing technical consulting and guidance to development teams for the design and development of highly complex or critical ETL architecture.
- Computer programming languages such as PL/SQL, R, Python.
- Operating systems such as Unix, Linux, and Windows.
- Shell Scripting language.
- Data Application Programming Interface (API).
- Algorithms and data structures.
Extensive Experience With
- Information management, logic modeling, conceptual, business process, and workflow design.
- Requirements gathering, analysis, plan, design, develop, implement and maintain Data Management systems.
- Critical, constructive and creative problem-solving skills that involve issue identification, development of objectives, development of an action plan overseeing what needs to done, while identifying the resources required to ensure quality products.
- Cloud platform for data management.
Plus
- Microsoft Certified: Azure Data Engineer Associate would be considered an asset.
- Experience working with healthcare data would be considered an asset.
About Horizon Computer Solutions Inc.
Horizon Computer Solutions Inc. is an industry-leading Western Canadian IT solutions provider specializing in transformative technology solutions. Horizon focuses on six primary Technology Solutions to meet the diverse needs of our clients: Managed IT Solutions, Cyber Security, Cloud & Data Centre Solutions, Data Analytics, IT Procurement, and Staff Augmentation.
Established in 1995, Horizon has been providing advanced and scalable business solutions to organizations across Canada. From local businesses to public and private multinational enterprises, Horizon's collaborative approach to problem-solving is based on delivering revolutionary technology solutions strategically aligned with our client's business objectives.
Headquartered in Saskatoon, Saskatchewan — one of Canada's fastest-growing technology hubs — Horizon has a long history of being at the forefront of innovative solutions to strategically navigate the technology landscape to help our clients achieve their desired business objectives. Our 27 years of success are a testament to our commitment to serving our clients and our community.
As the world adapts and advances with new and exciting technologies, Horizon's vision and commitment will always be to provide transformative solutions that deliver new capabilities and outcomes for our clients.
12/01/2025 Data Engineer
About the role
Contract Duration Senior Data Engineer – Job Description
- Start Date: Immediate upon selection
- End Date: March 31, 2027
- Extension Option: additional 12-month term under the same terms and conditions
Overview This role involves working with data across various healthcare domains, refining requirements with data models, extracting data from various source systems and database formats, and providing data in a number of formats including Extract, Transform, Load (ETL) aligned with Informatica software. The Senior Data Engineer(s) will report to the Manager of Data Management, work with a project team lead by a Project Manager and will provide the required leadership and communication to ensure deliverables are met on time and on budget. This is a highly visible, busy, and challenging role that will be focused on supporting major analytics projects.
Key Responsibilities
- Design and build the infrastructure required for optimal extracting, transformation, and loading of data from a wide variety of data sources using Informatica, Structured Query Language (SQL), SQL Server Integration Services (SSIS), Application Programming Interface (API) and other technologies.
- Architect relational and multi-dimensional databases from structured, semi-structured and unstructured data with development techniques including star and snowflake schemas, ETL, Slow Changing Dimensions (SCD), Fact and Cube development in a data management framework in conjunction with the Provincial Data Platform Infrastructure.
- Identify, design and implement internal process improvements: automate manual processes, optimize data delivery, re-design data pipelines for greater scalability.
- Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiencies, and other key business performance metrics.
- Develop, maintain, optimize, troubleshoot, debug, monitor, backup and recovery operations for the ETL environment.
- Analyze datasets to ensure compliance with data sharing agreements and legislation restrictions, and for alignment with data architecture guidelines.
- Mentor, support and train Information Analyst and Junior Data Management resources, as required
Mandatory Qualifications The proposed Resource(s) must:
- Have a minimum of five (5) years of proven experience working as a Data Engineer or similar role.
- Possess a bachelor’s degree in information technology, Engineering or Computer Science, or a diploma in related data management/information technology stream with three (3) additional years of experience (over the required five (5) years) working as a Data Engineer or similar role.
- Have a minimum of two (2) years of proven experience using Informatica software (i.e., Power Centre, Integration Services, Workflow Manager, IDMC and TDM) in an integrated support environment.
Qualifications/Requirements The proposed Resource(s) should have the following qualifications and have experience fulfilling the following job requirements:
Expert Knowledge Of
- Oracle and SQL Server Database Management Systems and tools.
- ETL and data pipeline development experience; providing technical consulting and guidance to development teams for the design and development of highly complex or critical ETL architecture.
- Computer programming languages such as PL/SQL, R, Python.
- Operating systems such as Unix, Linux, and Windows.
- Shell Scripting language.
- Data Application Programming Interface (API).
- Algorithms and data structures.
Extensive Experience With
- Information management, logic modeling, conceptual, business process, and workflow design.
- Requirements gathering, analysis, plan, design, develop, implement and maintain Data Management systems.
- Critical, constructive and creative problem-solving skills that involve issue identification, development of objectives, development of an action plan overseeing what needs to done, while identifying the resources required to ensure quality products.
- Cloud platform for data management.
Plus
- Microsoft Certified: Azure Data Engineer Associate would be considered an asset.
- Experience working with healthcare data would be considered an asset.
About Horizon Computer Solutions Inc.
Horizon Computer Solutions Inc. is an industry-leading Western Canadian IT solutions provider specializing in transformative technology solutions. Horizon focuses on six primary Technology Solutions to meet the diverse needs of our clients: Managed IT Solutions, Cyber Security, Cloud & Data Centre Solutions, Data Analytics, IT Procurement, and Staff Augmentation.
Established in 1995, Horizon has been providing advanced and scalable business solutions to organizations across Canada. From local businesses to public and private multinational enterprises, Horizon's collaborative approach to problem-solving is based on delivering revolutionary technology solutions strategically aligned with our client's business objectives.
Headquartered in Saskatoon, Saskatchewan — one of Canada's fastest-growing technology hubs — Horizon has a long history of being at the forefront of innovative solutions to strategically navigate the technology landscape to help our clients achieve their desired business objectives. Our 27 years of success are a testament to our commitment to serving our clients and our community.
As the world adapts and advances with new and exciting technologies, Horizon's vision and commitment will always be to provide transformative solutions that deliver new capabilities and outcomes for our clients.