Associate Data Engineer

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.