The Role Performs finance data reconciliations, validations, variance investigations, and control activities using SQL and Excel. Maintains audit-ready evidence, exception registers, close packages, procedures, certifications, and reporting. Partners with Finance, Audit, Operations, Internal Controls, and Technology stakeholders to resolve discrepancies, assess data readiness, support audits, and improve recurring control processes. Summary Generated by Built In About the role: This position is ideal for an experienced financial analyst or auditor who combines strong financial reconciliation and controls experience with technical skills in SQL and Excel.

Job Summary:

Financial Data Solutions Analyst III (Senior Financial Data Analyst, Reconciliation & Controls) The Financial Data Solutions Analyst III is responsible for establishing, executing, and maintaining 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, required 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.

Essential Functions:

Maintain and execute reconciliation and validation procedures for finance data consumed from MDP. Work with Finance stakeholders and appropriate Operations, Internal Controls, Audit, and Technology partners to define in-scope finance data, authoritative reference sources, validation scope, control frequency, tolerances, evidence requirements, and sign-off responsibilities. Reconcile finance data in MDP to approved authoritative sources and document the 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 the accountable source or business owner for each in-scope dataset and obtain required owner review, certification, and sign-off. Develop and maintain the recurring Finance Data Controls Close Package supporting 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 signoffs. 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 efficiency, consistency, and repeatability of finance data controls. Perform any other job related duties as requested.

Education and Experience:

Bachelor's degree in accounting, finance, economics, business analytics, information systems, computer science or related field required Master's or other related post-graduate degree preferred Equivalent years of relevant work experience may be accepted in lieu of required education Five (5) years of experience in finance, accounting, auditing, financial reporting, internal controls, data analysis, or a related professional role required Experience performing data reconciliations, variance analysis, exception management, and supporting documentation preferred Experience working with large claims, encounter, enrollment, membership, financial, or other operational datasets preferred Managed care or healthcare experience preferred

Competencies, Knowledge and Skills:

Strong understanding of reconciliation, variance analysis, evidence retention, and internal control principles Knowledge of Finance reporting and close processes Strong SQL skills are required for data validation, reconciliation, analysis, and variance investigation. Databricks platform knowledge preferred. Advanced proficiency with Microsoft Excel, SAP Analysis for Office knowledge preferred 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 all levels of Finance, Operations, Audit, Technology, and management Ability to lead cross-functional discussions and drive issue ownership and resolution Ability to work independently and exercise sound judgment Knowledge of audit support, internal controls, or control testing is preferred Familiarity with SAP data, healthcare claims and enrollment data, Databricks, or large-scale analytical environments is preferred

Detail-oriented Licensure and Certification:

Certified Public Accountant (CPA), Certified Management Accountant (CMA), Certified Internal Auditor (CIA), Certified Information Systems Auditor (CISA),Association for Financial Professionals 9AFP) FP&A, or related certification preferred

Working Conditions:

General office environment; may be required to sit or stand for extended periods of time Travel is not typically required

Compensation Range:

$94,100.00 - $164,800.00 CareSource takes into consideration a combination of a candidate's education, training, and experience as well as the position's scope and complexity, the discretion and latitude required for the role, and other external and internal data when establishing a salary level. In addition to base compensation, you may qualify for a bonus tied to company and individual performance. We are highly invested in every employee's total well-being and offer a substantial and comprehensive total rewards package. Compensation Type (hourly/salary): Salary Organization Level Competencies Fostering a Collaborative Workplace Culture Cultivate Partnerships Develop Self and Others Drive Execution Influence Others Pursue Personal Excellence Understand the Business This job description is not all inclusive. CareSource reserves the right to amend this job description at any time. CareSource is an Equal Opportunity Employer. We are dedicated to fostering an environment of belonging that welcomes and supports individuals of all backgrounds. #LI-EM1 Brand=CareSource Read Full Description Skills Required Bachelor's degree in accounting, finance, economics, business analytics, information systems, computer science, or a related field Equivalent relevant work experience may substitute for the required education Five years of experience in finance, accounting, auditing, financial reporting, internal controls, data analysis, or a related professional role Strong SQL skills for data validation, reconciliation, analysis, and variance investigation Advanced proficiency with Microsoft Excel Strong understanding of reconciliation, variance analysis, evidence retention, and internal control principles Knowledge of Finance reporting and close processes Strong analytical, critical thinking, and problem-solving skills Ability to 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 Ability to lead cross-functional discussions and drive issue ownership and resolution Master's or related post-graduate degree Experience performing data reconciliations, variance analysis, exception management, and supporting documentation Experience with large claims, encounter, enrollment, membership, financial, or 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, AFP

FP&A, or related certification CareSource Compensation & Benefits Highlights The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about CareSource and has not been reviewed or approved by CareSource. About This Summary Strong & Reliable Incentives — Bonuses are regularly available and serve as a meaningful part of total compensation. Annual performance-based awards are considered a strong component. Leave & Time Off Breadth — PTO starts around four weeks and increases with tenure, complemented by paid holidays and a floating day. Volunteer time expands the available leave options. Affordable Benefits — Health plan options are considered affordable, supported by wellness incentives that can reduce premiums. Coverage breadth includes medical, dental, vision, and cost‑lowering programs. Learn more about CareSource's Compensation & Benefits → CareSource Insights What's It Like to Work at CareSource? CareSource Culture & Values CareSource Career Growth & Development What's the Work-Life Balance Like at CareSource? CareSource Leadership & Management CareSource Company Growth, Stability & Outlook View all jobs at CareSource View CareSource Profile Report Job