PointClickCare is a leading North American healthcare technology platform enabling meaningful care collaboration and realtime patient insights. For over 20 years, the company has been focused on realizing its vision: to help create a world in which providers and plans can confidently deliver frictionless care. Since its inception, PointClickCare has grown exponentially, with over 2,200 employees working to impact millions across North America. Recognized by Forbes as one of the top 100 private cloud companies and acknowledged by Waterstone Human Capital as Canada's Most Admired Corporate Cultures, PointClickCare leads the way in creating cloud-based healthcare software. At PointClickCare, we offer a wealth of opportunities and a vibrant culture that empowers our employees. Our dynamic environment is the perfect place to advance your career while engaging in meaningful work alongside incredible colleagues. Here, you'll discover a space where your talents can thrive, your career can grow, and your work will have a lasting impact on healthcare across North America. We believe that work becomes profoundly fulfilling when driven by a higher purpose. Join us and be part of a team that is making a real impact. To learn more about us, check out Life at PointClickCare and connect with us on Glassdoor and LinkedIn.
About the Team:We are a team of 7 data engineers supporting the Acute and Payer Data Science Department at PointClickCare. Our team consists of seasoned data engineers who are passionate about utilizing AI in our work processes and value innovation. We are currently building a comprehensive data warehouse and migrating away from legacy code. Our team is a hybrid team, with 3 engineers local to Salt Lake City and 3 remote across California and Dallas. This role will be a hybrid in our Salt Lake City office. It is an exciting time to join our team as we have recently implemented new infrastructure that has unlocked capabilities previously unavailable.
About the Role:PointClickCare is looking for an 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 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 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 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
• Advanced working knowledge of Python.
• Experience with query optimization, database design, and data warehouse architecture.
• Experience creating advanced SQL queries.
• Experience with cleaning, aggregating, and pre-processing data from varied sources.
• Basic knowledge of Microsoft Azure ecosystem or another cloud provider.
• Experience with Git will be considered a plus.
• Experience with orchestration tools such as Dagster or Airflow is a plus.
• Familiarity with Dbt will be very beneficial.
• Experience working in an agile/scrum environment (preferably Atlassian products such as Jira and Confluence).
• 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.

At PointClickCare, base salary is one of the many components that make up our total rewards package. The US base salary range for this position is $87,000 - $93,600 + bonus + benefits,non-overtime eligible. Our salary ranges are determined by job and level. The range displayed on each job posting reflects the target for new hire salaries for the position across all US locations. Within the range, individual compensation is determined by job-related skills and knowledge, relevant experience including professional and lived experience, and/or work location. Your recruiter can share more information about our total rewards package during the hiring process.#LI-Hybrid#LI-TW1
PointClickCare Benefits & Perks:Benefits starting from Day 1!Retirement Plan Matching Flexible Paid Time OffWellness Support Programs and ResourcesParental & Caregiver LeavesFertility & Adoption SupportContinuous Development Support ProgramEmployee Assistance Program Allyship and Inclusion CommunitiesEmployee Recognition ... and more!
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 
PointClickCare is committed to Information Security. By applying to this position, if hired, you commit to following our information security policies and procedures and making every effort to secure confidential and/or sensitive information.PDN-9df898f3-affa-4dc7-b6aa-38c468fb657d