Data Engineer
Rancho Cordova, CA, United States
Full Time Mid-level / Intermediate USD 80K - 174K
Delta Dental
Discover affordable dental insurance plans at Delta Dental. Get coverage for preventive, basic, and major dental services. Protect your smile today!This role is hybrid and requires someone within a commutable distance to the Rancho Cordova office.
The Data Engineer will collaborate with data architects, application development teams, data analytics teams, and the Data Governance COE to build and test interfaces between applications, data warehouses, and third-party systems in a combination of cloud and on-premise platforms. Using ETL tools, data virtualization tools, and API engines, the Data Engineer translates business requirements at the direction of Senior Data Engineers into data interfaces, data APIs, and data pipelines to supply the data needs of the enterprise, supporting application to application integration, the data flow in and out of the data management platform and other databases, and the data access layer supplying data to end consumers, including applications and tools.
- 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.
- 2+ years of ETL tool experience and SQL expertise.
- A Bachelor’s degree with at least 2 years of relevant professional experience.
- Experience with or knowledge of Agile Software Development methodologies.
- Extensive expertise in Matillion, Python and Snowflake.
- Significant experience in the healthcare domain, with familiarity in industry-specific data processes and systems.
- Experience with or knowledge of Agile Software Development methodologies.
- Expertise with the EBX tool, a reference data management tool.
- Demonstrated problem-solving and troubleshooting skills.
- Excellent oral and written communication skills with a strong focus on customer service.
- Proven ability to grow into architectural roles, with a track record of supporting team success and fostering collaboration across teams.
- A proactive approach to delivering high-quality results and supporting organizational objectives.
- Familiarity with specialized technologies critical to data-driven operations and initiatives.
Base Pay Information
The national base pay range at the end is a good-faith estimate of what Delta Dental may pay for new hires. Actual pay may vary based on Delta Dental’s assessment of the candidate’s knowledge, skills, abilities (KSAs), related experience, education, certifications and ability to meet required minimum job qualifications. Other factors impacting pay include prevailing wages in the work location and internal equity.
Pay Grade 21. $80,500 - $174,300
- Competitive base and incentive pay
- 401(k) with robust matching and non-matching contributions
- Rich medical & pharmacy benefits
- 100% employer-paid dental and vision benefits
- Holistic wellbeing program with deep financial incentives
- Generous paid time off plus 12 paid holidays and your birthday off
- Culture of growth and learning: career development; tuition reimbursement; recognition program
- Family support: adoption assistance, fertility treatment, child, elder & pet care assistance
- Social responsibility and volunteer opportunities
- Employee discount program
#LI-Hybrid
Tags: Agile APIs Data analysis Data Analytics Data governance Data management Data pipelines Data warehouse ETL Matillion Microservices Pipelines Python Snowflake SQL
Perks/benefits: Career development Competitive pay Equity / stock options Fertility benefits Flex vacation Health care
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.