Senior Data Engineer

JOB DESCRIPTION

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

• 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.

• 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…