What are the responsibilities and job description for the Data Analyst (Ex-Capital One)- W2 position at Lorvenk Technologies LLC?
Title: Data Analyst
Location: Richmond or McLean, VA (Hybrid)
Duration: Long Term
Exp: 7
Employment: W2
Job Description
We are seeking a skilled Data Analyst with strong expertise in SQL and AWS to analyze, manage, and transform data into meaningful insights. The ideal candidate will work closely with business and technical teams to support data-driven decision-making.
Key Responsibilities
Write complex and optimized SQL queries to extract, analyze, and validate data from multiple sources.
Design and maintain datasets using AWS services such as S3, Redshift, Athena, Glue, and RDS.
Perform data analysis, data validation, and data quality checks.
Develop reports and dashboards to support business insights.
Collaborate with stakeholders to understand data requirements and translate them into analytical solutions.
Support ETL processes and data pipelines in AWS environments.
Identify trends, patterns, and anomalies in large datasets.
Document data definitions, business rules, and analytical processes.
Required Skills
Strong hands-on experience with SQL (complex joins, subqueries, window functions, performance tuning).
Solid experience with AWS data services (S3, Redshift, Athena, Glue, RDS).
Experience working with large datasets and relational databases.
Strong analytical and problem-solving skills.
Proficiency in Excel; experience with visualization tools (Power BI, Tableau, or QuickSight) is a plus.
Understanding of data warehousing concepts and ETL processes.