Data Analyst

Title Job Title: Data Analyst Location: Plano, TX, 75024(Onsite) Duration : 1 Year Key Responsibilities: • Analyze and document data flows between customer-facing forms, correspondence templates, and enterprise systems such as Salesforce (CRM), Snowflake (Data Platform), Mainframe DB2/VSAM (Servicing Systems), and Document Management Systems • Reverse-engineer legacy forms and communications to uncover undocumented data dependencies and embedded logic • Map form fields to Common Data Elements (CDEs), ensuring consistency and alignment across platforms • Conduct data profiling and validation to confirm the accuracy, completeness, and reliability of mapped elements • Maintain and update metadata repositories, including data dictionaries and lineage documentation • Execute detailed data mapping between source systems and Adobe forms, ensuring mappings are reviewed and validated by business stakeholders • Document data lineage, transformation logic, and mapping rules to support auditability and regulatory compliance • Perform rigorous data validation and quality checks to ensure accurate mapping and output • Support reconciliation efforts to verify the completeness and correctness of mapped data • Ensure all data elements used in customer correspondence adhere to privacy regulations such as GDPR and CCPA • Collaborate closely with Data Stewardship, Product Owners, Legal, Customer Experience, and Dealer Experience teams to align data usage with strategic business objectives Qualifications: • Minimum of 6 years of hands-on experience in data analysis, with a strong focus on enterprise data environments • Solid understanding of automotive finance products, including retail loans, leases, lease-end processes, collections, and bankruptcy workflows • Prior experience in automotive captive finance or consumer lending environments • Demonstrated expertise in data mapping, documenting data lineage, and reconciling data across core systems and dynamic, customer-facing forms • Proficient in SQL, Excel, and working with databases such as Snowflake and DB2; familiarity with mainframe systems commonly used in financial services • Exceptional analytical, documentation, and communication skills, with the ability to collaborate effectively across teams including Customer Experience and Dealer Experience