Data Engineer - Snowflake & Data Platform Expert

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

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.