Job Description :
Data Analyst (SQL, ETL, Data Modeling) (H1 TRANSFERS ALSO ACCEPTED ONLY ON W2)
City: Reston, Virginia, United States
EMPLOYMENT TYPE: W2 ONLY ( NO C2C)
VISA: ANY (H1 TRANSFERS ALSO ACCEPTED ONLY ON W2)
DURATION: LONGTERM

ROLES AND RESPONSIBILITIES

Provide data analysis support to Customer Identity and Access Management (CIAM) portfolio
Write complex SQL queries
Build ETL logic/model
Help with analyzing SQL queries from Front End to Back End, and optimize it.
Analyze/interpret data requirements and perform current/target/gap/impact analyses.
Collecting, querying and interpreting data to find patterns and trends.
Prepare documents such as technical requirements, data mapping, gap analysis, use case models and propose workflows, data flows, implementation plans and end user guides in accordance with standards and methodologies.
Identify data anomalies and communicate back to the data stewards.
3 to 5 years of related experience
Strong SQL skills
Design, develop, test, implement, and troubleshoot ETL mappings and workflows
Skills to look at existing databases, run SQL queries, and perform data mapping
Ability to optimize existing SQL queries running from front end to back end
Strong database experience, data analysis and analytical skills
Demonstrated data modeling skills
Strong analytical skills with the ability to collect, organize, analyze and disseminate significant amounts of information with attention to detail
Demonstrated ability to work in a fast-paced environment with proven problem solving skills
Ability to communicate effectively and succinctly
High energy and drive. Laser-focused on delivery with strategic-thinking, collaboration, facilitation, negotiation and motivational skills.
Some Tableau knowledge for reporting and dashboards
Experience with Seibel database
Experience with data aggregation, data visualization, business intelligence and data analytics is a plus
Skills
SQL
Data Analysis
ETL
SQL/PL SQL