TikTok · 1 day ago
Data Analytical Engineer, Payment Data Intelligence - USDS
San Jose, CA
Full-time
Onsite
Mid Level
$119K/yr - $259K/yr
3+ years expTikTok is the leading destination for short-form mobile video, and they are seeking a highly skilled Data Analytical Engineer to join their Payment Data Intelligence team. This role involves designing, building, and maintaining scalable data infrastructure and ETL/ELT pipelines to transform complex payment data into actionable datasets, driving strategic decision-making and optimizing payment operations.
Content CreatorsContent DiscoveryMedia and EntertainmentSocial MediaVideo
Responsibilities
Design and Development: Design, build, and optimize robust, scalable data models and ETL/ELT pipelines to ingest, process, and transform massive volumes of payment transaction data from various data sources (RDS, MQ, 3rd Party etc)
Infrastructure Management: Manage and maintain our data warehouse environment and data lake infrastructure, ensuring high performance, availability, and security
Data Quality and Governance: Implement automated data quality checks, monitoring, and validation processes to ensure the accuracy, completeness, and consistency of all payment intelligence datasets
Performance Optimization: Tune data pipelines and queries for maximum performance and cost efficiency, especially for real-time and near real-time data flows
Collaboration: Work closely with Data Scientists, Data Analysts, Product Managers, and solution teams to understand their data requirements and deliver custom data solutions that power reports, dashboards, and analytical models
Tooling and Technology: Evaluate and implement new technologies and tools to improve data engineering efficiency and the overall data ecosystem
Documentation: Create and maintain comprehensive documentation for data models, architecture, and ETL/ELT processes
Qualification
Required
Bachelor's or Master's degree in Computer Science, Engineering, Statistics, or a related quantitative field
3+ years of professional experience in Data Engineering, Analytical Engineering, BI Engineering, or similar role
Expert-level knowledge of SQL and deep experience working with large, complex datasets in a cloud-based data warehouse
Strong proficiency in a programming language used for data manipulation and pipeline construction (e.g., Python)
Hands-on experience designing and building production-grade data pipelines using orchestration tools
Solid understanding of data warehousing concepts, dimensional modeling (Star/Snowflake schema), and OLAP structures
Experience with at least one major cloud platform and its data services
Preferred
Previous experience working with payment data (e.g., card transactions, ACH, wallets), financial data, or fraud/risk datasets
Experience with real-time or streaming data technologies (e.g., Kafka, Kinesis, Spark Streaming)
Data SLA monitoring and assurance, data storage and computing resource management and optimization
Benefits
Medical, dental, and vision insurance
401(k) savings plan with company match
Paid parental leave
Short-term and long-term disability coverage
Life insurance
Wellbeing benefits
10 paid holidays per year
10 paid sick days per year
17 days of Paid Personal Time (prorated upon hire with increasing accruals by tenure)
Company
TikTok
TikTok is a short-form video entertainment app and social network platform. It is a sub-organization of ByteDance.
10001+ employees
H1B Sponsorship
TikTok has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (979)
2024 (601)
2023 (387)
2022 (322)
2021 (133)
2020 (72)
Funding
Current Stage
Late StageLeadership Team
N Ali Mohamed
CEO
Blake Chandlee
VP Global Business Solutions
Recent News
Company data provided by crunchbase