Job Description :
Title : Senior Data Analyst
Location : Herndon, VA
Duration: Long Term
Visa : Any Visa
Senior Data Analyst Position Description:
?The client has an immediate need for a Senior Data Analyst to join the financial services team in Herndon, VA.
Duties and responsibilities:
Role requires strong data analysis and problem-solving skills
Ability to identify data patterns and data gaps or quality issues during data conversion effort
Connect the data to the business processes
Work with SMEs and business stakeholders to plan the data conversion approach
Responsible for development of data conversion scripts thus Strong SQL skills with ability to create complex automated/manual SQL scripts to extract, transform and load data from source to target
Strong data analysis and profiling skills and familiarity with XML, Flat file generation
Collect data conversion requirement working with SMEs and business stakeholders by business process or function
Evaluate data quality
Collect and validate the existing data architecture; validate the new data architecture.
Document requirements, business rules, data structures and test scenarios
Work with upstream business and technology data partners to identify appropriate data source system and fields for data conversion
Strong understanding of relational data models and hands on experience working with various databases like Oracle, SQL Server, MS Access etc.
Responsible for troubleshoot, testing and analysis of converted data set to ensure it meets the business needs
Work with project team members and data governance team to generate end to end data mapping to support the data requirements
Ability to multi-task with minimal supervision
Required qualifications:
Must have 2-3 years of FM MF Data analysis experience
6-8 years working experience as a data analyst
Strong knowledge of and experience with data mapping, XML and SQL
Strong knowledge of and experience with working on multiple applications and establishing data interfaces
Strong analytical skills with the ability to collect, organize, analyze and disseminate significant amounts of information with attention to detail and accuracy
Should have skills documenting data requirements
Ability to translate ETL requirements (source to target mappings)
Ability to document business processes
Excellent communication skills
Education Requirements:
Bachelor degree in Computer Science, Information Systems or related field.
Technical Skills (key skills will show in red)
Data Quality Management
ETL
Teradata