Senior Data Engineer

Delta Dental offers a hybrid work arrangement in Alpharetta, GA, with a competitive annual compensation range of USD 160,056 to 165,056. The organization emphasizes growth, learning, and a holistic benefits program, backed by strong retirement and wellness offerings. This Senior Data Engineer role provides the chance to design and maintain enterprise data platforms, govern data assets, and enable analytics across the business, with the expectation of in-office presence as required.

Benefits

• Competitive base pay with incentive opportunities
• 401(k) plan with robust employer matching and contributions
• Comprehensive medical and pharmacy benefits
• 100% employer-paid dental and vision coverage
• Holistic wellbeing program with meaningful financial incentives
• Generous paid time off plus 12 paid holidays and a birthday off
• Culture that supports growth and learning, including career development and tuition reimbursement
• Family support programs covering adoption, fertility treatment, child care, elder care, and pet care
• Opportunities to participate in social responsibility and volunteer initiatives
• Employee discount program

Responsibilities

• Design, build, and deploy enterprise data engineering solutions that enable business processes and analytics
• Collaborate with Business Analysts, Architecture teams, and cross-functional stakeholders to gather requirements and translate them into scalable data models, cloud pipelines, and integration frameworks
• Design and implement data integration using SAP Data Services, SSIS, and Azure Data Factory to move structured and unstructured data across diverse systems
• Build and optimize data processing platforms using Microsoft Azure services, including Azure Data Factory and Azure SQL Database
• Develop end-to-end ETL and ELT pipelines for ingestion, transformation, and analytics readiness; create complex SQL logic, stored procedures, packages, and functions in Oracle and SQL Server
• Develop and maintain data warehouse and data lake architectures using Star and Snowflake schema designs
• Perform data profiling and data quality checks, enforcing governance standards to ensure integrity, consistency, and compliance across the data lifecycle
• Prototype solution designs for review with business and architecture teams; evaluate and select cloud technologies for ingestion, transformation, reporting, and analytics
• Design and develop dashboards, KPIs, and visualizations using Power BI to support enterprise reporting needs
• Automate manual workflows using Python and Unix shell scripting
• Troubleshoot data pipeline failures, optimize performance, and resolve data-related issues to minimize disruption
• Participate in data architecture discussions and contribute to integration strategies, cloud migration, and modernization initiatives
• Prepare technical design documents, mapping specifications, workflow diagrams, and solution architectures; ensure designs meet security standards
• Support all phases of the Software Development Lifecycle, including requirements analysis, technical design, development, testing, deployment, and production support
• Mentor junior team members by sharing best practices, coding standards, and cloud data engineering methodologies
• Must reside within a reasonable commuting distance to HQ and be able to appear in the office as required

Requirements

• Bachelor’s degree or foreign degree equivalent in Computer Science, Electrical Engineering, or a related field, plus five years of progressive post-baccalaureate experience in ETL development or data engineering
• Experience developing and optimizing entity relationship models using ERWIN and crafting complex SQL queries to support analytics
• Designing and optimizing enterprise database schemas in Oracle and Microsoft SQL Server, including tables, views, stored procedures, indexing, and performance tuning
• Building ETL and data integration workflows with SAP Data Services, SSIS, and Azure Data Factory, including pipelines, datasets, triggers, integration runtimes, and mapping documents
• Designing dimensional data models for OLTP and OLAP environments using Star and Snowflake schemas, applying normalization and denormalization as appropriate
• Developing automation scripts with Python and Unix shell scripting to streamline ingestion, transformation, validation, and cloud analytics processes
• Creating interactive dashboards and reports using Power BI for operational and analytical insights
• Enforcing data integrity and governance through data quality checks, validation rules, and governance frameworks
• Implementing data governance and data quality processes, including profiling, reconciliation checks, error handling, and anomaly detection
• Designing and managing scheduling and workflow automation using ADF triggers, Jenkins, SQL Server Agent, or TIDAL
• Using version control systems such as GitHub or SVN to manage source code and maintain consistency across ETL pipelines, database artifacts, and cloud resources
• Experience across all SDLC phases, including requirements gathering, design, development, documentation, testing, deployment, and production support
• Troubleshooting and optimizing SAP BODS jobs, SQL queries, ADF pipelines, and cloud data transformation processes