Delta Dental

Oak Brook, IL
1,001-5,000 employees
News from the not‐for‐profit national association of 39 independent Delta Dental companies that provide dental benefits to 80+ million Americans.

Senior Data Engineer

Senior Data Engineer

This job is no longer open
At Delta Dental, our strategy is only as strong as the people who execute it! We are hiring individuals that are not just right for today but also for our future. We have built a foundation of high-trust by treating all people with dignity, making and keeping commitments, and consistently striving to do the right thing. Our leaders optimistically share future possibilities to inspire and motivate others toward their full potential. We expect our employees to find ways to embrace positive change, be curious and challenge the status quo, and provide solutions to unmet problems. Joining Delta Dental means joining a culture focused on fostering development, building genuine connections, recognizing each other’s strengths and sharing in successes. 

The Senior Data Engineer will design, build, and implement data integration solutions - including data pipelines, data APIs, and ETL jobs, to meet the data needs of applications, services, data assets, and business intelligence and analytical tools. Working with business users, data architects, application development teams, data analytics teams, business analytics, product managers, and the data governance COE, the Senior Data Engineer will design and develop ELT between databases, data assets, external partners, and third-party systems in a combination of cloud and on-premise platforms.

How you will make an impact:

    • 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/pipelines for data extract, load and transform data between source systems, extraction, and integration of data into various data assets, including data lake and fit for purpose data repositories, both on-prem and cloud.
    • Collaborates with data architects to understand data structures and concepts including conceptual, logical, and dimensional models and provide early feedback.
    • Designs and develops scalable data APIs 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, 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.

What we look for:

    • 5+ years of related experience along with a Bachelor's degree in Computer Science, Mathematics, Statistics, or other related technical field. 
    • Experience in Cloud ETL tools like Matillion or Azure Data Factory.
    • Experience in data virtualization - Tibco Data Virtualization is preferred. 
    • Experience in Cloud technologies - preferably Azure.
    • Experience in Snowflake Cloud Data Warehouse.
    • Experience in data profiling, data analysis and building Data Quality metrics.
    • Experience in reference data management tools like EBX , Informatica MDM or related tools.
    • Experience building ETL for moving the data from desperate source system into data lake and dimensional models.
    • Experience in documenting and implementing the best practices for building data transformation and load processes.
    • Knowledge of best practices and IT operations in an always-up, always-available service.
    • Experience with or knowledge of Agile Software Development methodologies.
    • Excellent problem solving and troubleshooting skills.
    • Process oriented with great documentation skills.
    • Excellent oral and written communication skills with a keen sense of customer service.

Benefits and perks:

    • 12 days starting vacation, 12 holidays, 9 sick days and your birthday off!
    • Low-cost premium medical insurance options
    • 100% paid dental and vision insurance
    • Generous 401(k) matching and flat contribution
    • Social responsibility and volunteer opportunities, including 16 paid volunteer hours annually
    • Employee LiveWell program, focusing on overall employee well-being
    • Fertility and diabetes benefits
    • Employee discount program: AT&T/Verizon, entertainment, travel, and more!
    • Culture of learning: career development and tuition reimbursement
    • Career growth: we love promoting from within 


#LI-JG1

At Delta Dental we:
Promote accountability, integrity and collaboration: Our employees are collaborative, self-aware, and ethical. It is our expectation to do the right thing and follow through on commitments.
Foster professional development: Our employees take ownership of developing themselves and others through coaching, mentoring and providing/being open to constructive feedback and identifying learning opportunities.
Value customers and cultivate positive experiences: Our employees take time to build rapport with customers, while anticipating and exceeding their needs to ensure positive outcomes.  

If you think this sounds like you, let’s chat. We would love to tell you more!

To see some of the smiling faces behind Delta Dental and to learn more about what our values and culture look like in action, connect with us on social media: @lifeatddins on Facebook and Instagram, @deltadentalins on Twitter, and Delta Dental Ins. on LinkedIn.
 
ABOUT Delta Dental
Delta Dental covers more Americans than any other dental benefits provider. Our vision is to motivate and empower every employee so we’re all inspired to take exceptional care of our customers, providers and each other. Our Enterprise Strategy focuses on pillars of Growth and Diversification, supported by the platforms of Culture and People, Process and Technology. Our employees take pride working for a purpose-driven organization and live our values of Trust, Service, Excellence and Innovation.
 
We are part of the Delta Dental Plans Association, a network of companies that provides dental coverage to 74 million people in the U.S. Delta Dental of California, Delta Dental of New York, Inc., Delta Dental of Pennsylvania and Delta Dental Insurance Company, together with our affiliate companies, form one of the nation’s largest dental benefits delivery systems, covering 33 million enrollees. All of our companies are members, or affiliates of members, of the Delta Dental Plans Association, a network of 39 Delta Dental companies throughout the country.
 
Delta Dental provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, genetics, or any other classification protected by federal or state law. In addition to federal law requirements, Delta Dental complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

Unfortunately, our Delta Dental Enterprise is unable to hire individuals residing in Alaska, North Dakota, Nebraska, Hawaii, Oklahoma, Vermont, Maine, West Virginia, New Hampshire, Wyoming, Puerto Rico or other US Territories at this time.

Proof of eligibility to work in the United States must be provided if selected for hire. 

Delta Dental* has enacted a COVID-19 vaccination policy to protect all employees and the communities we serve due to the ongoing impacts of the COVID-19 pandemic. Accordingly, we require all employees to be fully vaccinated for COVID-19. Are you able to comply with our policy of being fully vaccinated by your start date if an offer is made or have a medical or sincerely held religious exemption for receiving a COVID-19 vaccine? Failure to comply with our policy and submit proof of compliance or receive approval for a valid medical or sincerely held religious belief exemption prior to your start date will nullify any offer of employment extended to you.
*Delta Dental includes: Delta Dental of California, Delta Dental Insurance Company, Delta Dental of Pennsylvania, and Delta Dental of New York
This job is no longer open
Logos/outerjoin logo full

Outer Join is the premier job board for remote jobs in data science, analytics, and engineering.