Dice is the leading career destination for tech experts at every stage of their careers. Our client, eSolutionsFirst, LLC, is seeking the following. Apply via Dice today! • Needed local to Mclean, VA • • • Senior ETL Data Analyst 6 Months Contract- Extension long term Location : Onsite Mclean, VA Mon Fri Must Have Qualifications: • Must have experience analyzing Business Requirement Specifications (BRS) and ETL code • Able to understand ETL code • SQL quires • Understanding of Unix. • Development experience is preferred. • DataStage -SAS is nice to have but not required Job Description: • 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. Key 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. Expertise in complex SQL for data analysis, validation, and script development. • Strong ability to understanding of enterprise-scale systems and data environments and, create data mapping documents. • Excellent analytical skills with a keen attention to detail. • Strong communication and collaboration abilities.