Senior Financial Data Analyst - Reconciliation & Controls

CareSource•Ohio WFH, OH

1d•$94,100 - $164,800

About The Position

The Financial Data Solutions Analyst III, titled Senior Financial Data Analyst, Reconciliation & Controls, establishes, executes, and maintains reconciliation, validation, certification, and control processes for finance data consumed from the data warehouse (MDP). The role ensures that finance data reconciles to approved authoritative sources, control activities are executed and documented, variances are investigated and tracked, and supporting evidence is maintained for Finance reporting, close activities, audit readiness, and analytical decision-making. The analyst partners with Finance, Operations, Internal Controls, Audit, and Technology to define in-scope data, authoritative sources, validation scope, control frequency, tolerances, evidence requirements, and sign-off responsibilities. The role maintains recurring controls and documentation, supports month-end and year-end close, assesses data readiness, manages exceptions through resolution or formal risk acceptance, and supports internal and external audits. It also develops control and trend metrics and identifies opportunities to improve the efficiency and consistency of finance data controls. This position is based in a general office environment, where sitting or standing for extended periods may be required. Travel is not typically required. The role is salaried, with a compensation range of $94,100 to $164,800; candidates may also qualify for a bonus tied to company and individual performance. CareSource offers a substantial and comprehensive total rewards package.

Requirements

Bachelor's degree in accounting, finance, economics, business analytics, information systems, computer science, or a related field, or equivalent relevant work experience in lieu of the required education.
Five years of experience in finance, accounting, auditing, financial reporting, internal controls, data analysis, or a related professional role.
Strong understanding of reconciliation, variance analysis, evidence retention, and internal control principles.
Knowledge of Finance reporting and close processes.
Strong SQL skills for data validation, reconciliation, analysis, and variance investigation.
Advanced proficiency with Microsoft Excel.
Proficiency with Microsoft Office Suite.
Strong analytical, critical-thinking, and problem-solving skills.
Ability to identify, investigate, document, and explain discrepancies across multiple data sources.
Ability to create and maintain procedures, control documentation, and audit-ready evidence.
Ability to manage recurring controls and time-sensitive close deadlines.
Ability to communicate effectively with Finance, Operations, Audit, Technology, and management at all levels.
Ability to lead cross-functional discussions and drive issue ownership and resolution.
Ability to work independently and exercise sound judgment.
Detail-oriented.

Nice To Haves

Master's or other related post-graduate degree.
Experience performing data reconciliations, variance analysis, exception management, and supporting documentation.
Experience working with large claims, encounter, enrollment, membership, financial, or other operational datasets.
Managed care or healthcare experience.
Databricks platform knowledge.
SAP Analysis for Office knowledge.
Knowledge of audit support, internal controls, or control testing.
Familiarity with SAP data, healthcare claims and enrollment data, Databricks, or large-scale analytical environments.
CPA, CMA, CIA, CISA, Association for Financial Professionals FP&A, or related certification.

Responsibilities

Maintain and execute reconciliation and validation procedures for finance data consumed from MDP.
Partner with Finance, Operations, Internal Controls, Audit, and Technology to define in-scope finance data, authoritative sources, validation scope, control frequency, tolerances, evidence requirements, and sign-off responsibilities.
Reconcile finance data in MDP to approved authoritative sources and document results.
Validate balances, record counts, key metrics, and business measures for completeness, accuracy, and timeliness.
Establish and maintain reconciliation procedures, control schedules, templates, and supporting documentation.
Identify, investigate, document, and track variances and control exceptions affecting finance data.
Identify accountable source or business owners for in-scope datasets and obtain required review, certification, and sign-off.
Develop and maintain the recurring Finance Data Controls Close Package for month-end and year-end close activities.
Produce finance data readiness assessments identifying risks, unresolved exceptions, accepted variances, and impacts to Finance use.
Maintain evidence supporting control execution, reconciliations, reviews, approvals, and sign-offs.
Facilitate root-cause analysis of reconciliation variances with accountable business, source-system, and technology owners.
Maintain the finance data exception register and monitor remediation through resolution or formal risk acceptance.
Support internal and external audits by providing reconciliation results, certifications, evidence, and control documentation related to finance data in MDP.
Monitor adherence to control schedules, validation requirements, and close deadlines.
Develop metrics and trend reporting for control execution, reconciliation outcomes, exception aging, and finance data readiness.
Identify opportunities to improve the efficiency, consistency, and repeatability of finance data controls.
Perform other job-related duties as requested.