PointClickCare is the leading North American cloud-based healthcare software for the acute and long-term and post-acute care markets. For over 20 years, the company has held the same vision – to help the world care for vulnerable populations. Since its inception, PointClickCare has grown exponentially with over 1,700 employees today all working towards impacting the lives of millions. Recognized by Forbes as one of the Top 100 Private Cloud Companies and acknowledged by Waterstone Human Capital as Canada’s Most Admired Corporate Culture, PointClickCare leads the way in creating cloud-based software. With its recent acquisition of Collective Medical, PointClickCare solidifies its position as a high growth healthcare software provider, serving over 21,000 long-term and post-acute care providers and over 1,300 hospitals. Their shared mission to support vulnerable populations is allowing PointClickCare and Collective Medical to connect disparate points of care at scale faster than anyone else in the market.
For more information on PointClickCare, please connect with us on Glassdoor and LinkedIn.
***This position is not eligible for visa sponsorship***
The Role:
Collective Medical is looking for a Associate Data Engineer to support our Data Science team. The Associate Data Engineer will be responsible for working with the Data Science team to develop the necessary database infrastructure and tools to meet analytic and machine learning needs.
The Associate Data Engineer will:
- Design, construct, install, test, and maintain highly scalable data management systems
- Develop and maintain a mature Python codebase to standardize and extend ETL processes in support of data modeling, mining and warehousing needs
- Design and populate new production tables for efficient storage and access
- Support research opportunities for acquisition and integration of new data sources
- Recommend ways to improve data reliability, efficiency, and quality
- Design and maintain the architecture and operation of a datamart supporting emerging product, finance, and data science requests
- Develop scheduling and automation functions to support internal and external customers
Who you’ll work with:
The Associate Data Engineer will work closely with the data science team, along with additional internal stakeholders in building the data infrastructure to support internal and external analytics as well as machine learning data engineering needs.
What you’ll be doing day to day:
· Interface with business customers, gathering requirements, and collaborating with team members to propose solutions that meet customer needs
· Understand, use, and extend the data warehouse and relational database systems
· Build process and code to extend and sustain the data capabilities across the organization
· Working with the Data Science team to support the analytic and machine learning efforts
Skills and experience we’re looking for:
· Bachelor’s degree (or equivalent experience) in computer science, mathematics, data science, analytics, or statistics. Master’s degree preferred, but not required.
· 0 to 3 years of related data engineering work experience or equivalent combination of education and experience
· Proficient in Python, Java, or equivalent object oriented programming language
· Experience with query optimization, database design, and datamart architecture
· Experience creating complex SQL queries for standard as well as ad hoc data mining purposes.
· Experience with cleaning, aggregating, and pre-processing data from varied sources
· Experience working in an agile/scrum environment
· Experience working with REST APIs
· Database infrastructure documentation skills
· Knowledge of all Microsoft Office applications, including Word, Excel, and PowerPoint
· Ability to meet deadlines, work with tight schedules, and manage multiple priorities under minimum supervision
· Excellent verbal and written communication skills
· Strong analysis skills
· Strong attention to detail
· Previous healthcare related industry experience a plus
Find out more about us:
https://www.forbes.com/sites/zinamoukheiber/2017/11/29/how-collective-medical-technologies-conquered-emergency-rooms-on-a-bootstrap/#123715c16824
https://www.collectivemedicaltech.com/news/press-releases/collective-medical-secures-47-5-million-in-series-a-funding/
#LI-Remote
It is the policy of PointClickCare to ensure equal employment opportunity without discrimination or harassment on the basis of race, religion, national origin, status, age, sex, sexual orientation, gender identity or expression, marital or domestic/civil partnership status, disability, veteran status, genetic information, or any other basis protected by law. PointClickCare welcomes and encourages applications from people with disabilities. Accommodations are available upon request for candidates taking part in all aspects of the selection process. Please contact recruitment@pointclickcare.com should you require any accommodations.
When you apply for a position, your information is processed and stored with Lever, in accordance with Lever’s Privacy Policy. We use this information to evaluate your candidacy for the posted position. We also store this information, and may use it in relation to future positions to which you apply, or which we believe may be relevant to you given your background. When we have no ongoing legitimate business need to process your information, we will either delete or anonymize it. If you have any questions about how PointClickCare uses or processes your information, or if you would like to ask to access, correct, or delete your information, please contact PointClickCare’s human resources team: recruitment@pointclickcare.com