Data Analyst

Position: Data Analyst - Financial Data Location: Plano, Texas Duration: Contract Job ID: 169926 Job Overview: We are seeking experienced Data Analysts with a specialization in Automotive and Captive Lending Accounting/Financial Reporting. This role is critical for mapping data reporting to multiple source systems, ensuring a comprehensive understanding of data topology, system architecture, and integration flows. The ideal candidate will have expertise in 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. A strong knowledge of accounting principles, data structures, and enterprise systems is essential, along with the ability to ensure documentation aligns with financial reporting standards. Responsibilities: • Collaborate with Accounting and DNA teams to understand the structure and content of financial schedules and their corresponding source systems. • Apply deep knowledge of client 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. • 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. Qualifications: • 8+ years of experience in financial data analysis. • 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. • Deep working knowledge of client applications. • Proficiency in SQL, Excel, Databases (Snowflake, DB2), and familiarity with SAP and Mainframe systems used in financial data environments. • Excellent analytical, documentation, and communication skills, with the ability to work cross-functionally with Accounting, IT, and Data teams. • At least 6 years of experience in data analytics and Snowflake. • Understanding of accounting and financial statements. • Knowledge of SAP is required, with SAP AP/AR knowledge being a plus. • Knowledge of client applications and DB2 is a nice-to-have. Education: • Bachelor's degree required. Soft Skills: • Strong communication skills are essential. About PTR Global: PTR Global is a leading provider of information technology and workforce solutions. PTR Global has become one of the largest providers in its industry, with over 5000 professionals providing services across the U.S. and Canada. For more information visit www.ptrglobal.com At PTR Global, we understand the importance of your privacy and security. We NEVER ASK job applicants to: • Pay any fee to be considered for, submitted to, or selected for any opportunity. • Purchase any product, service, or gift cards from us or for us as part of an application, interview, or selection process. • Provide sensitive financial information such as credit card numbers or banking information. Successfully placed or hired candidates would only be asked for banking details after accepting an offer from us during our official onboarding processes as part of payroll setup. Pay Range: $80 - $88 The specific compensation for this position will be determined by several factors, including the scope, complexity, and location of the role, as well as the cost of labor in the market; the skills, education, training, credentials, and experience of the candidate; and other conditions of employment. Our full-time consultants have access to benefits, including medical, dental, vision, and 401K contributions, as well as PTO, sick leave, and other benefits mandated by applicable state or localities where you reside or work. If you receive a suspicious message, email, or phone call claiming to be from PTR Global do not respond or click on any links. Instead, contact us directly at +1 214-740-2424. To report any concerns, please email us at legal@pinnacle1.com