Senior Data Engineer
Yesterday• Alpharetta, GA
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
Responsibilities:
- Design, 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.
Qualifications:
- 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.
Want more jobs like this?
Get Data and Analytics jobs in Alpharetta, GA delivered to your inbox every week.
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
Additional Information:
Behind 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
Fair Chance Ordinances and Criminal Background Considerations
This position requires that the applicant undergo a background check. Qualified applicants with arrest or conviction records will be considered for employment in accordance with any applicable federal, state or local laws, including, but not limited to, the California Fair Chance Act, the Los Angeles County Fair Chance Ordinance, the City of Los Angeles Fair Chance Initiative for Hiring Ordinance, the San Francisco Fair Chance Ordinance, and/or New York Corrections Law Article 23-A.
Important Work Authorization Information
Please note, Delta Dental will not sponsor applicants for work visas for this position.
#LI-Hybrid
Client-provided location(s): Alpharetta, GA
Job ID: Delta_Dental-3349
Employment Type: FULL_TIME
Posted: 2026-06-12T23:39:41
Perks and Benefits
Health and Wellness
- Health Insurance
- Dental Insurance
- Vision Insurance
- Life Insurance
- Short-Term Disability
- Long-Term Disability
- FSA
Parental Benefits
- Adoption Leave
- Birth Parent or Maternity Leave
- Non-Birth Parent or Paternity Leave
- Fertility Benefits
- Adoption Assistance Program
Work Flexibility
- Remote Work Opportunities
- Hybrid Work Opportunities
Office Life and Perks
Vacation and Time Off
- Paid Vacation
- Paid Holidays
- Personal/Sick Days
- Volunteer Time Off
Financial and Retirement
- 401(K)
- 401(K) With Company Matching
- Performance Bonus
Professional Development
- Leadership Training Program
- Tuition Reimbursement
- Promote From Within
- Access to Online Courses
Diversity and Inclusion