Overview
On Site
Depends on Experience
Contract - W2
Contract - 12 Month(s)
Able to Provide Sponsorship
Skills
Business Requirement Specifications (BRS) and ETL code
SQL quires
understanding of Unix.
Job Details
Data Analyst Specialist
Onsite McLean, VA
Contract
- Must Haves: Must have experience analyzing Business Requirement Specifications (BRS) and ETL code, SQL quires, understanding of Unix.
Data Analyst Requirements & Context
- Experience: 5+ years in SQL, ETL code analysis, Unix, and BRD/specs; development experience preferred.
- Tools: Must understand ETL logic; experience with DataStage and SAS preferred, but other ETL tools (e.g., Informatica, Python) acceptable.
- Project: Supporting CW data warehouse migration to cloud as part of a Brownfield to Goldfield modernization.
- Responsibilities: Analyze data structures, cleanse data, map old to new systems, and create SQL mappings.
- Targets: Snowflake, S3, flat files.
- Data Analysts will work closely with: Business analysts, ETL developers, Cloud migration specialists, Project managers, Source system owners
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.
c
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.