Associate Data Engineer

Key Skills

Planning and organization, Microsoft Office suites, Python Programming, SQL, Git, Azure, Data science techniques, Writing, Apache Airflow, Data Engineering, Effective communication skills

Job Description

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.

$93,000 - $99,500 a year

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 $93,000 - $99,500 + 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.