Sr Engineer, Data Management and Analytics

Pacific Dental Services, Inc.

Pacific Dental Services, Inc. offers a promising opportunity to join their skilled team as a Sr Engineer in Data Management and Analytics. This role focuses on designing data solutions to meet the company's data, analysis, and reporting requirements. The successful candidate will work with a team dedicated to developing innovative data strategies and ensuring precise data integration.

In this role you can expect to have the responsibilities:

• Collaborate with Data Warehouse product owners and BSA to thoroughly understand business user stories.
• Work alongside the Data Architect to accurately interpret data modeling and design the ETL data flow.
• Develop ETL/ELT data pipelines to integrate data from multiple sources and apply business logic to transform data structures.
• Write efficient stored procedures to facilitate data extraction and transformation.
• Create reusable components for scalable data integration, including handling errors and logging.
• Engage in data modeling and schema design activities.
• Support and optimize query development processes.

This role comes with the following benefits:

• Medical, dental, and vision insurance
• Paid time off
• Tuition reimbursement
• 401(k) plan
• Paid volunteering time in local community

This role requires you to have:

• Strong analytical skills
• Experience in database development
• Proficiency in SQL
• Experience with Snowflake
• ETL/ELT process development
• Agile methodologies
• Source Control with Bitbucket/Git/Github
• Understanding of the software development lifecycle

You would benefit from having:

• Experience with Snowflake Cloud Data Warehouse ELT tools
• Familiarity with third-party data integration and API calls
• Experience using Microsoft SSIS
• Proficiency in Python

PDS Health is committed to equal opportunity employment, celebrating diversity and striving for an inclusive workplace to enhance team members' well-being.