Data Analyst

Adroit India
Hyderabad, Telangana, India

Job Title: Data Analyst - Python

Location: Hyderabad

Experience Required: 5+ years

Employment Type: Full-time

Job Summary

We are seeking a Data Analyst with at least 5 years of experience to join our data team. This role bridges the gap between raw data engineering and business strategy, leveraging Python and advanced SQL to transform complex datasets into actionable insights. Working alongside our Data Engineering team, you will analyze on-premises data structures, build analytical models, and design business intelligence dashboards. The ideal candidate has deep expertise in data exploration, statistical analysis, and Python-driven reporting automation.

Key Responsibilities

  • Exploratory Data Analysis: Conduct deep-dive analysis on complex, on-premises relational databases using Python and SQL to uncover trends, anomalies, and insights.
  • Data Preparation & Validation: Partner with Data Engineers to validate data pipeline outputs, performing source-to-target reconciliation and schema validations to ensure report accuracy.
  • Python for Analytics: Develop modular, reusable Python scripts using Pandas, NumPy, and Scipy for data manipulation, statistical modeling, and automated data profiling.
  • Advanced Querying: Write complex SQL queries, window functions, and Common Table Expressions (CTEs) to extract custom data slices from on-premises data marts and data warehouses.
  • Dashboarding & Visualization: Design, build, and maintain high-impact dashboards and semantic models in enterprise tools such as Power BI or Tableau.
  • Automation & Scripting: Automate routine analytical workflows, scheduled data extractions, and metric calculations using Python and basic scheduling tools.
  • Business Collaboration: Work closely with product owners, stakeholders, and business analysts to translate complex requirements into quantitative data models and metrics.
  • Root Cause Analysis: Troubleshoot data discrepancies in reporting layers, performing log and discrepancy analysis to trace data issues back to source tables.Required Skills
  • Advanced Python: Proven experience using Python as a primary tool for data manipulation and analysis, specifically leveraging libraries like Pandas, NumPy, and visualization libraries (Matplotlib, Seaborn).
  • Expert SQL: Strong mastery of relational databases, complex joins, subqueries, analytical window functions, and query optimization for reporting performance.
  • BI & Data Visualization: High proficiency in designing scalable, interactive dashboards and data models in Power BI, Tableau, or equivalent enterprise tools.
  • Analytical Thinking: Solid grasp of statistical analysis concepts (e.g., hypothesis testing, regression, data distributions) and data warehousing schemas (Star/Snowflake).
  • Problem Solving: Ability to audit and reconcile data sets across multiple systems, ensuring a high level of report integrity and data quality.Optional Skills
  • Database Environments: Experience working with Oracle or SQL Server on-premises architectures is highly advantageous.
  • Linux/Shell Basics: Basic comfort with Linux/Unix command-line tools for navigating file environments or running scripts.
  • Version Control: Working knowledge of Git for tracking analysis scripts and collaborative code reviews.
  • Workflow Tools: Exposure to automated scheduling concepts (like Airflow or enterprise schedulers) is a plus.Qualifications
  • Education: Bachelor’s degree in Computer Science, Statistics, Data Analytics, or a related quantitative field.
  • Experience: 5+ years of hands-on experience in a Data Analyst or Data Scientist role, focusing heavily on Python scripting, SQL query development, and business intelligence.

Score my resume against this job, free →

Questions about this job

How do I apply for the Data Analyst job at Adroit India?

Use the apply link on this page: you apply directly with Adroit India on LinkedIn. Before you do, score your resume against this job description on Fitboard. It shows which skills and keywords the job asks for that your resume doesn't show, so you can fix them first.

What skills does Adroit India want for this Data Analyst role?

The job description asks for Advanced Python, Expert SQL, BI & Data Visualization, Analytical Thinking and Problem Solving. Make sure your resume shows the ones you have, in the words the job uses: applicant tracking systems look for them.

How can I get a job at Adroit India?

Apply to the Adroit India roles that match your experience, and tailor your resume to each job description: for this role that means showing Advanced Python, Expert SQL, BI & Data Visualization. A resume that matches the job's own keywords is more likely to get past screening. Fitboard scores your resume against this exact job for free.

Is this Data Analyst job remote or onsite?

This is based in Hyderabad, Telangana.

Is it free to apply? Does Fitboard charge anything?

Applying is free: you apply directly with Adroit India, and this job page and its apply link cost nothing. Checking your resume against this job is free too, with 3 free scans when you sign in and no credit card needed.

Will you get shortlisted for this role? Check your match free →