Senior Applications Analyst

Delta Dental • Alpharetta, GA

22h • 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 works with stakeholders across claims, eligibility, provider, underwriting, and finance to turn 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 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, assesses system impacts, and identifies opportunities 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.

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 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 using Jira, Confluence, SharePoint, and IT Service Connect for backlog management, sprint planning, user story creation, requirements documentation, controlled document repositories, issue intake, and release workflows.
• 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 with end-to-end testing, including writing SQL-based test scripts, creating and executing test cases, tracking defects, and reconciling source-to-target data.
• Experience using Power BI and Mableau to analyze claims, provider, and member data, assess integration performance, identify anomalies, and generate insights.
• Experience applying Agile (Scrum) and Waterfall (SDLC) delivery frameworks, including backlog refinement, sprint retrospectives, release planning, requirements elicitation, and cross-functional coordination.
• 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; implement data synchronization with external systems; manage member add/update and demographic workflows; configure Facets Workflow (FWF) components for accumulator synchronization; and comply with HIPAA and enterprise data security standards.
• 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.

Responsibilities

• Define, prioritize, and manage the product backlog for enterprise data integration initiatives.
• 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 create 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.
• Support integration delivery through requirements documentation, data validation, defect tracking, and coordination with developers, QA engineers, data architects, and compliance teams.

What This Job Offers

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