Senior Data Engineer

Delta Dental Insurance Company is dedicated to providing quality dental care and is seeking a Senior Data Engineer. The role involves developing and maintaining scalable data pipelines, designing ETL packages, and providing data as a service to various applications and analytical tools.

Responsibilities:

• Develops and maintains scalable data pipelines and builds out new integrations to support continuing increases in data volume and complexity
• Designs and develops scalable ETL packages for point to point integration of data between source systems, extraction and integration of data into various data assets, including data warehouse and fit for purpose data repositories, both on prem and cloud
• Designs and develops scalable data API's to provide data as a service to microservices, applications, and analytical tools
• Designs and develops data migrations in support of enterprise application and system implementations from legacy systems
• Writes functional specifications for data pipelines and APIs and writes and performs unit/integration tests
• Performs data analysis required to troubleshoot data related issues and assist in the resolution of data issues
• Assists in planning, coordinating, and executing engineering projects. Supports and collaborates with other Engineers through evaluation, design analysis, and development phases
• Maintains knowledge, ensures competency and compliance with policies and procedures, in order to be the technical expert while collaborating with cross-functional teams
• This list is not all-inclusive and you are expected to perform other duties as requested or assigned. Domestic travel required, 10%
• Telecommuting permissible from any location in the US

Requirements:

• Bachelor's degree or foreign degree equivalent in Electronics Engineering or related field and seven (7) years of post-baccalaureate, progressive experience in job offered or related role
• Pulling data from Oracle Revenue Management and Billing System and sending it to different exchanges for review using SQL, PL/SQL
• Creating data models and validating data using Tableau, Power BI
• Designing and developing scalable ETL packages for point-to-point integration of data between source systems, extraction, and integration of data into various data assets using SAP Data Designer
• Replicating data from Oracle DB to Snowflake using HVR tool
• Building User interface Dashboard for file processing and metrics using HTML, CSS, JavaScript
• Running the automated pipelines for application check out using Jenkins