Lead Data Analyst (AWS)

Job Title: Lead Data Analyst (AWS)

Location: Malvern, PA & Charlotte, NC

Duration: Long Term

Key Responsibilities

• Lead requirements gathering with business stakeholders.
• Analyze large-scale datasets stored in AWS data platforms.
• Design and develop dashboards and executive reports.
• Define KPIs and business metrics across products.
• Perform trend analysis, root cause analysis, and forecasting.
• Partner with data engineering teams to improve data quality.
• Develop SQL queries and optimize analytical workloads.
• Validate data pipelines and ensure reporting accuracy.
• Present insights and recommendations to senior leadership.
• Mentor junior analysts and establish analytical best practices.

Required Skills

• Advanced SQL
• Python (Pandas, NumPy)
• AWS Redshift
• Amazon Athena
• AWS Glue
• Amazon S3
• QuickSight or Tableau or Power BI
• Excel (Advanced)
• Data Quality Frameworks
• Statistical Analysis
• Business Process Analysis

Preferred AWS Experience

• Redshift
• Athena
• Glue
• Lake Formation
• S3
• IAM
• CloudWatch
• Step Functions (nice to have)

Qualifications

• Bachelor’s or Master’s degree in Computer Science, MIS, Statistics, or related field.
• 10+ years in Data Analytics.
• 4+ years working with AWS analytics platforms.

Nice to Have

• Financial Services or Wealth Management experience
• Agile/Scrum
• Machine Learning exposure
• AWS Certified Data Analytics – Specialty