Deadline
Until the position is filled.
Employment status
One-year contract. Full-time. Possible to renew after the term.
Responsibilities
Reporting to the Manager of Application Development and Support, the data engineer develops processes that connect to various clinical system or research databases to perform data collection, extraction, transformation and load functions, and make processed data accessible for data scientists and researchers. This may include participation in building data collection applications, consultation with clinicians/researchers/managers to understand business needs, design/re-engineer data structure, coding of ETL process, and testing.
The standard application development platform at the Heart Institute includes Ebase Technology’s Xi platform and Postgres database. However, the selected candidate is expected to work with various data sources that are hosted in Oracle, MS SQL, MySQL, MS Access, Excel and etc.
Major areas of direct responsibility include
- Data process management
- Data modeling
- Database architecture review
- Data pipeline (ETL tools) development
- Design and implement data collection tools/applications
- On demand data reporting
Basic requirements
- College diploma or University Degree in database engineering, computer science or a related field;
- Strong experience with Data process tools and best practices;
- Strong knowledge of database design methodologies and architectures, preferably in Postgres environment;
- Strong experience with PL/SQL scripting;
- Knowledge of scripting languages;
- Knowledge of application development lifecycle.
Suitability
- Excellent interpersonal skills
- Excellent organizational, analytical skills and decision making skills
- Good oral and written communications skills
- Excellent analytical and time management skills
- High levels of creativity/innovation and adaptability to change
- Excellent teamwork and ability to transfer knowledge to other colleagues
Preferred qualifications
- Healthcare setting experience would be preferred
- Experience with EPIC Clarity Data model
- Demonstrate knowledge of database best practices
To apply
Please send your cover letter and CV to jobpostings@ottawaheart.ca.
Applications from Indigenous persons, members of racialized minorities, persons with disabilities, women, members of the LGBTQ+ community, as well as from all qualified candidates with the skills and knowledge to productively engage with equitable, diverse and inclusive communities are strongly encouraged.
According to government policy, all qualified candidates are invited to apply; however, preference will be given to Canadians and permanent residents. When submitting your application, please indicate if you are legally entitled to work in Canada.
The University of Ottawa Heart Institute is committed to ensuring barrier-free selection processes and work environments. Accommodations will be provided in all parts of the hiring process relating to any specialty requirements. Please notify us of any accommodations that you require – any information you provide will be handled respectfully and in complete confidence.
The successful candidate will be required, prior to the start of employment, to complete mandatory organizational training available online, and provide the following: an official piece of photo identification and a satisfactory Criminal Record Check and proof of two doses of COVID-19 vaccine.