What are the responsibilities and job description for the Data Analyst in Atlanta GA position at Hexaware Technologies, Inc?
Data Analyst
Atlanta GA
Key Responsibilities
- Translate business questions into analyses, KPIs, and dashboards.
- Query and transform data using SQL against RDS, Oracle, Amazon Redshift and Athena.
- Perform data profiling and validation on S3/Redshift datasets; escalate data quality issues and partner on resolution.
- Write Python (pandas) for exploratory analysis, feature preparation, and light automation.
- Optimize queries via appropriate partitioning, filters, and Redshift/Athena best practices.
- Document logic, assumptions, and lineage in Confluence; manage work in Jira.
- Create STTM Mapping document by coordinating with upstream/downstream stakeholders
- Collaborate with data engineers on data requirements, schema changes, and data freshness SLAs.
- Follow version control practices (Git) for SQL, notebooks, and dashboard assets.