Senior Data Engineer at 4010-DDC - Underwriting & Actuarial - Actuarial
4010-DDC - Underwriting & Actuarial - Actuarial · Alpharetta, United States Of America · Onsite
- Senior
- Office in Alpharetta
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: 40 hours/week; $150,000 - $160,000/year
Responsibilities
Interpret business requirements to derive technical solutions via systems analysis, design, and prototyping.
Determine best business/technical solutions to meet client needs ensuring the ability to meet users’ implementation time frames.
Translate functional specifications into technical designs and mapping documents.
Develop ETL solutions using SAP Data Services, PL/SQL.
Perform Unit Testing, Segment Testing, Performance Testing, and support End-to-End testing. Deploy code to higher environments.
Develop scripts to productionalize ETL jobs and automate repetitive tasks.
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.
Oracle and Microsoft SQL Server to design and implement database schemas and structures
SQL Server Management Studio (SSMS) and Oracle SQL Developer to develop and optimize entity relationship models, craft complex queries and refine them to drive business insights and fulfill analytical requirements
Design data models using Erwin and Visio, create schemas, and write stored procedures, functions, packages, views, DDL, DML, and SQL queries to enhance database operations
Oracle AWR to enhance database performance by executing indexing strategies, streamlining queries, and applying normalization and de-normalization techniques for OLTP and OLAP environments (Star Schema/Snowflake Schema)
Extract, transform, and load data across systems by using ETL tools such as SAP Data Services, Azure Data Factory and SSIS to ensure seamless data integration
Build and deploy interactive dashboards and reports using data visualization tools like Power BI and Tableau to deliver actionable insights
Automate data transformation and integration processes by scripting in Shell or Python
SAP Data Services, Azure Data Factory and TIDAL Design to orchestrate and manage job scheduling workflows and automate file transmission processes to support comprehensive ETL pipelines
GitHub or SVN to manage and maintain source code for version control and ensuring consistency across ETL scripts and database management processes
Software Development Lifecycle (SDLC), including skills in system design (Visio), programming languages (SQL, PL/SQL, Python, and Shell scripting), documentation tools (Confluence, JIRA, and Office), project management methodologies (Agile and Scrum) and tools (JIRA and Microsoft Project), configuration management systems (Git, SVN and Jenkins) for installation processes and implementation techniques.
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. $150,000-$160,000
TO APPLY: Apply online directly at-https://ejep.fa.us2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1/job/2893/?utm_medium=jobshare&utm_source=External+Job+Share