Data Analyst

Astika Software Technologies; Hyderabad; On-site; INR 900,000 - 1,200,000; Full time

Job summary

Astika Software Technologies in Hyderabad seeks a Data Analyst to extract, transform, analyze, and visualize data to deliver actionable business insights.

You will write complex SQL queries, manage relational databases, and use Python (Pandas/NumPy) for data processing and automation.

Collaborate with stakeholders to define analytical requirements, develop advanced dashboards in Power BI or Tableau, and translate data findings into business decisions.

Qualifications

• Strong SQL and Excel skills for complex queries.
• Proficient Python (Pandas/NumPy) for data manipulation.
• Experience with data cleaning, transformation, and interpretation.
• Knowledge of relational databases and query optimization.
• Experience with Power BI or Tableau for visualizations.
• Ability to translate business requirements into analytics.

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 data analysis to identify trends, patterns, and actionable insights using Python and Excel/Spreadsheets.
• Clean, transform, validate, and structure complex datasets to support analytical requirements.
• Develop advanced visualizations and dashboards using Power BI or Tableau to communicate insights.
• Collaborate with stakeholders to understand analytical requirements and translate them into data-driven solutions.

Skills

SQL

Excel

Python

Data Visualization

Data Transformation

Dashboarding

Job description

Job Title : Data Analyst

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.

Work Mode :

Full-time

Job :

IT&Services

Location :

Hyderabad

Years of Experience :

4-6