Data Analyst

ASTIKA SOFTWARE TECHNOLOGIES PRIVATE LIMITED; Hyderabad; On-site; INR 500,000 - 800,000; Full time

Job summary

ASTIKA SOFTWARE TECHNOLOGIES PRIVATE LIMITED seeks a Data Analyst skilled in SQL, RDBMS, and Python for data analysis and automation. You will extract, transform, analyze, and visualize data to deliver actionable business insights, partnering with stakeholders to shape data-driven decisions.

The role emphasizes building complex SQL queries, data processing with Python, and creating Power BI/Tableau dashboards to communicate findings to leadership and teams.

Qualifications

• Strong SQL, Excel, and Python skills required.
• Experience with large datasets and data transformations.
• Ability to derive insights and communicate with stakeholders.

Responsibilities

• Write optimized SQL queries to extract and analyze large datasets.
• Design and tune database queries for performance.
• Use Python for data processing and automation.
• Perform data analysis to identify trends and insights.
• Create dashboards with Power BI or Tableau to communicate results.
• Collaborate with business stakeholders to translate requirements into data solutions.

Skills

SQL

Excel

Python

Data Transformation

Database Management

Data Visualization

Tools

Power BI

Tableau

Job description

We are seeking a skilled Data Analyst with strong expertise in SQL, relational database management systems (RDBMS), and Python for data analysis and automation. The ideal candidate will work closely with business stakeholders to extract, transform, analyze, and visualize data to deliver actionable business insights.

Job Title : Data Analyst

Job Overview

We are seeking a skilled Data Analyst with strong expertise in SQL, relational database management systems (RDBMS), and Python for data analysis and automation. The ideal candidate will work closely with business stakeholders to extract, transform, analyze, and visualize data to deliver actionable business insights.

Key Responsibilities

• Write complex, optimized SQL queries to extract, manipulate, and analyze large datasets efficiently.
• Demonstrate strong proficiency in database management, including query design, optimization, performance tuning, and handling large-scale data.
• Apply intermediate to advanced Python skills for data processing, automation, and analytical tasks.
• Conduct sophisticated data analysis to identify trends, patterns, and actionable insights using tools such as Python and Excel/Spreadsheets.
• Clean, transform, validate, and structure complex datasets to support in-depth analytical requirements.
• Develop advanced visualizations and interactive dashboards using Power BI or Tableau to effectively communicate business insights.
• Collaborate with business stakeholders to understand analytical requirements and translate them into meaningful data-driven solutions.

Required Skills & Qualifications

• SQL & Excel: Strong expertise in SQL and Excel, with the ability to write and optimize complex queries for performance and scalability.
• Python: Strong foundational to intermediate proficiency in Python, particularly Pandas and NumPy, for data manipulation and analysis.
• Data Analysis & Transformation: Proven experience working with large and complex datasets, including data cleaning, transformation, analysis, and interpretation.
• Database Management: Strong understanding of relational databases, query optimization, database structures, and performance considerations.
• Data Visualization: Advanced skills in creating dashboards, reports, and visualizations using Power BI or Tableau.
• Business Acumen: Ability to translate business requirements into analytical solutions and communicate data-driven insights clearly to stakeholders.