Data Analyst

⚠️ **SAMPLE LISTING — this is an illustrative placeholder job, not a verified real opening.** Included for content/testing purposes only; do not present the employer, salary, or apply link as confirmed until replaced with a real, verified posting. ## About the Role Support business teams with data-driven insights — building dashboards, running analyses, and presenting findings that inform product and business decisions. ## Key Responsibilities - Write SQL queries to extract and transform data from multiple sources - Build and maintain dashboards (Tableau/Power BI/Looker) - Perform exploratory data analysis to identify trends and anomalies - Present findings to non-technical stakeholders clearly - Collaborate with engineering on data pipeline requirements - Maintain data quality and documentation standards ## Required Skills & Qualifications - 0–2 years experience with SQL and Excel - Familiarity with a BI tool (Tableau/Power BI) and basic Python (pandas) - Bachelor's degree in any quantitative field (CS, Statistics, Economics, Engineering) ## How to Prepare for This Role ### Core Technical Topics to Master SQL joins/aggregations/window functions, Excel pivot tables and formulas, basic statistics (mean/median/std dev, hypothesis testing basics), data visualization principles, basic Python with pandas, dashboard design fundamentals. ### Recommended Free Learning Resources - Mode Analytics SQL tutorial (free) - Khan Academy Statistics - freeCodeCamp Data Analysis with Python - YouTube: Alex The Analyst - Practice: HackerRank SQL, StrataScratch free tier ### 30-60-90 Day Preparation Plan **Days 1-30:** Master SQL joins and aggregations; build pivot table fluency in Excel. **Days 31-60:** Learn a BI tool end-to-end; build 2 dashboards using public datasets (Kaggle). **Days 61-90:** Practice case-study style interview questions; build a portfolio project analyzing a real dataset with a written summary of insights. ## Interview Preparation - Common questions: Explain a time you found an insight in messy data, SQL JOIN types, difference between correlation and causation, how do you validate a dashboard's numbers, what's a window function - Coding round: SQL query writing exercise, sometimes a small case study - HR round: discuss communication style and stakeholder management examples - Salary negotiation: check Glassdoor ranges for "Data Analyst fresher" in your city before negotiating ## Projects to Build for Your Portfolio 1. A sales dashboard built from a public e-commerce dataset 2. A cohort retention analysis using SQL + Python 3. A/B test analysis write-up with statistical significance testing ## Benefits & Perks Health insurance, hybrid work option, learning reimbursement (illustrative — confirm with actual employer). ## How to Apply Submit resume along with any dashboard/portfolio links via the listed application channel.