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,