Sr. Financial Data Analyst

FOR IMMEDIATE DETAILS about this position, please feel free to contact ANY of us: Recruiting Contacts: Kiana Arevalo (469) 325-3712 or (949) 991-8285 // KArevalo@calance.com Sumit Kumar (469) 935-4505 // Sumit.Kumar@calance.com Michell Casey (949) 860-4715 // MCasey@calance.com ======================================================= • • We will NOT accept 3rd Party (C2C) Contractors • • ======================================================= Position: Sr. Financial Data Analyst (Captive Lending Accounting/Financial Reporting) JOB REF#: 43740 - 1440485 Duration: 12 Months (Contract) Location: HYBRID - Plano, TX 75024 Pay Rate: OPEN/Market Rate (W2 ONLY) HYBRID: Hybrid (2-3 days a week in office) - (LOCAL CANDIDATES ONLY) Seeking to hire a Sr. Data Analyst who specialized in Automotive and Captive Lending Accounting/Financial Reporting to support the mapping of reporting data to multiple source systems. This role is essential for ensuring a comprehensive understanding of data topology, system architecture, and integration flows. Candidates should be adept at analyzing and documenting data mappings from the reporting layer to various legacy and modern platforms—including Mainframe technologies (VSAM, DB2) and cloud-based databases such as Snowflake. The ideal candidate will demonstrate strong knowledge of accounting principles, deep expertise in data structures, and practical experience with enterprise systems, all while ensuring documentation aligns with financial reporting standards. RESPONSIBILITIES INCLUDE: Collaborate with Accounting and DnA teams to understand the structure and content of financial schedules and their corresponding source systems. Apply deep knowledge of applications and the accounting framework to trace and map financial data elements back to their origin in source systems. Perform detailed data mapping between accounting schedules and source system fields, ensuring accuracy, consistency, and traceability. Document data lineage, including transformation logic and mapping rules, to support auditability and compliance. Assist in validating the accuracy and completeness of mapped data through reconciliation with financial reports and schedules. Support ongoing reconciliation efforts to ensure mapped data aligns with accounting outputs and reporting standards. DAILY TASKS: Support a CSO transformation project. Perform data mapping by tracing data schedules back to their 450 source locations. Capture fields for variance calculations. Work with data from accounting, General Ledger (GL), and financial statements. REQUIRED SKILLS/EXPERIENCE: • • MUST be able to interview ONSITE • • 8+ years of experience in Financial Data Analysis with expertise in Captive Lending Accounting/Financial Reporting Strong experience in data analytics and Snowflake. Knowledge of SAP is required, with SAP AP/AR knowledge being a plus. Proficiency in SQL, Excel, Databases (Snowflake, DB2) , and familiarity with SAP, Mainframe systems used in financial data environments. Deep working knowledge of financial services applications Strong understanding of accounting principles, financial schedules, and source system structures. Proven experience in data mapping, data lineage documentation, and reconciliation between accounting outputs and source data. Excellent analytical, documentation, and communication skills, with the ability to work cross-functionally with Accounting, IT, and Data teams. Must have an understanding of accounting and financial statements. Excellent oral communication skills Education: Bachelor's Degree DESIRED SKILLS: Knowledge of DB2 Automotive experience ========================================== ========================================== Calance Consultant Benefits Offerings: EPO/PPO Medical Plans HMO/PPO Dental programs - Vision - VSP (Vision Plan Summary) 401K Retirement vesting program (VOYA) Paid Bi-Weekly/Direct Deposit Flex Spending Plan Voluntary Life, AD&D, STD or LTD plans