Data Analyst
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
Skills
As published by workable · 9 questions · 5 written answers
Basics
First name, Last name, Email, Phone, Address, Education, Experience, Resume, Cover letter
Short answers (2)
- If you answered yes to the question above, please paste your LinkedIn below.
- Attach a GitHub repo or short case study you're proud of.
Pick from a list (2)
- Do you have authorization to work in the United States without need for sponsorship?
- Do you have a LinkedIn?
Written answers (5)
- Describe a SQL query you've written against a production database in the last 6 months — what business question was it answering, and what made it non-trivial (joins, window functions, performance)?
- Walk me through one dashboard you built end-to-end (design → deployment → user adoption) in Tableau, Power BI, or Looker Studio. What decision did it support, and how did you know it was actually being used?
- Which cloud data warehouse have you used in the last 6 months, and what kind of work did you do in it — ad hoc queries, pipeline/ETL work, or data modeling?
- Tell me about a time your analysis contradicted what a stakeholder expected. What did you do?
- Please list two professional references (ideally people who have directly managed or supervised your work) who can speak to your technical skills and team collaboration. Include their full name, current role, email, phone number, and how long you worked together.