Junior Data Engineer

The role of the junior data engineer is to control and oversee the ETL (Extract, Transform, Load) of data from source systems (EHRs, administrative databases, registries, etc) into repositories so that the data can be used for analytics (i.e., reporting, business intelligence, statistical modeling, machine learning, etc). The scope of this role is end-to-end, such that it includes supporting business requirements gathering, all activities from requirements gathering and database analysis, to ETL programing, to ongoing QA and maintenance of data pipelines and target databases. This role will support the senior data engineer and manager on data engineer projects. Education And Experience

• Undergraduate degree computer science, engineering or other relevant program
• 2 years required Business intelligence/data analysis
• 1 year preferred data engineering

Knowledge And Skills

• Extensive knowledge in the design and development of ETL processes required
• Extensive knowledge of SQL programing required
• Working Knowledge of best practices in data warehousing required
• Working knowledge of at least one industry standard tool for each of the following is required:
• Data modeling tool (Erwin, Data Architect, etc)
• ETL tool (Data Stage, Oracle Data Integrator, etc)
• SQL database (SQL Server, PostgreSQL, etc.)
• Working knowledge designing and running testing scenarios required
• Strong interpersonal skills required for requirement gathering
• Familiarity with cloud architecture (AWS, Azure, GCP, etc.) an asset
• Experience deploying Spark and Hadoop on clusters an asset

As a condition of employment, you are required to submit proof of full COVID-19 vaccination to Employee Health Services. Job Administrative/Service Primary Location Ontario-Hamilton This position will be located at Offsite Location Organization Research Status Regular Hours per week 37.5 Number of Openings 1 Union Code Non Union Employees Salary 40.4300 Post Date Apr 23, 2024, 11:00:00 PM Apr 30, 2024, 10:59:00 PM Unit Summary The Digital Health Innovation team's aim is to use machine learning, artificial intelligence and novel digital health applications to improve patient care and enhance medical research. Our team has two major areas of strength: Data Science (applied machine learning/artificial intelligence) and Application Development (the creation of new digital health products in partnership with clinicians and researchers). Schedule Work Hours Monday to Friday, Days Guidelines Hamilton Health Sciences fosters a culture of patient and staff safety, whereby all employees are guided by our Mission, Vision, Values, and Values Based Code of Conduct. Hamilton Health Sciences is a teaching hospital and all staff and physicians are expected to support students and other learners. To be considered for this opportunity applicants must apply during the posting period. All internal and external applicants may ONLY apply via the Careers website. Hamilton Health Sciences is an equal opportunity employer and we will accommodate any needs under the Canadian Charter of Rights and Freedom, Accessibility for Ontarians with Disabilities Act and the Ontario Human Rights Code. Hiring processes will be modified to remove barriers to accommodate those with disabilities, if requested. Should any applicant require accommodation through the application processes, please contact Human Resources Operations at for assistance. If the applicant requires a specific accommodation because of a disability during an interview, the applicant will need to advise the hiring manager when scheduling the interview and the appropriate accommodations can be made. This competition is open to all qualified applicants, however, qualified internal applicants will be considered first. Past performance will be considered as part of the selection process. If you are a previous employee of Hamilton Health Sciences, please note: the circumstances around an employee's exit will be considered prior to an offer of employment Proficiency in both Official Languages, French and English, is considered an asset If this position is temporary, selection for this position will be as per the outlined Collective Agreements: Article 30 (k), CUPE Collective Agreement Article 10.7 (d), ONA Collective Agreement Article 13.01 (b) (ii), OPSEU 273 Collective Agreement Article 14.04, OPSEU 209 Collective Agreement Article 2.07 and Article 13, PIPSC RT Collective Agreement