Required Skills & Experience
- 6+ years of Business Systems Analysis, Systems Analysis, Technical Analysis, or similar experience.
- Strong hands-on SQL skills, including JOINs, aggregates, subqueries, data comparisons, and reconciliation.
- Experience independently investigating backend systems and data rather than relying solely on developers or DBAs.
- Experience supporting a large-scale system implementation, migration, conversion, or complex technology transformation.
Healthcare payer experience, including Medicaid, Medicare, LTSS, PBM, claims, clinical systems or similar
- Strong systems analysis, troubleshooting, root-cause analysis, and impact analysis skills.
- Ability to translate business requirements into detailed technical and functional requirements.
- Strong critical-thinking and communication skills with demonstrated initiative and independence.
Nice to Have Skills & Experience
Previous development, QA/testing, application support, or other technical background. Experience with SQL Server Management Studio (SSMS) or similar database tools. Experience troubleshooting APIs, system integrations, interfaces, batch processes, or application logs.
Experience with HealthEdge or similar healthcare payer platforms
Job Description
A healthcare payer client is seeking a Senior Technical Systems Analyst to support a large-scale, multi-year technology transformation. This is a hands-on systems analysis role for someone who can independently investigate complex applications and data, translate business needs into technical requirements, and partner closely with development, QA, architecture, and business teams.
This is not a traditional Business Analyst role. The ideal candidate has strong hands-on SQL and systems analysis experience and can investigate issues, perform impact analysis, and understand backend system behavior without relying entirely on developers.
Key Responsibilities
- Analyze current-state applications, workflows, databases, integrations, and system logic to define future-state requirements.
- Independently investigate technical issues, identify root causes and impacts, and recommend solutions.
- Write and execute SQL queries to analyze data, compare tables, trace transactions, reconcile discrepancies, and support impact analysis.
- Translate business needs into detailed functional and technical requirements for development and QA teams.
- Perform data mapping, source-to-target mapping, conversion analysis, and system impact analysis.
- Troubleshoot applications and integrations across databases, APIs, interfaces, files, batch processes, and downstream systems.
- Partner directly with developers, architects, QA, vendors, and business stakeholders throughout design, testing, implementation, and production validation.
Ideal Profile: A curious, hands-on systems analyst who can dig into the data, understand how systems interact, ask the right technical questions, and bring developers a well-investigated problem rather than simply passing along a business request.