Sr Engineer, Data Management and Analytics - Pacific Dental Services

Now is the time to join Pacific Dental Services. You will have opportunities to learn new skills from our team of experienced professionals. If you're ready to take your career to the next level and gain valuable experience, apply today!

To succeed in this data engineering position, you should have strong analytical skills and the ability to combine data from different sources. Data engineer skills also include familiarity with several programming languages. This role will design and develop data solutions to support the PDS data, analysis, and reporting needs. This is an onsite role that can be located in one of our support offices in either Irvine, CA, Irving, TX or Henderson, NV. This is not a remote opportunity.

Responsibilities

• Work closely with Data Warehouse product owner and BSA to thoroughly understand the business user stories

• Work with the Data Architect to accurately interpret the data modeling and design the ETL data flow

• Develop ETL/ELT data pipeline flow to load data from various data sources to the staging database and apply complex business logic to populate normalized and denormalized data structure 

• Write efficient and well-performed stored procedures to extract and transform the source data

• Build reusable components for a scalable data integration methodology such as error handling, logging, and recoverability

• Participate in the data modeling / schema design

• Perform and support query development and optimization

Qualifications

• Experienced in database development, OLTP and Data Warehouse/Dimensional

• Proficient in programming languages - SQL

• 3+ years of experiences working with Snowflake

• Experienced in building or maintaining ETL/ELT processes

• Agile Methodologies

• Source Control – Bitbucket/Git/Github

• Experienced with the software development lifecycle

• Detail-oriented and excellent organizational skills

Preferred

• Experiences with Snowflake Cloud Data Warehouse ELT tools (dbt or Matillion)

• Experienced in integration of data from disparate sources including 3rd party vendor data and/or API calls

• Experience using Microsoft SSIS

• Experience using Python for data integration and analysis

Knowledge/Skills/Abilities

• Ability to multi-task effectively without compromising the quality of the work.

• Excellent interpersonal, oral and written communication skills.

• Detail oriented, organized, process focused, problem solver, proactive, ambitious, customer service focused.

• Ability to draw conclusions and make independent decisions with limited information.

• Ability to respond to common inquiries from customers, staff, regulatory agencies, vendors, and other members of the business community.

• Self-motivated, reliable individual capable of working independently as well as part of a team.

• Possess the intellectual curiosity to work through ambiguity and have ability to work independently with minimal instruction.

• Ability to manage change and do extremely well in a fast-paced environment under time constraints.

• Ability to take initiative and work independently, and work effectively with individuals belonging to all levels within the organization.

• Ability to work with mathematical concepts such as probability and statistical inference.

• Ability to effectively and succinctly simplify complex data and communicate information to Senior Management.

• Customer service oriented and proactive in anticipating and resolving problems while maximizing efficient use of computing resources.

Benefits

• Medical, dental, and vision insurance
• Paid time off
• Tuition Reimbursement
• 401K
• Paid time to volunteer in your local community

Pacific Dental Services is an Equal Opportunity Employer. We celebrate diversity and are united in our mission to create healthier and happier team members.