Senior Applications Analyst

Delta Dental of California

Alpharetta (GA)

On-site

USD 136,000 - 171,000

Full time

3 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Delta Dental Insurance Company in Alpharetta, GA is seeking a Senior Applications Analyst to define, prioritize, and manage the product backlog for enterprise data integration across dental insurance systems. You will translate business requirements into technical user stories, data mappings, and acceptance criteria, partnering with claims, eligibility, provider, underwriting, and finance teams.

You will collaborate with ETL developers and data engineers to design scalable integrations across

Qualifications

  • Master's degree in Computer Science or related field with 3 years of experience in business analysis or related role.
  • Expertise in SQL across enterprise relational databases (Oracle 11g, MS SQL Server, MySQL, MS Access).
  • Experience with Agile tools Jira, Confluence, SharePoint, IT Service Connect to define user stories and manage backlogs.
  • Proven ability to produce data integration and systems interface documentation with Visio/UML/draw.io.

Responsibilities

  • Define, prioritize, and manage the product backlog for enterprise data integration initiatives.
  • Interpret business requirements and derive technical solutions via systems analysis and data integration design.
  • Collaborate with claims, eligibility, provider, underwriting, and finance domains to translate needs into stories and acceptance criteria.
  • Partner with ETL developers and data engineers to design scalable integrations across core platforms.
  • Oversee end-to-end testing and ensure HIPAA/PHI compliance while modernizing data pipelines.

Skills

SQL proficiency
Agile product management
Stakeholder collaboration
Systems analysis

Education

Master's degree in Computer Science

Tools

Jira
Confluence
SharePoint
IT Service Connect
Microsoft Visio
UML modeling
draw.io
Power BI
Tableau (Mableau)

Job description

EMPLOYER: Delta Dental Insurance Company

Senior Applications Analyst

Location: 1130 Sanctuary Parkway, Alpharetta, GA 30009; Must live within reasonable commuting distance from HQ and able to appear in office as required.

Salary: $135,658.00/yr - $170,900.00/yr

  • Responsible for defining, prioritizing, and managing the product backlog for enterprise data integration initiatives across dental insurance systems.

  • The role interprets business requirements and derives technical solutions using systems analysis, data integration design, and prototyping.

  • Collaborates with stakeholders in claims, eligibility, provider, underwriting, and finance domains to translate business needs into technical user stories, data mapping specifications, and acceptance criteria.

  • Partners with ETL developers and data engineers design and deliver scalable integrations across core platforms, including claims adjudication systems, provider networks, CRM, ERP, and analytical data stores.

  • Oversee end-to-end testing, ensures compliance with HIPAA/PHI requirements, evaluates system impacts, and identifies opportunities to modernize data pipelines, optimize ETL performance, and migrate legacy integrations toward cloud-native architectures.

  • Must live within reasonable commuting distance from HQ and able to appear in office as required.

  • Master's degree or foreign degree equivalent in Computer Science, or related field and three (3) years of experience in Business Analyst or related role in the job offered.

  • Expertise in leveraging Structured Query Language (SQL) across enterprise-grade relational database management systems - including Oracle 11g, Microsoft SQL Server, MySQL, and MS Access to perform data profiling, reconciliation, referential integrity checks, and source-to-target validation in support of ETL workflows, batch processing jobs, and enterprise data exchanges.

  • Using Agile Product Management and work-tracking tools Jira (for backlog management, sprint planning, and user story creation), Confluence (for requirements documentation), SharePoint (for controlled document repositories), and IT Service Connect (for issue intake and release workflows) to define user stories, document acceptance criteria, manage sprint execution, and support product roadmap delivery.

  • Proven capability in producing comprehensive data integration and systems interface documentation, including detailed 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 to enable middleware development and downstream data consumption.

  • Applying end-to-end testing techniques including writing SQL-based test scripts, creating and executing test cases, performing defect tracking, and reconciling source-to-target data-to validate integration deliverables using Jira, SQL, and Confluence for documentation and tracking.

  • Using enterprise business intelligence and analytics platforms including Power BI and Mableau to analyze claims, provider, and member data, evaluate data integration performance, identify anomalies, and generate insights that support business and product decision-making.

  • Applying Agile (Scrum) and Waterfall (SDLC) delivery frameworks to conduct backlog refinement, sprint retrospectives, release planning, requirements elicitation sessions, and cross-functional coordination with developers, QA engineers, data architects, and compliance teams throughout the integration lifecycle.

  • Executing system integration testing (SIT) and user acceptance testing (UAT) processes using SQL for data verification, Jira for defect lifecycle management, and Confluence for acceptance criteria and test evidence to ensure integrated data solutions meet defined business and regulatory requirements.

  • Using the Facets healthcare administration platform to analyze and support claims processing, member enrollment, eligibility, billing, and provider network data by querying Facets-backed databases, implementing data synchronization with external systems, managing member add/update and demographic workflows, configuring Facets Workflow (FWF) components for accumulator synchronization across claims, benefits, and eligibility modules, and ensuring compliance with HIPAA and enterprise data security standards.

  • Utilizing application analysis and data integration tools including Microsoft SQL Server Management Studio (SSMS), Oracle SQL Developer, data mapping documentation tools, and workflow modeling frameworks to review integration logic, interpret data lineage, validate requirements, and support delivery of scalable enterprise data solutions.

    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 21. $135,658.00-$170,900.00

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Compensation Analyst
Senior Compensation Analyst

Delta Dental Ins. • Alpharetta (GA)

On-site
USD 80,500 - 174,300
Competitive base and incentive pay
401(k) with robust matching
Rich medical & pharmacy benefits
+5
Senior Legal Analyst
Senior Legal Analyst

Delta Dental • San Francisco (CA)

On-site
USD 72,000 - 151,000
Senior Financial Planning & Analysis (FP&A) Analyst – Business Cases
Senior Financial Planning & Analysis (FP&A) Analyst – Business Cases

Delta Dental Ins. • Oakland (CA)

Hybrid
USD 71,000 - 150,000
Competitive base pay
Incentive pay
401(k) with matching
+3
Senior Data Architect
Senior Data Architect

Delta Dental Ins. • Oakland (CA)

On-site
USD 93,000 - 200,000
Competitive salary
Senior Software Engineer - Oracle HCM Cloud
Senior Software Engineer - Oracle HCM Cloud

Delta Dental of California • Alpharetta (GA)

Hybrid
USD 93,000 - 200,000
Competitive base pay
401(k) with matching
Medical & pharmacy benefits
+3
Senior Systems Administrator - FP&A
Senior Systems Administrator - FP&A

Delta Dental Ins. • Rancho Cordova (CA)

Hybrid
USD 81,000 - 176,000
Senior Systems Administrator - FP&A
Senior Systems Administrator - FP&A

Delta Dental • California

Hybrid
USD 81,000 - 176,000
Senior Data Integration Architect
Senior Data Integration Architect

Delta Dental of California • Alpharetta (GA)

On-site
USD 136,000 - 171,000
Senior Data Architect
Senior Data Architect

Delta Dental Ins. • Rancho Cordova (CA)

On-site
USD 93,000 - 200,000
Competitive base pay
401(k) with matching
Medical & pharmacy benefits
+3
Senior Financial Planning & Analysis (FP&A) Analyst – Business Cases
Senior Financial Planning & Analysis (FP&A) Analyst – Business Cases

Delta Dental Ins. • Rancho Cordova (CA)

Hybrid
USD 71,000 - 150,000
Competitive base and incentive pay
401(k) with matching contributions
Medical & pharmacy benefits
+2