Data Analyst - Insights, ETL & Dashboards

TikTok; Seattle (WA); On-site; USD 163,000 - 228,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401(k) with company match

Paid parental leave

Disability insurance

Life insurance

Wellbeing benefits

Holidays

Job summary

TikTok is seeking a Data Analyst (Multiple Positions) in Seattle to design data models, transform raw data into actionable insights, and report findings that influence business strategies. The role focuses on extracting and transforming data, building dashboards, and partnering with cross-functional teams for real-time product analysis.

Requirements include a Master’s or Bachelor’s in a related field and 1–3 years of relevant experience with SQL, Python or R, Spark, Hive, and BI tools like Excel

Qualifications

• Master’s or Bachelor’s degree in a related field with required years of experience.
• 1 year in mining, cleansing, and analyzing structured data with SQL, Python or R.
• Experience with SQL and Spark to query and manipulate data from Hive and major DBMS.

Responsibilities

• Design, develop, and implement data models and techniques to transform raw data into insights and recommendations.
• Visualize, analyze, interpret, and report data findings to influence business decisions.
• Create automated dashboards to track real-time product performance.

Skills

SQL

Python

R

Spark

Hive

MySQL

PostgreSQL

Excel

Tableau

ETL

Data Analysis

Education

Master's degree in CS/Engineering/Data Science/Data Analytics/Statistics

Bachelor's degree in CS/Engineering/Data Science/Analytics

Tools

Excel

Tableau

Job description

TikTok is seeking a Data Analyst (Multiple Positions) in Seattle to design data models, transform raw data into actionable insights, and report findings that influence business strategies. The role focuses on extracting and transforming data, building dashboards, and partnering with cross-functional teams for real-time product analysis.

Requirements include a Master’s or Bachelor’s in a related field and 1–3 years of relevant experience with SQL, Python or R, Spark, Hive, and BI tools like Excel