Data Analyst – Astika Software Technologies

Opportunity Overview

Data Analysis & Reporting Operations Workflow

The Data Analyst (L1) at Astika Software Technologies processes, cleans, and translates operational and software metrics into functional dashboards and structured business reports:

┌───────────────────────────────────────────┐
│ 1. Requirements Scoping & Ingestion       │ ➔ Extract raw datasets across software applications and database instances
└─────────────────────┬─────────────────────┘
                      ▼
┌───────────────────────────────────────────┐
│ 2. SQL Extraction & Data Cleansing        │ ➔ Execute structured SQL queries to clean, transform, and aggregate data
└─────────────────────┬─────────────────────┘
                      ▼
┌───────────────────────────────────────────┐
│ 3. Dashboard Design & Trend Analysis      │ ➔ Build dynamic dashboards and reports using Excel and modern BI tools
└─────────────────────┬─────────────────────┘
                      ▼
┌───────────────────────────────────────────┐
│ 4. Stakeholder Reporting & Maintenance    │ ➔ Validate metric accuracy, document data dictionaries, and present findings
└───────────────────────────────────────────┘

Key Responsibilities

• Data Extraction & Querying: Write and execute standard-to-advanced SQL queries to pull, aggregate, and transform raw software and client data.

• Dashboarding & Report Generation: Design, build, and maintain interactive visual reports using Excel, Power BI, or Tableau to track core operational metrics.

• Data Cleansing & Validation: Perform data hygiene checks, audit records for anomalies or missing values, and reconcile multi-source inputs.

• Process Documentation & Delivery: Maintain up-to-date data definitions, schema documentation, and reporting schedules for internal project teams.

Qualification Matrix & Technical Skill Stack

Core Requirements

Key Focus Areas for Interview Preparation

1. SQL Fundamentals: Practice live SQL coding on basic joins (INNER, LEFT), grouping logic (GROUP BY, HAVING), and aggregation functions (COUNT, SUM, AVG).

2. Excel Data Manipulation: Be ready to demonstrate pivot table design, conditional formatting, data cleansing formulas (TRIM, CONCATENATE, IFS), and lookup functions.

3. Business Metric Translation: Practice explaining how you take raw data tables and convert them into simple, visually appealing chart formats for management review.