Data Analyst

Detailed Job Description: Job Title: Data Analyst Client: Bank Location: Mclean, VA (Onsite) Duration: 06 Months Pay Range: $40 - $45/HR Benefits: The Company offers the following benefits for this position, subject to applicable eligibility requirements: medical insurance, dental insurance, vision insurance, 401(k) retirement plan, life insurance, long-term disability insurance, short-term disability insurance, paid parking/public transportation, (paid time , paid sick and safe time , hours of paid vacation time, weeks of paid parental leave, paid holidays annually - AS Applicable) Overview: • This involves making a substantial effort to update our applications and systems. • To ensure a smooth transition with minimal disruption, we are looking for experienced Data Analysts who can identify critical system dependencies and assist in modernizing outdated data platforms and workflows. • This position is ideal for candidates who are highly analytical, adept at working with large-scale enterprise systems, and possess a strong background in data mapping, ETL, and data warehousing. Responsibilities: • Partner with cross-functional teams to identify dependencies between applications and systems on the current CDW platform. • Analyze and interpret Business Requirement Specifications (BRS) and ETL code to align with modernization objectives. • Collaborate with stakeholders to define data requirements for Finance and Accounting systems. • Create detailed mapping documents that outline data flows, transformations, and system interactions. • Develop and validate complex SQL queries to support data analysis and migration efforts. • Assist in mapping source to target tables/columns (Nexus to Finance apps) and define derivation logic as part of the modernization process. • Ensure comprehensive documentation and traceability of all data lineage and mapping activities. Required Qualifications: • At least 5+ years of experience in data analysis, data warehousing, or related fields. • Strong understanding of ETL processes with the ability to read and interpret ETL code. • Practical experience or familiarity with tools such as DataStage, Informatica, SAS, and Python.