AWS Data Analyst

Overview

Role and Responsibilities

• Design and implement ETL using AWS Glue, Python, and SQL to ingest, transform, and load data.
• Develop and maintain data lakes and data warehouses leveraging Amazon S3 and Amazon Redshift.
• Optimize data storage, performance, and cost efficiency using Redshift Spectrum and query tuning.
• Build reusable data ingestion and transformation frameworks following best practices for reusability, scalability, and security
• Troubleshoot performance bottlenecks, ensure system reliability, and follow AWS Well-Architected and security best practices.
• Collaborate with cross-functional teams to define and implement data models, data governance, and solution design aligned with business goals.
• Implement data quality checks, monitoring, and metadata management across ETL pipelines.
• Liaise with SBU users, Development team, Center of excellence team, Regional Infrastructure team during execution of project deliverables.
• Responsible for requirements gathering through design, development, and implementation of the solution within Data Analytics.
• Document requirements, create functional specifications and prepare wireframes/flowcharts
  
• Prepare technical user manuals, system configuration documents and provide user training

*Required Skills & Experience *

• Strong hands-on experience with AWS analytics stack: AWS Glue, Amazon Redshift, Amazon S3, AWS Lambda, Step Functions, Athena (good to have).
• Proficiency in Python for data processing and automation.
• Strong SQL expertise for complex queries, transformations, and data validation.
• Experience with data modeling, schema design, and dimensional modeling (Star/Snowflake schemas).
• Good understanding of solution design principles, data architecture, and integration patterns.
• Exposure to data governance, cataloging, and security best practices in AWS environment.
• Willingness to learn and adapt to new technologies and areas such as Generative BI and Tableau

*Soft Skills *

• Strong problem-solving and analytical skills.
• Ability to work independently and in agile teams.
• Excellent communication and documentation skills.

Preferred Qualifications

• AWS Certified Data Analytics
  
• Experience integrating data with BI tools (Tableau, DataiQ) and OBIEE reporting