Business Insights Analyst

taskus; Colombia; On-site; COP 190,803,000 - 286,205,000; Full time

Job summary

TaskUs is seeking a Business Insights & Automation Analyst to turn complex telemetry, task logs, and model evaluation data into actionable insights and automated workflows. You will work primarily with Google Stack (BigQuery, Sheets, Looker Studio, Apps Script) alongside Redshift, querying large datasets and building lightweight internal web tools.

You will focus on operational performance, SLAs, and classifier quality, delivering executive-ready dashboards and rigorous RCA to improve throughput

Qualifications

• Experience in Google Apps Script to automate data pipelines and interact with APIs or BigQuery.
• Advanced SQL expertise with BigQuery and Redshift, using CTEs and window functions.
• Advanced Google Sheets modeling with complex formulas.
• BI & data visualization in Looker Studio with BigQuery and Sheets sources.
• AI/ML evaluation and statistical modeling for labeling accuracy.

Responsibilities

• Write optimized SQL queries to extract, aggregate, and transform large-scale operational data.
• Develop automations and lightweight internal apps using Google Apps Script.
• Analyze throughput metrics and SLA compliance across operations.
• Design executive dashboards in Looker Studio using BigQuery and Sheets.
• Evaluate labeling accuracy and classifier performance with standard metrics.
• Conduct deep-dive analyses to identify bottlenecks and data discrepancies.

Skills

Google Apps Script

Advanced SQL (BigQuery & Redshift)

Advanced Google Sheets Modeling

BI & Data Visualization in Looker

AI/ML Evaluation & Statistical Mod...

Tools

Looker Studio

Job description

About TaskUs: TaskUs is a provider of outsourced digital services and next-generation customer experience to fast-growing technology companies, helping its clients represent, protect and grow their brands. Leveraging a cloud-based infrastructure, TaskUs serves clients in the fastest-growing sectors, including social media, e-commerce, gaming, streaming media, food delivery, ride-sharing, HiTech, FinTech, and HealthTech.

The People First culture at TaskUs has enabled the company to expand its workforce to approximately 60,000 employees globally. Presently, we have a presence in twenty-three locations across twelve countries, which include the Philippines, India, and the United States.

It started with one ridiculously good idea to create a different breed of Business Processing Outsourcing (BPO)! We at TaskUs understand that achieving growth for our partners requires a culture of constant motion, exploring new technologies, being ready to handle any challenge at a moment's notice, and mastering consistency in an ever-changing world.

What We Offer

At TaskUs, we prioritize our employees' well-being by offering competitive industry salaries and comprehensive benefits packages. Our commitment to a People First culture is reflected in the various departments we have established, including Total Rewards, Wellness, HR, and Diversity. We take pride in our inclusive environment and positive impact on the community. Moreover, we actively encourage internal mobility and professional growth at all stages of an employee's career within TaskUs. Join our team today and experience firsthand our dedication to supporting People First.

As a Business Insights & Automation Analyst, you will be responsible for turning complex operational telemetry, task logs, and model evaluation data into actionable business intelligence and automated workflows. You will work primarily within the Google Ecosystem (BigQuery, Google Sheets, Looker Studio, Google Apps Script) alongside Amazon Redshift, querying massive datasets, building lightweight internal web tools/automations, and reporting on operational performance, Service Level Agreements (SLAs), and machine learning classifier quality.

Key Responsibilities & Deliverables

Focus Area and Core Responsibilities

• Data Extraction & Warehousing: Write optimized, robust SQL queries across Google BigQuery and Amazon Redshift to extract, aggregate, and transform large-scale operational records.
• Workflow Automation & Tooling: Develop, deploy, and maintain custom automations, triggers, and lightweight internal Web Apps using Google Apps Script to eliminate manual reporting friction.
• Operational & SLA Analytics: Track and analyze key throughput metrics, including queue latency, handle times, reassignment ratios, and SLA compliance across operations teams.
• Reporting & Dashboards: Design and maintain executive-ready, automated dashboards strictly in Looker Studio and advanced Google Sheets.
• AI/ML Quality & Classification: Evaluate ground-truth labeling accuracy and classifier outputs using standard metrics (Precision, Recall, F1-Score, Confusion Matrices).
• Root Cause Analysis (RCA): Conduct deep-dive statistical investigations into performance bottlenecks, triage errors, and data discrepancies.

Required Qualifications & Core Competencies

1. Must-Have Technical Skills (Strict Requirements)

• Demonstrated Experience in Google Apps Script (GAS): Proven experience writing JavaScript-based scripts in Google Apps Script to automate data pipelines, sync data across Google Sheets, trigger email alerts, and interact with external APIs or BigQuery. Experience developing custom functions, scheduled triggers, and interactive Google Sheets tools.
• Advanced SQL (BigQuery & Amazon Redshift): Hands‑on proficiency querying columnar and cloud data warehouses (Google BigQuery and Amazon Redshift). Strong command of Common Table Expressions (CTEs), window functions, partitions, and query optimization techniques for high‑volume datasets.
• Advanced Google Sheets Modeling: Mastery of complex formulas (QUERY, FILTER, ARRAYFORMULA, INDEX/MATCH, regex functions) and data normalization.
• BI & Data Visualization (Google Stack): Deep experience building interactive, clean dashboards solely in Looker Studio integrated with BigQuery and Google Sheets data sources.
• AI/ML Evaluation & Statistical Modeling: Solid understanding of classification metrics: Precision, Recall, F1-score, False Positives/Negatives. Ability to design sampling plans and statistical methods to audit labeling accuracy and task quality.

2. Professional & Operational Competencies

• Technical-to-Executive Translation: Ability to translate raw operational data into high-level business stories and actionable recommendations for stakeholders.
• Process Optimization Mindset: Proactive identification of operational bottlenecks and initiative to build automated solutions rather than relying on manual reporting.

Nice-to-Have

• Experience with Python (pandas, numpy) for