Senior Data Engineer

at  eHealth Saskatchewan

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

WHAT WE ARE LOOKING FOR:

eHealth Saskatchewan is seeking a results and detail oriented individual with strong technical knowledge. This is an integral role in supporting our day-to-day operations. We are looking for a team member who takes pride in their work and has strong customer service, technical and troubleshooting abilities.

YOU WILL HAVE KNOWLEDGE OF AND EXPERIENCE WITH:

• Expert knowledge of Oracle and SQL Server Database Management Systems and tools.
• Extensive knowledge of data management methodology, operational modeling, and dimensional database design and development.
• 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.
• Expert knowledge of Informatica software (ie. Power Centre, Integration Services, Workflow Manager).
• Extensive knowledge of computer programming languages such as PL/SQL, R, Python.
• Extensive knowledge of operating systems such as Unix, Linux, and Windows.
• Extensive knowledge of Shell Scripting language.
• 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.
• Extensive knowledge and experience with 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.
• Basic knowledge of the Cloud platform for data management.
• Microsoft Certified: Azure Data Engineer Associate would be considered an asset.
  The knowledge and skills required for this position would be attained through the completion of a degree in computer science or a related discipline. An equivalent combination of education and experience may be considered. In addition, you will have 5 years of experience working as a Data Engineer or similar role within an integrated support environment.

TECHNICAL

• Ability to build analytics tools to provide actionable insights into customer acquisition, operational efficiencies, and other key business performance metrics.
  Screened candidates will be evaluated through a written assessment prior to advancing to the interview stage.
  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 Data Management team, 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.

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.
• Mentor, support and train Information Analyst and junior Data Management resources as required.