Master's degree in Computer Science or related field with 3 years of experience as a Business Analyst or similar role.
Proficient in SQL across various relational database systems like Oracle, SQL Server, and MySQL for data profiling and validation.
Experience with Agile tools such as Jira and Confluence for backlog management and documentation.
Skilled in creating comprehensive data integration documentation using tools like Microsoft Visio and UML.
Familiar with end-to-end testing techniques, including SQL-based test scripts and defect tracking.
Knowledge of business intelligence platforms like Power BI for data analysis and insights generation.
Experience with the Facets healthcare administration platform for claims processing and data management.
Responsibilities
Define and manage the product backlog for enterprise data integration initiatives.
Interpret business requirements to derive technical solutions through systems analysis and design.
Collaborate with stakeholders to translate business needs into technical specifications and user stories.
Partner with ETL developers to design scalable integrations across core platforms.
Oversee end-to-end testing and ensure compliance with HIPAA/PHI requirements.
Identify opportunities to modernize data pipelines and optimize ETL performance.
Benefits
Opportunity to work in a collaborative environment with cross-functional teams.
Engagement in innovative data integration projects within the healthcare sector.
Access to professional development resources and training.
Potential for career advancement within a leading insurance company.
Full Job Description
Job Description
EMPLOYER: Delta Dental Insurance Company
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
Responsibilities
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.
Qualifications
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
