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 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
• Enhance and maintain a data mart supporting emerging product, finance, and data science requests
• Develop scheduling and automation functions to support internal and external customers
• Mentor junior level data engineers

Who you'll work with:

• The 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.
• Seasoned related data engineering work experience or equivalent combination of education and experience.
• Advanced programming abilities in Python.
• Experience with query optimization, database design, and data mart architecture.
• Experience creating advanced SQL queries for standard as well as ad hoc data mining purposes.
• Experience with cleaning, aggregating, and pre-processing data from varied sources.
• Experience automating tasks/report generation and export.
• 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.
• Familiarity with Java a plus.
• Experience with SQL Server/ Azure a plus.
• Familiarity with Docker will be very beneficial.
• Should be comfortable working in command line with Linux-based environments.
• Experience with Git is also very useful.

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