Data Analyst

ActivTrak; Austin (TX); On-site; USD 70,000 - 110,000; Full time

Benefits offered by this job

Remote within the US

Limited travel

Limited physical demands

Job summary

ActivTrak seeks a detail-oriented Data Analyst to transform complex data into actionable insights that improve performance. You will design dashboards (Power BI, Looker Studio, Tableau), ensure data quality with engineers, and perform advanced analytics using SQL and Python.

Responsibilities include supporting ad-hoc requests and refining productivity metrics. You’ll collaborate with HR, Operations, and Product teams while communicating clearly to technical and non-technical audiences.

Qualifications

• Bachelor’s degree in a quantitative field.
• Minimum 3 years of experience with SQL, BI tools, Python.
• Experience with Google BigQuery and Google Cloud Platform.
• Strong storytelling and communication skills to influence stakeholders.

Responsibilities

• Design, Develop, and Maintain BI Dashboards & Templates.
• Data Quality Control with engineers to ensure accuracy.
• Perform Advanced Analytics using SQL and Python.
• Facilitate internal ad-hoc data requests from cross-functional teams.
• Enhance productivity metrics and align with business goals.

Skills

SQL

BI tools

Python

API Integrations

Data analysis

ETL & Data Warehousing

AppScripts & PowerShell

Google BigQuery

Google Cloud Platform

Communication

Growth mindset

Attention to detail

Education

Bachelor’s degree in quantitative field

Tools

Tableau

Power BI (DAX/PowerQuery)

Looker Studio

Qlik

Job description

We’re looking for a detail-oriented and strategic Data Analyst to join our data-driven team. You’ll transform complex datasets into clear, actionable insights that drive performance improvements across the business. This role requires strong analytical capabilities, technical proficiency in data tools, and the ability to clearly communicate insights to both technical and non-technical audiences.

Key Responsibilities:

• Design, Develop, and Maintain BI Dashboards & Templates:
  • Design, develop, and optimize dashboards using Power BI, Looker Studio, Tableau, or similar tools.
  • Create interactive reports that translate productivity data into operational insights for ActivTrak customers.
  • Support data integration with third-party systems to enhance reporting capabilities.
• Data Quality Control:
  • Partner with engineers to validate data accuracy, integrity, and consistency.
  • Implement data validation processes to maintain high-quality analytical outputs.
• Perform Advanced Analytics
  • Conduct deep analysis of workforce and productivity trends using SQL and Python.
  • Deliver data-driven recommendations that empower customers to optimize performance and decision-making.
• Facilitate Internal Ad-hoc Data Requests:
  • Support cross-functional teams (HR, Operations, Product) by querying key datasets from Google BigQuery.
  • Ensure timely and accurate responses to ad-hoc data needs.
• Enhance Productivity Metrics:
  • Collaborate on the development and refinement of productivity measurement frameworks.
  • Align metrics with evolving business goals and customer needs.

Requirements

Skills & Experience:

• Bachelor’s degree in a quantitative field such as Data Analytics, Business Analytics, Statistics, Mathematics, Economics, Computer Science, or a related discipline.
• Minimum 3 years of experience in:
  • SQL (advanced queries and optimization)
  • BI tools (Tableau, Power BI w/ DAX & PowerQuery, Looker Studio, or Qlik)
  • Python
  • API Integrations
  • Data analysis, metrics development, and cross-functional reporting
  • ETL and Data Warehousing
  • AppScripts & PowerShell
• Hands‑on experience with Google BigQuery and Google Cloud Platform
• Strong storytelling and communication skills to influence stakeholders at all levels
• Self‑starter with a growth mindset and attention to detail
• Excellent communication skills with both technical and non-technical audiences.
• Ability to deal with ambiguity and collaborate with different teams towards mutual goals.
• Motivated by an interest in developing the best possible solutions

Preferred

• Experience in Workforce Analytics.

Benefits

Work Environment:

• Position is remote within the US

• Limited travel
• Limited physical demands