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: 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
ABOUT THE TEAM
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 fair 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 focused on teamwork and camaraderie.
Discover the smiling faces behind Delta Dental and experience our values and culture in action by connecting with us on social media. Follow Delta Dental Ins. on Facebook and Instagram, #LifeatDDins on Facebook and Instagram, Delta Dental Ins. on Twitter and Delta Dental Ins. on LinkedIn. If you've got an appetite for innovation and want to be a part of a team that's transforming the future of health care, join us!
Since 1955, we have offered comprehensive, high-quality oral health care benefits to millions of enrollees and built the strongest network of dental providers in the country. The Delta Dental of California network includes affiliates Delta Dental Insurance Company; Delta Dental of Pennsylvania; Delta Dental of New York, Inc.; Delta Dental of the District of Columbia; Delta Dental of Delaware, Inc.; and Delta Dental of West Virginia, providing dental benefits to more than 31 million people across 15 states, the District of Columbia, Puerto Rico and the Virgin Islands.
The company and its affiliates are part of Delta Dental Plans Association (DDPA), a not-for-profit national association based in Oak Brook, Illinois. Through our national network of Delta Dental companies, we offer dental coverage in all 50 states, Puerto Rico and other U.S. territories. We offer vision coverage through DeltaVision in 15 states and the District of Columbia. Collectively, we deliver benefits to more Americans than any other dental insurance company.
Delta Dental Ins. is an equal opportunity employer and is committed to providing a professional work environment free from discrimination and harassment. Individuals seeking employment at Delta Dental are considered without regard to race, ethnicity, color, age, sex, religion, national origin, ancestry, pregnancy, sexual orientation, gender identity, gender expression, genetic information, actual or perceived physical or mental disability, registered domestic partner status, caregiver status, marital status, veteran or military status, citizenship status, or any other legally protected category. Delta Dental is committed to providing equal employment opportunities to all employees and applicants for employment. Accordingly, we have adopted and maintain an Equal Employment Opportunity Policy, Harassment-Free Work Environment Policy, and Respectful Workplace policies and will not tolerate violations of these policies.
Unfortunately, our Delta Dental Enterprise is unable to hire individuals residing in Alaska, North Dakota, Nebraska, Hawaii, Oklahoma, Vermont, Maine, West Virginia, New Hampshire, Wyoming, Puerto Rico, District of Columbia (Washington D.C.) or other US Territories at this time.
Proof of eligibility to work in the United States must be provided if selected for hire.
- Delta Dental includes: Delta Dental of California, Delta Dental Insurance Company, Delta Dental of Pennsylvania, and Delta Dental of New York
