Data Analyst Intern
Share
Job Location:
Monthly Salary:
Posted on:
9 hours ago
Vacancies:
1 Vacancy
Job Summary
About the Role
Were looking for a sharp analytical and business-savvy Data Analyst who is a power user of SQL across platforms like PostgreSQL MySQL and AWS this role you wont just write high-performance queriesyoull also automate reporting flows build scalable pipelines and ensure real-time visibility into business metrics across teams.
If you thrive at the intersection of data engineering automation and business storytelling this role is for you.
Key Responsibilities
Build optimize and maintain complex SQL queries on Postgres MySQL MongoDB and Athena to generate actionable reports and dashboards.
Automate query execution and reporting via Google Sheets using AWS Lambda or equivalent serverless solutions.
Set up and manage scheduled jobs alerts and workflows using AWS Data Pipeline Step Functions or similar orchestration tools.
Partner with business stakeholders (Ops Marketing Finance Product) to understand reporting needs and deliver high-impact solutions.
Own day-to-day reporting requirementsautomated and ad-hocincluding operational metrics cohort analyses funnel reports and performance dashboards.
Identify data gaps inconsistencies and propose scalable solutions for reporting infrastructure.
Translate business problems into analytical tasks and convert data into insights that drive decision-making.
Collaborate with Data Engineering/Platform teams to ensure data integrity and pipeline reliability.
Must-Have Skills
Advanced SQL proficiency across PostgreSQL MySQL and AWS Athena.
Strong experience in automating data workflows especially pushing query outputs to Google Sheets using AWS Lambda or similar tools.
Knowledge of AWS Data Pipeline Glue jobs and scheduling/event-driven processing.
Experience with data modeling and structuring datasets for analytics.
Comfortable navigating large and messy datasets to answer open-ended business questions.
Proficient in Excel and/or BI tools (e.g. Metabase Power BI Tableau Looker).
Good understanding of business KPIs and ability to derive insights from raw data.
Bonus Points
Experience with Python or for Lambda scripting and automation.
Familiarity with DBT or modern data stack (e.g. Snowflake Redshift Fivetran).
Exposure to product or supply chain analytics in a fast-paced environment.
Required Skills:
pythondataawssql
Key Skills
- Data Analytics
- Microsoft Access
- SQL
- Power BI
- R
- Data Visualization
- Tableau
- Data Management
- Data Mining
- SAS
- Data Analysis Skills
- Analytics
