Senior Applications Analyst

Delta Dental • Alpharetta, GA

1d • $135,658 - $170,900 • Hybrid

About The Position

Delta Dental Insurance Company is hiring a Senior Applications Analyst to define, prioritize, and manage the product backlog for enterprise data integration initiatives across dental insurance systems. The role interprets business requirements and develops technical solutions through systems analysis, data integration design, and prototyping. It collaborates with stakeholders across claims, eligibility, provider, underwriting, and finance to translate business needs into technical user stories, data mapping specifications, and acceptance criteria.

The analyst partners with ETL developers and data engineers to design and deliver scalable integrations across core platforms, including claims adjudication systems, provider networks, CRM, ERP, and analytical data stores. The role oversees end-to-end testing, ensures compliance with HIPAA and PHI requirements, evaluates system impacts, and identifies ways to modernize data pipelines, improve ETL performance, and move legacy integrations toward cloud-native architectures.

The position is based at 1130 Sanctuary Parkway, Alpharetta, Georgia. The employee must live within reasonable commuting distance of headquarters and be able to appear in the office as required. The listed annual salary range is $135,658 to $170,900. Actual pay may vary based on qualifications, experience, education, certifications, location, and internal equity.

Requirements

• Master’s degree or foreign degree equivalent in Computer Science or a related field.
• Three years of experience in a Business Analyst or related role in the job offered.
• Expertise using SQL across enterprise relational database management systems, including Oracle 11g, Microsoft SQL Server, MySQL, and MS Access, for data profiling, reconciliation, referential integrity checks, and source-to-target validation supporting ETL workflows, batch processing, and enterprise data exchanges.
• Experience with Jira, Confluence, SharePoint, and IT Service Connect for backlog management, sprint planning, user-story creation, requirements documentation, controlled document repositories, issue intake, release workflows, and product roadmap delivery.
• Ability to produce data integration and systems interface documentation, including source-to-target specifications, transformation and normalization logic, business rule frameworks, workflow orchestration models, and system interaction diagrams, using Microsoft Visio, UML-based modeling suites, and draw.io.
• Experience applying end-to-end testing techniques, including writing SQL-based test scripts, creating and executing test cases, tracking defects, and reconciling source-to-target data, using Jira, SQL, and Confluence.
• Experience using business intelligence and analytics platforms, including Power BI and Mableau, to analyze claims, provider, and member data, evaluate integration performance, identify anomalies, and generate business and product insights.
• Experience applying Agile (Scrum) and Waterfall (SDLC) delivery frameworks for backlog refinement, sprint retrospectives, release planning, requirements elicitation, and cross-functional coordination throughout the integration lifecycle.
• Experience executing system integration testing (SIT) and user acceptance testing (UAT), using SQL for data verification, Jira for defect management, and Confluence for acceptance criteria and test evidence.
• Experience using the Facets healthcare administration platform to analyze and support claims processing, member enrollment, eligibility, billing, and provider network data; query Facets-backed databases; synchronize data with external systems; manage member add/update and demographic workflows; configure Facets Workflow components for accumulator synchronization; and support HIPAA and enterprise data security compliance.
• Experience using application analysis and data integration tools, including Microsoft SQL Server Management Studio (SSMS), Oracle SQL Developer, data mapping documentation tools, and workflow modeling frameworks.
• Must live within reasonable commuting distance of headquarters and be able to appear in the office as required.
• Proof of eligibility to work in the United States must be provided if selected for hire.

Responsibilities

• Define, prioritize, and manage the product backlog for enterprise data integration initiatives across dental insurance systems.
• Interpret business requirements and derive technical solutions using systems analysis, data integration design, and prototyping.
• Collaborate with stakeholders in claims, eligibility, provider, underwriting, and finance to translate business needs into technical user stories, data mapping specifications, and acceptance criteria.
• Partner with ETL developers and data engineers to design and deliver scalable integrations across claims adjudication systems, provider networks, CRM, ERP, and analytical data stores.
• Oversee end-to-end testing and ensure compliance with HIPAA and PHI requirements.
• Evaluate system impacts and identify opportunities to modernize data pipelines, optimize ETL performance, and migrate legacy integrations toward cloud-native architectures.

Benefits

• The company describes programs that offer opportunities for advancement and meaningful connections, and improve the lives of employees and their families.
• The company describes stability and balance, opportunities for leadership at all levels, and a teamwork- and camaraderie-focused work environment.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior