Data Analyst

Job Summary

Aivanta Tech Inc is seeking a skilled Data Analyst to collect, analyze, and interpret data to support business decisions.

The ideal candidate will have strong expertise in SQL, Excel, data visualization, and statistical analysis.

The candidate should be able to transform raw data into meaningful insights, develop reports and dashboards, and collaborate with business stakeholders to improve operational efficiency and business performance.

Key Responsibilities

• Collect, clean, validate, and analyze data from multiple sources.
• Perform exploratory data analysis (EDA) to identify trends, patterns, and business opportunities.
• Develop and maintain interactive dashboards and reports using Power BI or Tableau.
• Write complex SQL queries to extract, manipulate, and analyze data.
• Prepare reports and presentations to communicate actionable business insights.
• Collaborate with business stakeholders to understand analytical requirements.
• Identify data quality issues and implement data validation processes.
• Perform data reconciliation, trend analysis, and root cause analysis.
• Develop KPIs and metrics to measure business performance.
• Automate recurring reports and data analysis processes.
• Support business process improvements through data-driven recommendations.
• Maintain documentation related to data sources, reporting processes, and analytical methodologies.

Required Skills and Qualifications

• 3+ years of experience in Data Analytics or a related field.
• Strong proficiency in SQL, including joins, subqueries, CTEs, and window functions.
• Advanced Microsoft Excel skills, including PivotTables, VLOOKUP/XLOOKUP, and data analysis.
• Experience with Power BI, Tableau, or other data visualization tools.
• Knowledge of data cleaning, transformation, and validation techniques.
• Understanding of statistical analysis and business intelligence concepts.
• Experience working with large datasets and multiple data sources.
• Strong analytical thinking and problem-solving skills.
• Excellent communication and stakeholder management abilities.

Preferred Qualifications

• Experience with Python or R for data analysis.
• Knowledge of ETL processes and data warehousing concepts.
• Familiarity with cloud platforms such as AWS, Azure, or Google Cloud.
• Experience with Snowflake, Databricks, or similar data platforms.
• Knowledge of business domains such as healthcare, finance, retail, or technology.
• Bachelor's or Master's degree in Data Analytics, Computer Science, Statistics, Information Technology, or a related field.

Key Competencies

• Data Analysis and Interpretation
• SQL and Database Management
• Power BI / Tableau
• Advanced Excel
• Data Visualization and Reporting
• Business Intelligence
• Data Quality and Validation
• Business Communication

Candidate Submission Details

Interested candidates should share their updated resume along with their total experience, relevant Data Analyst experience, current location, work authorization status, and interview availability.