Data Engineer

Delta Dental Ins.; Alpharetta (GA); On-site; USD 130,000 - 197,000; Full time

Job summary

Delta Dental Insurance Company seeks a Data Engineer to design, build, and optimize data pipelines, integrating on-prem and cloud data into the Enterprise Data Platform. You will work with Snowflake, Data Factory, Matillion, and BI tools to enable analytics and reporting.

You will model data, implement governance, and collaborate with cross-functional teams to deliver scalable, reliable data solutions and mentor junior engineers as part of an Agile, CI/CD-driven environment.

Qualifications

• Bachelor’s degree in Computer Science or related field and five years of progressive experience in Data Integration and ETL development, Cloud Data Platforms, Data Engineering, Data Analytical Models, Data Governance, Power BI reporting and EBX.

Responsibilities

• Design, build, and optimize data pipelines and workflows to integrate data from on-prem and cloud sources into the Enterprise Data Platform (EDP).
• Hands-on experience with Snowflake, data modelling, data lake, Lakehouse concepts, warehouse management, and performance tuning.
• Experience with Matillion and Azure Data Factory; BI/Reporting tools such as Tableau and Power BI.
• Version control (Git), DevOps, and CI/CD processes experience.
• Work with EBX for master data management (MDM) to ensure governed data across systems.
• Collaborate with cross-functional teams to understand data requirements and propose data engineering solutions.
• Implement data governance and quality control throughout the data lifecycle.
• Tune database systems and data processing frameworks for performance and scalability.
• Develop/maintain data ingestion frameworks for batch and near real-time processing.
• Mentor associate data engineers; assist in professional development.
• Collaborate with data scientists and analysts and provide efficient data access.
• Develop/maintain data models, schemas, and documentation for data understanding.
• Work with infrastructure/DevOps to ensure secure, reliable data systems integration.
• Perform data profiling/analysis/mining to identify patterns and insights.
• Stay current with emerging data engineering technologies and best practices.

Job description

Job Description

EMPLOYER: Delta Dental Insurance Company

TITLE

Data Engineer

Location

1130 Sanctuary Pkwy, Alpharetta, GA 30009; Must live within reasonable commuting distance from HQ and able to appear in office as required.

Salary Range

$130,000/yr - $196,500/yr

Responsibilities

• Design, build, and optimize data pipelines and workflows to integrate data from multiple on-prem and cloud-based sources into the Enterprise Data Platform (EDP).


• Hands on experience with Snowflake including data modelling, data lake, Lakehouse concepts, warehouse management, and performance tuning.


• Experience with Matillion and ADF (Azure Data Factory). Experience with BI and reporting tools (e.g., Tableau, Power BI).


• Experience with version control (Git), DevOps, and CI/CD processes.


• Work with EBX for master data management (MDM), ensuring consistent and governed data across systems.


• Collaborate with cross-functional teams to understand data requirements, identify opportunities for data integration, and propose efficient data engineering solutions.


• Implement data governance and quality control measures to ensure data accuracy, consistency, and integrity throughout the data lifecycle.


• Optimize and tune database systems and data processing frameworks for performance and scalability.


• Develop and maintain data ingestion frameworks for both batch and near real-time data processing.


• Mentor and provide guidance to associate data engineers, assisting in their professional development.


• Collaborate with data scientists and analysts to support their data needs, providing efficient access to relevant datasets.


• Develop and maintain data models, schemas, and documentation to facilitate data understanding and accessibility.


• Work closely with infrastructure and DevOps teams to ensure data systems are secure, reliable, and properly integrated with existing infrastructure.


• Perform data profiling, analysis, and data mining tasks to identify patterns, trends, and insights in large datasets.


• Stay up-to-date with emerging data engineering technologies and best practices and proactively recommend improvements to existing systems.


• Troubleshoot and resolve data-related issues, ensuring minimal disruption to data pipelines and systems.


• Collaborate with data privacy and compliance teams to ensure adherence to data privacy regulations and industry standards.


• Conduct performance monitoring and capacity planning to anticipate and address future data engineering needs.


• Participate in code reviews, performance tuning, and data pipeline optimization for efficiency and scalability.


• Participate in data architecture discussions and provide input on data storage, data flow, and data integration strategies.


