.png){kind=logo}
EMPLOYER: Delta Dental Insurance Company
TITLE: Senior Data Engineer
Location: 1130 Sanctuary Parkway, Alpharetta, GA 30009; Must live within reasonable commuting distance from HQ and able to appear in office as required.
Salary Range: $160,056/yr - $165,056/yr
ResponsibilitiesDesign, develop, and implement enterprise data engineering solutions to support business processes and analytical requirements.
Collaborate with Business Analysts, Architecture teams, and cross-functional stakeholders to gather requirements and translate them into scalable data models, cloud data pipelines, and integration frameworks.
Design and implement data integration processes using SAP Data Services, SSIS, and Azure Data Factory (ADF) to extract, transform, and load structured and unstructured data across heterogeneous systems.
Build and optimize data processing platforms using Microsoft Azure services including Azure Data Factory and Azure SQL Database.
Design end-to-end ETL/ELT pipelines for ingestion, transformation, and analytical data preparation. Create complex SQL logic, stored procedures, packages, and functions in Oracle and SQL Server to support operational and analytical workloads.
Develop and maintain data warehouse and data lake architecture using Star and Snowflake schema designs.
Perform data profiling, data quality checks, and enforce 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 optimal cloud technologies for ingestion, transformation, reporting, visualization, 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 business disruption.
Participate in data architecture discussions, contributing to integration strategies, cloud migration efforts, and modernization initiatives.
Prepare technical design documents, mapping specifications, workflow diagrams, and solution architectures; ensure all designs follow organizational and security standards.
Support all phases of the Software Development Lifecycle (SDLC), including requirements analysis, technical design, development, testing (unit, integration, system), deployment, and production support.
Mentor junior team members by providing guidance on best practices, coding standards, and cloud data engineering methodologies.
Must live within reasonable commuting distance from HQ and able to appear in office as required.
Bachelor’s degree or foreign degree equivalent in Computer Science, Electrical Engineering, or related field and five (5) years of progressive, post-baccalaureate experience in the job offered or related ETL Development/Data Engineering role.
Developing and optimizing entity relationship models using ERWIN, crafting complex SQL queries, and refining them to support analytical requirements and business insights.
Designing, developing, and optimizing enterprise database schemas in Oracle and Microsoft SQL Server, including creation of tables, views, stored procedures, indexing strategies, and applying performance tuning techniques.
Building ETL and data integration workflows using SAP Data Services, SSIS, and Azure Data Factory (ADF), including pipelines, datasets, triggers, integration runtimes, and detailed source-to-target mapping documents.
Designing dimensional data models for OLTP and OLAP environments using Star and Snowflake schemas and applying data architecture best practices such as normalization and de-normalization.
Developing automation scripts using Python and Unix Shell Scripting to streamline data ingestion, transformation, validation, and cloud analytics processes.
Creating and deploying interactive dashboards and reports using Power BI to provide operational and analytical visualizations.
Enforcing data integrity, accuracy, and compliance by applying data quality checks, validation rules, and governance frameworks throughout the data lifecycle.
Implementing data governance and data quality processes, including data profiling, reconciliation checks, error-handling logic, and anomaly detection methods.
Designing and managing scheduling and workflow automation using ADF triggers, Jenkins, SQL Server Agent, or TIDAL to orchestrate ETL and data pipeline operations.
Using version control systems such as GitHub or SVN to manage source code, track revisions, and maintain consistency across ETL pipelines, database artifacts, and cloud resources.
Applying experience across all phases of the Software Development Lifecycle (SDLC) including requirements gathering, technical design, development, documentation, testing, configuration management, deployment, and production support.
Performing troubleshooting, root cause analysis, and performance optimization of SAP BODS jobs, SQL queries, ADF pipelines, and cloud-based data transformation processes.
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 22. $160,056/yr - $165,056/yr
To APPLY: Apply Directly at: https://ejep.fa.us2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1/job/3349/?utm_medium=jobshare&utm_source=External+Job+Share
About UsBehind the smile! We are dedicated to safeguarding the health and financial stability of our employees and their loved ones. This commitment extends beyond the workplace to foster personal growth and holistic wellbeing. Our life-changing rewards package includes:- 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
Skills Required
- Bachelor's degree in Computer Science, Electrical Engineering, or related field and five (5) years of progressive post-baccalaureate ETL Development/Data Engineering experience.
- Experience developing and optimizing entity relationship models using ERWIN and crafting complex SQL queries.
- Designing, developing, 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 using SAP Data Services (SAP BODS), SSIS, and Azure Data Factory (ADF).
- Designing dimensional data models for OLTP and OLAP using Star and Snowflake schema designs.
- Developing automation scripts using Python and Unix Shell scripting to streamline ingestion, transformation, validation, and analytics processes.
- Creating and deploying interactive dashboards and reports using Power BI.
- Enforcing data integrity, accuracy, compliance, and applying data quality checks, validation rules, and governance frameworks.
- Implementing data governance and data quality processes including data profiling, reconciliation, 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 ETL artifacts.
- Experience across all phases of the SDLC including requirements gathering, technical design, development, testing, deployment, and production support.
- Troubleshooting, root cause analysis, and performance optimization of SAP BODS jobs, SQL queries, and ADF pipelines.
- Must live within reasonable commuting distance from Alpharetta, GA HQ and be able to appear in office as required.
Delta Dental Insurance Company Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Delta Dental Insurance Company and has not been reviewed or approved by Delta Dental Insurance Company.
-
Retirement Support — Retirement support is positioned as a standout element, including a sizable automatic 401(k) contribution plus additional matching. This boosts overall total-rewards value even when base pay is viewed as only mid-market in some areas.
-
Affordable Benefits — Core coverage is framed as unusually low-cost to employees, including fully employer-paid dental and vision and low employee contribution medical options. This creates meaningful take-home value beyond cash compensation.
-
Leave & Time Off Breadth — Time-off offerings are described as generous, including broad PTO/holidays and additional paid leave features such as parental leave. These policies increase perceived rewards and help balance workload demands.
Delta Dental Insurance Company Insights
What We Do
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 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. Delta Dental of California, Delta Dental of New York, Inc., Delta Dental of Pennsylvania, and Delta Dental Insurance Company are members, or affiliates of members, of the Delta Dental Plans Association, a network of 39 Delta Dental companies throughout the country. Together with our affiliate companies, form one of the nation’s largest dental benefits delivery systems, covering over 31 million enrollees. Headquartered in San Francisco, we are members of the Delta Dental Plans Association, a network of companies that provides dental coverage to 80 million people. 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 or genetics. 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.
.png){kind=logo}
