Website AVUA

Data Analyst – Avua

Opportunity Overview

Attribute Details
Organization Avua (AI-powered Global Workforce & Hiring Platform)
Position Title Data Analyst
Experience Requirement 1 – 2 Years in Data Analysis
Primary Location India
Industry Specialisation Technology / Artificial Intelligence (Servicing Energy, Robotics, Construction, Tech, Healthcare, Life Sciences)
Employment Type Full-Time, Permanent
Academic Target Bachelor’s or Master’s degree in Statistics, Applied Mathematics, or equivalent quantitative experience
Core Technical Stack SQL, Data Visualisation (Power BI / Tableau / Looker), Business Analytics, Data Compilation

Business Analytics & Insight Delivery Workflow

The Data Analyst at Avua translates operational business challenges into data-driven solutions across recurring and ad-hoc reporting cycles:

┌───────────────────────────────────────────┐
│ 1. Problem Framing & Issue Identification │ ➔ Partner with business users to understand operational pain points and requirements
└─────────────────────┬─────────────────────┘
                      ▼
┌───────────────────────────────────────────┐
│ 2. Data Compilation & Extraction          │ ➔ Execute efficient SQL queries to aggregate datasets across client & candidate pools
└─────────────────────┬─────────────────────┘
                      ▼
┌───────────────────────────────────────────┐
│ 3. Quantitative Analysis                  │ ➔ Perform recurring and ad-hoc statistical analysis to uncover operational patterns
└─────────────────────┬─────────────────────┘
                      ▼
┌───────────────────────────────────────────┐
│ 4. Visualization & Stakeholder Delivery   │ ➔ Design intuitive dashboards and reports to present clear insights to stakeholders
└───────────────────────────────────────────┘

Key Responsibilities

  • Business Issue Translation: Work closely with business users to identify day-to-day operational challenges and frame them into structured analytical inquiries.

  • SQL Data Extraction: Write optimized SQL queries to compile, clean, and transform large datasets from primary relational databases.

  • Recurring & Ad-Hoc Analytics: Conduct regular operational reporting while executing rapid ad-hoc analyses to support real-time decision-making.

  • Data Visualization & Storytelling: Build clean, intuitive visual reports and dashboards to convey complex statistical data in a clear, digestible manner.

Qualification Matrix & Technical Skill Stack

Core Requirements

Category Specifications
Educational Background Bachelor’s or Master’s degree in Statistics, Applied Mathematics, or related quantitative disciplines.
Professional Experience 1 to 2 years of focused experience conducting data analysis in commercial environments.
Core Technical Skill Expert-level proficiency in SQL for database querying, joining, and aggregation.
Analytical Capabilities Applied knowledge of statistical techniques, data compilation, and quantitative problem-solving.
Data Storytelling Ability to transform raw complex data into clear visual insights for non-technical leadership.

Key Focus Areas for Interview Preparation

  1. Applied SQL Mechanics: Practice writing complex SQL queries involving aggregations, subqueries, CTEs, window functions, and multi-table joins.

  2. Business Problem Case Studies: Prepare for case interviews where you must structure an analytical approach for open-ended business questions (e.g., metric tracking, funnel conversion analysis).

  3. Data Visualization Principles: Be ready to discuss dashboard design choices, metric selection, and how you translate statistical concepts into straightforward visual stories.

Upload your CV/resume or any other relevant file. Max. file size: 2 GB.