North York General Hospital
Job title:
ETL & Database Developer – Business Intelligence, FT (J0125-1001)
Company
North York General Hospital
Job description
IMAGINE a hospital where everyone is committed to excellence. We did. We are. From boardroom to bedside, we go above and beyond to offer the best and safest patient care. At North York General Hospital (NYGH), we put our patients first in everything we do. We are achieving a new standard of excellence in integrated patient-centered care and as one of Canada’s leading community academic hospitals, we are building on our academic foundation through enhanced education, research and innovation. North York General Hospital is part of North York Toronto Health Partners, a collaborative partnership with patients, primary care, and community partners, a first- generation Ontario Health Team, driving the development of a locally integrated health system to serve the community. As part of our dynamic team, you too can stand out and be amazing! At North York General, our team is making a world of difference.Position SummaryETL & Database Developer, Business Intelligence
We are seeking a skilled ETL Developer to join our Decision Support and BI team. The ETL Developer will be responsible for designing, developing, and maintaining Extract, Transform, Load (ETL) processes to support our data integration and transformation needs. Additionally, you will also develop reusable analytics products to improve workflow for analytics teams. This role works closely with the data architect, consultants, and other stakeholders to ensure that data integrates seamlessly into the enterprise data warehouse, maintaining its quality and integrity for reporting, analytics, and business intelligence purposesOn a practical level, you will
- Develop and maintain ETL processes and data pipelines, leveraging tools such as SQL, Python, and cloud platforms.
- Collaborate with Data Architects, BI Specialists, and Analytic Consultants to create and optimize data models, ensuring integration with clinical and corporate systems (e.g., Oracle Health, Oracle HR)
- Assist with the development of strategic reports and analytics solutions and products
- Troubleshoot and resolve data pipeline and ETL job failures. Collaborating with cross-functional teams to ensure smooth operations and escalate issues as necessary
- Optimize database queries and ETL processes to improve performance and reduce processing time
- Document all components of work – ETL jobs, FM packages, SQL scripts, etc.
- Participate in data quality remediation
Qualifications
- Post-Secondary Education in computer science or a related discipline
- Knowledge of programming technology – Java, Python, R
- Knowledge of basic UNIX commands, and scripting languages e.g. perl
- Experience with relational databases; DB2, ORACLE, SQL Server
- In-depth experience using Structured Query Language (SQL) and database design
- Familiarity with cloud platforms (e.g., Azure) for building and maintaining data solutions
- Experience with health-care information systems such as Oracle Health, Meditech, or Epic used for managing and reporting clinical and corporate data is preferred
- The equivalent of two years hands-on experience
Skills required
- Good problem solving, analytical and communication skills
- Ability to interact with Decision Support and hospital staff, outside vendors and consultants as necessary
- Ability to implement design improvements
What We OfferWorking at NYGH means working with a dynamic team of fellow healthcare providers, staff, and volunteers in one of Canada’s leading hospitals. This is a Full-time Regular Position with 8 hour shifts, days shifts in the Business Intelligence department . We offer a highly competitive total compensation package that includes benefits, pension, and vacation. If you were searching for more reasons to consider joining the wonderful team at NYGH, check out some features of our Total Rewards package by visiting nygh.on.ca
#LI-BR1How to ApplyThink you’re the right person for the job? Here’s your first chance to show us why:
- Ensure to meet the deadline – only applications received by the closing date will be considered.
- We will review all applications and will contact those selected for an interview.
At North York General, we are committed to fostering an inclusive and accessible environment. We are dedicated to building a workforce that reflects the diversity of the community in which we live, including those with disabilities. North York General is committed to providing accommodations in all parts of the hiring process. If you require an accommodation, we will work with you to meet your needs.
Expected salary
$46.65 – 56.21 per hour
Location
Toronto, ON
Job date
Sun, 16 Feb 2025 05:42:27 GMT
To help us track our recruitment effort, please indicate in your email/cover letter where (hiring-jobs.com) you saw this job posting.