Data Analyst

Hirevantis LLC; Austin (TX); On-site; USD 70,000 - 90,000; Full time

Job summary

Hirevantis LLC in Austin, TX is seeking a detail-oriented Data Analyst with 2-4 years of experience to collect, analyze, and present data for informed business decisions.

The role emphasizes SQL, Excel, and data visualization (Power BI or Tableau), translating complex data into actionable insights and delivering reports to stakeholders. You will collaborate with cross-functional teams to identify KPIs and drive data-driven improvements.

Qualifications

• 2-4 years of professional Data Analytics/BI experience.
• Strong proficiency in SQL including joins, subqueries, aggregations, and data manipulation.
• Hands-on experience with Microsoft Excel, Pivot Tables, and advanced formulas.

Responsibilities

• Collect, clean, validate, and analyze data from multiple sources.
• Write and optimize SQL queries to analyze large datasets.
• Develop, maintain dashboards and reports using Power BI or Tableau.
• Analyze trends and performance metrics to identify opportunities for improvement.
• Prepare recurring and ad hoc reports for stakeholders.
• Validate data and perform quality checks to identify discrepancies.
• Collaborate with cross-functional teams to translate requirements into analytics solutions.
• Identify KPIs and track performance against targets.
• Document data processes and analytical findings.
• Present insights clearly to technical and non-technical stakeholders.

Skills

SQL

Data analytics

Business intelligence

Excel

Data interpretation

Communication

Problem solving

Multitasking

Independent & collaborative work

Education

Bachelor's degree in a related field

Master's degree or certifications (plus)

Tools

Power BI

Tableau

SQL Server

MySQL

PostgreSQL

Snowflake

Excel (Pivot Tables, VLOOKUP/XLOOKUP)

Job description

We are looking for a detail-oriented and analytical Data Analyst with 2-4 years of experience in collecting, analyzing, interpreting, and presenting data to support business decisions. The ideal candidate will have strong SQL and Excel skills, experience with data visualization tools such as Power BI or Tableau, and the ability to translate complex datasets into actionable business insights.

Key Responsibilities

• Collect, clean, validate, and analyze data from multiple sources to ensure accuracy and consistency.
• Write and optimize SQL queries to extract, manipulate, and analyze large datasets.
• Develop, maintain, and enhance dashboards, reports, and visualizations using Power BI or Tableau.
• Analyze business trends, patterns, and performance metrics to identify opportunities for improvement.
• Prepare recurring and ad hoc reports for business stakeholders and management.
• Perform data validation, reconciliation, and quality checks to identify discrepancies.
• Work with cross-functional teams to understand business requirements and translate them into analytical solutions.
• Identify key performance indicators (KPIs) and track business performance against established targets.
• Document data processes, reporting procedures, and analytical findings.
• Present insights and recommendations clearly to technical and non-technical stakeholders.

Required Skills & Qualifications

• 2-4 years of professional experience in Data Analytics, Business Intelligence, or a related role.
• Strong proficiency in SQL, including joins, subqueries, aggregations, and data manipulation.
• Hands-on experience with Microsoft Excel, including Pivot Tables, VLOOKUP/XLOOKUP, and advanced formulas.
• Experience with at least one data visualization tool: Power BI or Tableau.
• Good understanding of data cleaning, data validation, data transformation, and reporting.
• Knowledge of statistical concepts and analytical techniques.
• Ability to interpret data, identify trends, and communicate actionable insights.
• Strong problem-solving, analytical, and communication skills.
• Ability to manage multiple tasks and work independently as well as collaboratively.

Preferred Qualifications

• Experience with Python (Pandas, NumPy) for data analysis and automation.
• Exposure to databases such as SQL Server, MySQL, PostgreSQL, or Snowflake.
• Familiarity with ETL processes and data warehousing concepts.
• Knowledge of cloud data platforms such as AWS, Azure, or Google Cloud.
• Experience working in Agile or cross-functional business environments.

Education

• Bachelor's degree in Computer Science, Information Technology, Statistics, Mathematics, Business Analytics, or a related field.
• Master's degree or relevant certifications in Data Analytics, Power BI, Tableau, or SQL are a plus.

What We're Looking For

• A data-driven professional with strong attention to detail.
• Someone who can turn raw data into meaningful business insights.
• A proactive problem-solver who can work with stakeholders and deliver accurate reports on time.
• A clear communicator who can explain analytical findings and recommendations effectively.