Data Analyst - Financial Reporting & Data Mapping

A leading enterprise organization is seeking an experienced Data Analyst with a strong background in automotive and captive lending accounting/financial reporting. This role will support a large-scale transformation project by mapping reporting data across multiple legacy and modern source systems. The ideal candidate brings a combination of financial data expertise, data mapping skills, and knowledge of system architectures-including both mainframe (VSAM, DB2) and cloud environments (Snowflake, SAP). This position requires a deep understanding of accounting principles, strong technical skills in SQL, and the ability to trace data from reporting outputs back to source systems with accuracy and compliance. Key Responsibilities • Perform detailed data mapping between financial schedules, reporting layers, and source system fields. • Trace and document data lineage including mapping rules, transformation logic, and reconciliation processes. • Collaborate with Accounting, IT, and Data teams to ensure accuracy and completeness of mapped data. • Support reconciliation efforts to align source data with financial statements and schedules. • Analyze data from General Ledger (GL), accounting, and financial reporting systems to capture key fields and variance calculations. • Provide clear and auditable documentation that supports compliance and financial reporting standards. Required Qualifications • 6-8+ years of experience in data analysis with a focus on financial/accounting data. • Strong knowledge of accounting principles, financial schedules, and reporting structures. • Proficiency in SQL, Excel, and database technologies (Snowflake, DB2). • Hands-on experience with SAP (AP/AR knowledge is a plus). • Proven track record in data mapping, lineage documentation, and reconciliations. • Bachelor's degree required. • Excellent analytical, documentation, and communication skills; ability to work cross-functionally. Preferred Qualifications • Experience with mainframe systems (VSAM, DB2). • Exposure to large enterprise accounting/reporting applications. • Familiarity with financial compliance and audit requirements. Interview Process • Two rounds of interviews via Microsoft Teams.