Senior Applications Analyst

TITLE: 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

APPLY: Apply Directly at:

https://ejep.fa.us2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1/job/3648/?utm_medium=jobshare&utm_source=External+Job+Share