Senior Data Analyst

Our Client, a Real Estate and Financial Services company, is looking for a Senior Data Analyst for their McLean, VA location.

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.

Requirements:

• At least + 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.
• Must have experience analyzing Business Requirement Specifications (BRS) and ETL code, SQL quires, understanding of Unix. Development experience is preferred.
• Project details
• Modernization project
• Move source systems from the blue field to the brown field
• Source Snowflake and target AWS S & flat files
• Someone's experience in understanding ETL code.
• The team is using DataStage and SLS.
• Analyzing Business Requirements
• Need to have the ability to read and understand the ETL code.
• Migrating from one technology to another.
• ETL, SQL, Unix, and development experience preferred.

Why Should You Apply?

• Excellent growth and advancement opportunities