Data Engineer

Introduction

The Provincial Information Management and Analytics (PIMA) Branch is looking for Data Engineers to join the Analysis and Development area of the Data Administration and Business Intelligence unit (DABI).

As the primary liaison for DABI-related services and functions with PIMA, the Analysis and Development area leads Master Data Management in the provincial data repository.

The area works with source data providers to review metadata before onboarding new datasets, and reviews metadata updates;

creates and facilitates data extracts for internal and external organizations, and is responsible for the development of activities that support data collection, organization, analytics, and distribution.

Conditions of Employment :

• Must be legally entitled to work in Canada
• Must provide a current and satisfactory Criminal Record Check
• Must be able to work on-call or extended hours as required

Qualifications : Essential :

• Post-secondary degree in Information Technology, Computer Science, Computer Engineering or a related field. An equivalent combination of education, training and experience may be considered.
• Experience working as a Data Engineer or performing similar duties.
• Proficiency in creating ETL processes to support data extraction, data transformation, data structures, metadata, dependency and workload management.
• Experience using programming and scripting languages (e.g. C#, Python, Java, T-SQL) and Business Intelligence reporting tools.
• Experience building and optimizing data pipelines and data sets.
• Experience performing analyses on internal and external data to identifying opportunities for data quality improvement.
• Experience applying methodologies in areas such as : design and modeling of databases, data systems, systems analysis, and database technology.
• Excellent technical and non-technical verbal communication skills.
• Excellent technical and non-technical written communication skills.
• Excellent interpersonal skills to support and collaborate with cross-functional teams in a dynamic environment with Agile cultures.
• Strong organizational and time management skills including the ability to respond to changing priorities and meet deadlines.

Desired :

• Experience working within a health data environment.
• Experience working with all areas of the big data ecosystem.
• Experience working with cloud service providers (e.g. AWS or Microsoft Azure)
• Experience creating ETL processes using SSIS (SQL Server Integration Service).

Duties : The Data Engineers will :

• Provide leadership and mentorship to other data engineers;
• Design, build, automate, test, tune, and support : Extraction, Transformation, and Loading (ETL) of data from various sources;
• Create and implement the physical database structure; and
• Construct and implement operational data stores or marts, based on the logical data model.
30+ days ago