Employment Type: SGEU Term 9 months or more
Location(s): SK
Salary Range: $45.727 - $55.637 Hourly
Salary Supplement: included in hourly salary range (in-scope)

TECHNICAL

• Ability to build analytics tools to provide actionable insights into customer acquisition, operational efficiencies, and other key business performance metrics.
  If you are looking for an opportunity to challenge yourself and showcase your abilities, we would love to hear from you.

ABOUT THE ROLE – SENIOR DATA ENGINEER:

Reporting to the Manager, Data Management, and working collaboratively with the eHealth teams and our partners in the health system, duties include designing and building the infrastructure required for optimal extracting, transformation, and loading of data from a wide variety of data sources using SQL, SSIS, Informatica, 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.
You will have exciting opportunities to impact and improve healthcare through data, as Business Intelligence Services provides the data management support for analytics, reporting and research projects in Saskatchewan. An example of the support this role provides to the Health Research Data Platform – Saskatchewan includes extraction, linkage and curation of datasets for research use within a secure virtual environment. Knowledge and experience with Saskatchewan health data would be considered an asset for the position.

TYPICAL DAILY DUTIES:

• Identify, design and implement internal process improvements: automate manual processes, optimize data delivery, re-design infrastructure 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.

The knowledge and skills required for this position would be attained through the completion of a degree in computer science or a related discipline. Related quantitative disciplines include but are not limited to: community health sciences, health economics, biomedical statistics, epidemiology, statistics, or mathematics. An equivalent combination of education and experience may be considered. In addition to educational requirements, the successful candidate will have at least 5 years of experience working as a Data Engineer or similar role within an integrated support environment. Additional skills include:

• Expert knowledge of Oracle and SQL Server Database Management Systems and tools.
• Expert knowledge of Informatica software (ie. Power Centre, Integration Services, Workflow Manager, IDMC, TDM).
• Extensive knowledge of the ETL process; providing technical consulting and guidance to development teams for the design and development of highly complex or critical ETL architecture.
• Extensive knowledge of data management methodology, operational modeling, and dimensional database design and development.
• Extensive knowledge of database concepts, data mapping and modeling inclusive of normalization, referential integrity, dimensionality, keys, indexes, metadata and master data. Oracle and SQL server database and tools.
• Extensive knowledge of Shell Scripting language.
• Extensive knowledge of computer programming languages such as PL/SQL, R, Python.
• Extensive knowledge and experience with requirements gathering, analysis, plan, design, develop, implement and maintain Data Management systems.
• Experience mentoring, instructing and leading junior data warehouse resources
• Extensive knowledge of operating systems such as Unix, Linux, and Windows.
• Knowledge of Data Application Programming Interface (API).
• Knowledge of algorithms and data structures.
• Knowledge and experience with information management, logic modeling, conceptual, business process, and workflow design.
• 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.
• Basic knowledge of the Cloud platform for data management.
• Microsoft Certified: Azure Data Engineer Associate would be considered an asset