ETL jobs in Brampton, ON

Ontario hospitals lose funding they are entitled to because of gaps in how care gets coded and reported. 3terra builds Data Quality Assist, the platform roughly 50 community hospitals use to find those gaps and close them. Better data means better funded care, and our work shows up in hospital budgets across the province.

We are now building something new. A multi-tenant datastore that will let hospitals benchmark their performance against peer organizations, across outcome metrics, quality based procedures, and emergency department metrics. Today it is a prototype and a set of screen designs with no data model underneath it. We are looking for the person who will design and build that.

The role

You will own our data layer. That means the schemas, the stored procedures, the reporting abstractions, and the pipelines that bring hospital EMR data in from Meditech, Cerner, and soon Epic. You will also work in the .NET services and APIs that sit on top of it.

We are a team of ten, which means the work is broad and the distance between you and the people using it is short. You will engage with the coding and decision support professionals in hospitals whose day gets better or worse depending on what you build. You will work directly with Product and Engineering to understand the problem, shape the solution, and carry it through delivery. You will work alongside our Engineering Lead, Senior Software Developers, our Senior Product Manager, and our QA and client teams.

What you will own

• The data model and aggregation layer behind our new benchmarking platform, including peer grouping and cross-organization comparison
• Schema design and complex T-SQL across DQA and our reporting framework
• EMR integration: source-to-target mapping and extraction pipelines from hospital reporting databases
• Performance across large hospital datasets, from execution plans to index strategy on read-heavy reporting workloads
• Leading our move to tool-based database version control and repeatable deployments
• Translating CIHI DAD and NACRS specifications and hospital business rules into SQL that has to be exactly right

What we are looking for

• Five or more years building and owning data layers, with deep SQL Server experience: complex T-SQL, stored procedures, dynamic SQL, indexed and materialized views
• Real strength in performance tuning, execution plan analysis, and index design on large datasets
• Schema design judgment for both transactional and reporting workloads, and a working feel for when to normalize and when not to
• Comfort with JSON and semi-structured data in SQL Server, which we use heavily in reporting and in our load processes
• Experience building ETL or ELT pipelines that handle incremental loads, corrected data, and failures without manual intervention
• The ability to take an ambiguous requirement and turn it into something accurate, testable, and maintainable
• Confident, practical use of AI in your own work, and an interest in building reusable AI skills and tooling that make the whole team faster. We use AI in development, code review and internal automation, and we expect that to keep expanding.

Nice to have

• .NET service and API development, with judgment about what belongs in the database and what belongs in the service layer
• EF Core, and a view on when it is the right tool versus a stored procedure
• Multi-tenant or cross-organization aggregation, peer grouping, or comparative analytics
• Healthcare data, particularly CIHI DAD and NACRS, case mix, or hospital decision support

Our stack

SQL Server, with Oracle on the Cerner integration side. .NET services. Vue.js front end, owned by others on the team. Redgate SQL Source Control and SQL Compare. GitHub and Jira, with CI/CD pipelines in Azure DevOps and GitHub Actions.

Job Details

Job Type: Permanent, Full-time

Pay: CA$90,000 - CA$110,000 per year

Vacation: 3 weeks

Work Location: Hybrid remote in Mississauga, ON L4Z 2Z1. Candidates must be able to reliably commute to Mississauga or plan to relocate before starting work.

Benefits:

• Extended health care
• Dental care
• Disability insurance
• Paid time off
• Flexible schedule
• Hybrid work arrangement (Mon/Tue/Thu in office, Wed/Fri remote)
• Work from home
• On-site parking
• Annual performance bonus
• Profit sharing

Our Values

3terra is a proud equal opportunities employer and we are committed to creating a respectful, inclusive and barrier-free workplace that allows all of our people to reach their full potential. A diverse workforce is key to our success, and we believe in bringing your whole self to work. We welcome all qualified candidates to apply and hope you will choose 3terra as your employer of choice.

Pay: $90,000.00-$110,000.00 per year

Benefits:

• Casual dress
• Dental care
• Disability insurance
• Extended health care
• Mileage reimbursement
• On-site parking
• Paid time off
• Profit sharing
• Vision care
• Work from home

Work Location: Hybrid remote in Mississauga, ON L4Z 2Z1