Data Analyst – Automotive & Captive Lending

BEPC has an open position for a Data Analyst – Automotive & Captive Lending Location: Plano, TX (3 days onsite MANDATORY) Benefits: Medical, Dental, Vision, and Life Insurance Pay Rate: $85.23 – $88.23 Per hour with weekly pay!!! Term: 12-month contract with possible extensions or permanency based on performance Shift: M-F, 8AM – 5PM Requirements: Bachelor’s degree & 8+ years of experience in financial data analysis / Proficiency in SQL, Excel, and databases (Snowflake, DB2). • • • • • NO CORP-TO-CORP CANDIDATES WILL BE CONSIDERED • • • • • Job Description: We are seeking an experienced Data Analyst with a specialization in Automotive and Captive Lending Accounting/Financial Reporting. This role will focus on supporting reporting data mapping across multiple source systems, ensuring comprehensive understanding of data topology, system architecture, and integration flows. The ideal candidate will bring a strong background in accounting principles, data structures, and enterprise systems while ensuring documentation aligns with financial reporting standards. Key Responsibilities: · Collaborate with Accounting and Data & Analytics (DnA) teams to understand the structure and content of financial schedules and their corresponding source systems. · Apply expertise in TFS applications and accounting frameworks 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. · Validate 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. · Assist with variance calculations and data tracing from over 450 source locations as part of the CSO transformation project. Required Qualifications: · 8+ years of experience in financial data analysis (minimum 6 years considered with the right skillset). · Strong understanding of accounting principles, financial schedules, and general ledger (GL) structures. · Proven expertise in data mapping, data lineage documentation, and reconciliation between accounting outputs and source data. · Deep working knowledge of TFS applications (preferred). · Proficiency in SQL, Excel, and databases (Snowflake, DB2). · Familiarity with SAP (required), with SAP AP/AR knowledge considered a strong plus. · Experience with Mainframe systems (VSAM, DB2) is highly desirable. · Bachelor’s degree required in Accounting, Finance, Information Systems, or a related field. Technical Skills · Databases: Snowflake, DB2 · Applications: TFS, SAP (AP/AR a plus) · Languages/Tools: SQL, Excel · Platforms: Mainframe technologies, Cloud-based databases USOPS Job Types: Full-time, Contract Pay: $85.23 - $88.23 per hour Expected hours: 40 per week Benefits: Dental insurance Health insurance Life insurance Vision insurance Education: Bachelor's (Required) Experience: Financial Data Analysis: 8 years (Required) Accounting Principles: 8 years (Required) Snowflake, DB2: 8 years (Required) SAP AP/AR: 8 years (Required) Ability to Commute: Plano, TX 75024 (Required) Work Location: In person