• Work in an Agile development environment with continuous integration and deployment (CI/CD) best practices.


• Continuously monitor and optimize data engineering processes, striving for efficiency, reliability, and scalability. Must live within reasonable commuting distance from HQ and able to appear in office as required.

Qualifications

• Bachelor’s degree or foreign degree equivalent in Computer Science or related field and five (5) years of progressive, post-baccalaureate experience in Data Integration and ETL development, Cloud Data Platforms, Data Engineering, Data Analytical Models, Data Governance, Power BI reporting and EBX for enterprise data management or related roles in the job offered.


• Design and build scalable data pipelines using Matillion for Enterprise Data Platforms.


• Design and implement data models and curated datasets on Snowflake to enable analytics, reporting, and business insights.


• Configure and maintain EBX data models to create and manage business workflows and implement data governance rules to support enterprise-wide master data management.


• Collibra to manage data definitions, lineage, ownership, and data quality rules and ensure data assets are properly documented, governed, and compliant with enterprise standards.


• Power BI to build dashboards, scorecards, and analytical insights that support business decision-making and enable enterprise reporting and self-service analytics.


• Experience with data science to apply scientific methods, statistical techniques, and algorithms to extract insights from structured and unstructured data.


• Python to develop data engineering solutions, automation frameworks, and advanced data processing workflows ensuring enhanced scalability, reliability, and efficiency across Enterprise Data Platforms.

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. $130,000/yr - $196,500/yr

About The Team

At Delta Dental, we’re behind millions of smiles and counting. For over 68 years, we’ve served our communities by increasing access to affordable, quality care – but that commitment to care extends beyond the people we serve, to the dedicated employees who make those smiles genuine. We've come this far by building fair programs that offer opportunities for advancement, create meaningful connections and improve the lives of our employees and their families. Because we know that when we take exceptional care of each other, we can make a positive impact for all.

We champion an inspirational workplace through our commitment to trust, service, excellence and innovation. Joining us means working for a company that offers stability and balance, opportunities for leadership at all levels, and a work environment focused on teamwork and camaraderie.

Discover the smiling faces behind Delta Dental and experience our values and culture in action by connecting with us on social media. Follow Delta Dental Ins. on Facebook and Instagram , on Facebook and Instagram , Delta Dental Ins. on Twitter and Delta Dental Ins. on LinkedIn . If you've got an appetite for innovation and want to be a part of a team that’s transforming the future of health care, join us!

Since 1955, we have offered comprehensive, high-quality oral health care benefits to millions of enrollees and built the strongest network of dental providers in the country. The Delta Dental of California network includes affiliates Delta Dental Insurance Company; Delta Dental of Pennsylvania; Delta Dental of New York, Inc.; Delta Dental of the District of Columbia; Delta Dental of Delaware, Inc.; and Delta Dental of West Virginia, providing dental benefits to more than 31 million people across 15 states, the District of Columbia, Puerto Rico and the Virgin Islands.

The company and its affiliates are part of Delta Dental Plans Association (DDPA), a not-for-profit national association based in Oak Brook, Illinois. Through our national network of Delta Dental companies, we offer dental coverage in all 50 states, Puerto Rico and other U.S. territories. We offer vision coverage through DeltaVision in 15 states and the District of Columbia. Collectively, we deliver benefits to more Americans than any other dental insurance company.

Delta Dental Ins. is an equal opportunity employer and is committed to providing a professional work environment free from discrimination and harassment. Individuals seeking employment at Delta Dental are considered without regard to race, ethnicity, color, age, sex, religion, national origin, ancestry, pregnancy, sexual orientation, gender identity, gender expression, genetic information, actual or perceived physical or mental disability, registered domestic partner status, caregiver status, marital status, veteran or military status, citizenship status, or any other legally protected category. Delta Dental is committed to providing equal employment opportunities to all employees and applicants for employment. Accordingly, we have adopted and maintain an Equal Employment Opportunity Policy, Harassment-Free Work Environment Policy, and Respectful Workplace policies and will not tolerate violations of these policies.

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, District of Columbia (Washington D.C.) 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 includes: Delta Dental of California, Delta Dental Insurance Company, Delta Dental of Pennsylvania, and Delta Dental of New York