Support the mapping of reporting data to multiple source systems, ensuring a comprehensive understanding of data topology, system architecture, and integration flows for Automotive and Captive Lending Accounting/Financial Reporting.
Requirements
- Proficiency in SQL, Excel, Databases (Snowflake, DB2)
- Familiarity with SAP, Mainframe systems used in financial data environments.
- Proven experience in data mapping, data lineage documentation, and reconciliation between accounting outputs and source data.
- Deep working knowledge of TFS applications
- Strong understanding of accounting principles, financial schedules, and source system structures.
- Mainframe technologies (VSAM, DB2)
- cloud-based databases such as Snowflake
Responsibilities
- Analyze and document data mappings from the reporting layer to various legacy and modern platforms—including Mainframe technologies (VSAM, DB2) and cloud-based databases such as Snowflake.
- Collaborate with Accounting and DnA teams to understand the structure and content of financial schedules and their corresponding source systems.
- Apply deep knowledge of TFS 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.
Other
- 8+ years of experience in financial data analysis
- Excellent analytical, documentation, and communication skills, with the ability to work cross-functionally with Accounting, IT, and Data teams.
- Green Card, US Citizen
- No travel required
- 9 AM to 5 PM
