Overview
On Site
USD 118,657.00 - 259,200.00 per year
Full Time
Skills
Acquisition
Foreign Exchange
Accounting
Customer Experience
Decision-making
Financial Reporting
Partnership
Remote Desktop Services
Amazon RDS
IBM WebSphere MQ
Data Lake
Data Quality
Performance Tuning
Data Flow
Collaboration
Dashboard
Documentation
Extract
Transform
Load
ELT
Computer Science
Statistics
Data Engineering
Analytical Skill
Business Intelligence
SQL
Data Manipulation
Python
Orchestration
Data Modeling
Data Warehouse
Dimensional Modeling
Snow Flake Schema
OLAP
Cloud Computing
ACH
Finance
Fraud
Real-time
Apache Kafka
Amazon Kinesis
Apache Spark
Streaming
SLA
Data Storage
Resource Management
Optimization
Authorization
Immigration
Insurance
Life Insurance
LOS
Management
Information Technology
Video
Data Security
SAFE
FOCUS
Privacy
Recruiting
Job Details
Responsibilities
About the Team: The Global Payment team of U.S. Data Security department of TikTok provides payment solutions - including payment acquisitions, disbursements, transaction monitoring, payment method management, foreign exchange conversion, accounting, reconciliations, and so on - to ensure that users have a smooth and secure payment experience on TikTok platform. The Payment Data Intelligence team is responsible for providing data driven intelligence to empower payment business growth, optimize payment processes and improve customer experience. We're looking for a highly skilled and motivated Data Analytical Engineer to join our team. The ideal candidate will be responsible for designing, building, and maintaining the scalable data infrastructure and ETL/ELT pipelines necessary to transform complex raw payment data into reliable, high-quality, and actionable datasets. This role is critical in driving strategic decision-making and optimizing our payment operations, fraud detection, and financial reporting. In order to enhance collaboration and cross-functional partnerships, among other things, at this time, our organization follows a hybrid work schedule that requires employees to work in the office 3 days a week, or as directed by their manager/department. We regularly review our hybrid work model, and the specific requirements may change at any time. 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.
Qualifications
Minimum Qualifications: - Education: Bachelor's or Master's degree in Computer Science, Engineering, Statistics, or a related quantitative field. - Experience: 3+ years of professional experience in Data Engineering, Analytical Engineering, BI Engineering, or similar role. - SQL Expertise: Expert-level knowledge of SQL and deep experience working with large, complex datasets in a cloud-based data warehouse. - Programming: Strong proficiency in a programming language used for data manipulation and pipeline construction (e.g., Python). - Data Pipelining: Hands-on experience designing and building production-grade data pipelines using orchestration tools. - Data Modeling: Solid understanding of data warehousing concepts, dimensional modeling (Star/Snowflake schema), and OLAP structures. - Cloud Platforms: Experience with at least one major cloud platform and its data services. Preferred Qualifications: - Domain Knowledge: Previous experience working with payment data (e.g., card transactions, ACH, wallets), financial data, or fraud/risk datasets. - Streaming Experience: Experience with real-time or streaming data technologies (e.g., Kafka, Kinesis, Spark Streaming). - Data Ops: Data SLA monitoring and assurance, data storage and computing resource management and optimization. As a condition of employment, all successful candidates must be able to establish authorization to work in the United States. For this position, the Company does not provide sponsorship or any immigration-related benefit.
Job Information
[For Pay Transparency]Compensation Description (Annually)
The base salary range for this position in the selected city is $118657 - $259200 annually.
Compensation may vary outside of this range depending on a number of factors, including a candidate's qualifications, skills, competencies and experience, and location. Base pay is one part of the Total Package that is provided to compensate and recognize employees for their work, and this role may be eligible for additional discretionary bonuses/incentives, and restricted stock units.
Benefits may vary depending on the nature of employment and the country work location. Employees have day one access to medical, dental, and vision insurance, a 401(k) savings plan with company match, paid parental leave, short-term and long-term disability coverage, life insurance, wellbeing benefits, among others. Employees also receive 10 paid holidays per year, 10 paid sick days per year and 17 days of Paid Personal Time (prorated upon hire with increasing accruals by tenure).
The Company reserves the right to modify or change these benefits programs at any time, with or without notice.
For Los Angeles County (unincorporated) Candidates:
Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state, and local laws including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Our company believes that criminal history may have a direct, adverse and negative relationship on the following job duties, potentially resulting in the withdrawal of the conditional offer of employment:
1. Interacting and occasionally having unsupervised contact with internal/external clients and/or colleagues;
2. Appropriately handling and managing confidential information including proprietary and trade secret information and access to information technology systems; and
3. Exercising sound judgment.
About USDS
TikTok is the leading destination for short-form mobile video. Our mission is to inspire creativity and bring joy. U.S. Data Security ("USDS") is a subsidiary of TikTok in the U.S. This new, security-first division was created to bring heightened focus and governance to our data protection policies and content assurance protocols to keep U.S. users safe. Our focus is on providing oversight and protection of the TikTok platform and U.S. user data, so millions of Americans can continue turning to TikTok to learn something new, earn a living, express themselves creatively, or be entertained. The teams within USDS that deliver on this commitment daily span across Trust & Safety, Security & Privacy, Engineering, User & Product Ops, Corporate Functions and more.
Why Join Us
Inspiring creativity is at the core of TikTok's mission. Our innovative product is built to help people authentically express themselves, discover and connect - and our global, diverse teams make that possible. Together, we create value for our communities, inspire creativity and bring joy - a mission we work towards every day.
We strive to do great things with great people. We lead with curiosity, humility, and a desire to make impact in a rapidly growing tech company. Every challenge is an opportunity to learn and innovate as one team. We're resilient and embrace challenges as they come. By constantly iterating and fostering an "Always Day 1" mindset, we achieve meaningful breakthroughs for ourselves, our company, and our users. When we create and grow together, the possibilities are limitless. Join us.
Diversity & Inclusion
TikTok is committed to creating an inclusive space where employees are valued for their skills, experiences, and unique perspectives. Our platform connects people from across the globe and so does our workplace. At TikTok, our mission is to inspire creativity and bring joy. To achieve that goal, we are committed to celebrating our diverse voices and to creating an environment that reflects the many communities we reach. We are passionate about this and hope you are too.
USDS Reasonable Accommodation
USDS is committed to providing reasonable accommodations in our recruitment processes for candidates with disabilities, pregnancy, sincerely held religious beliefs or other reasons protected by applicable laws. If you need assistance or a reasonable accommodation, please reach out to us at
About the Team: The Global Payment team of U.S. Data Security department of TikTok provides payment solutions - including payment acquisitions, disbursements, transaction monitoring, payment method management, foreign exchange conversion, accounting, reconciliations, and so on - to ensure that users have a smooth and secure payment experience on TikTok platform. The Payment Data Intelligence team is responsible for providing data driven intelligence to empower payment business growth, optimize payment processes and improve customer experience. We're looking for a highly skilled and motivated Data Analytical Engineer to join our team. The ideal candidate will be responsible for designing, building, and maintaining the scalable data infrastructure and ETL/ELT pipelines necessary to transform complex raw payment data into reliable, high-quality, and actionable datasets. This role is critical in driving strategic decision-making and optimizing our payment operations, fraud detection, and financial reporting. In order to enhance collaboration and cross-functional partnerships, among other things, at this time, our organization follows a hybrid work schedule that requires employees to work in the office 3 days a week, or as directed by their manager/department. We regularly review our hybrid work model, and the specific requirements may change at any time. 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.
Qualifications
Minimum Qualifications: - Education: Bachelor's or Master's degree in Computer Science, Engineering, Statistics, or a related quantitative field. - Experience: 3+ years of professional experience in Data Engineering, Analytical Engineering, BI Engineering, or similar role. - SQL Expertise: Expert-level knowledge of SQL and deep experience working with large, complex datasets in a cloud-based data warehouse. - Programming: Strong proficiency in a programming language used for data manipulation and pipeline construction (e.g., Python). - Data Pipelining: Hands-on experience designing and building production-grade data pipelines using orchestration tools. - Data Modeling: Solid understanding of data warehousing concepts, dimensional modeling (Star/Snowflake schema), and OLAP structures. - Cloud Platforms: Experience with at least one major cloud platform and its data services. Preferred Qualifications: - Domain Knowledge: Previous experience working with payment data (e.g., card transactions, ACH, wallets), financial data, or fraud/risk datasets. - Streaming Experience: Experience with real-time or streaming data technologies (e.g., Kafka, Kinesis, Spark Streaming). - Data Ops: Data SLA monitoring and assurance, data storage and computing resource management and optimization. As a condition of employment, all successful candidates must be able to establish authorization to work in the United States. For this position, the Company does not provide sponsorship or any immigration-related benefit.
Job Information
[For Pay Transparency]Compensation Description (Annually)
The base salary range for this position in the selected city is $118657 - $259200 annually.
Compensation may vary outside of this range depending on a number of factors, including a candidate's qualifications, skills, competencies and experience, and location. Base pay is one part of the Total Package that is provided to compensate and recognize employees for their work, and this role may be eligible for additional discretionary bonuses/incentives, and restricted stock units.
Benefits may vary depending on the nature of employment and the country work location. Employees have day one access to medical, dental, and vision insurance, a 401(k) savings plan with company match, paid parental leave, short-term and long-term disability coverage, life insurance, wellbeing benefits, among others. Employees also receive 10 paid holidays per year, 10 paid sick days per year and 17 days of Paid Personal Time (prorated upon hire with increasing accruals by tenure).
The Company reserves the right to modify or change these benefits programs at any time, with or without notice.
For Los Angeles County (unincorporated) Candidates:
Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state, and local laws including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Our company believes that criminal history may have a direct, adverse and negative relationship on the following job duties, potentially resulting in the withdrawal of the conditional offer of employment:
1. Interacting and occasionally having unsupervised contact with internal/external clients and/or colleagues;
2. Appropriately handling and managing confidential information including proprietary and trade secret information and access to information technology systems; and
3. Exercising sound judgment.
About USDS
TikTok is the leading destination for short-form mobile video. Our mission is to inspire creativity and bring joy. U.S. Data Security ("USDS") is a subsidiary of TikTok in the U.S. This new, security-first division was created to bring heightened focus and governance to our data protection policies and content assurance protocols to keep U.S. users safe. Our focus is on providing oversight and protection of the TikTok platform and U.S. user data, so millions of Americans can continue turning to TikTok to learn something new, earn a living, express themselves creatively, or be entertained. The teams within USDS that deliver on this commitment daily span across Trust & Safety, Security & Privacy, Engineering, User & Product Ops, Corporate Functions and more.
Why Join Us
Inspiring creativity is at the core of TikTok's mission. Our innovative product is built to help people authentically express themselves, discover and connect - and our global, diverse teams make that possible. Together, we create value for our communities, inspire creativity and bring joy - a mission we work towards every day.
We strive to do great things with great people. We lead with curiosity, humility, and a desire to make impact in a rapidly growing tech company. Every challenge is an opportunity to learn and innovate as one team. We're resilient and embrace challenges as they come. By constantly iterating and fostering an "Always Day 1" mindset, we achieve meaningful breakthroughs for ourselves, our company, and our users. When we create and grow together, the possibilities are limitless. Join us.
Diversity & Inclusion
TikTok is committed to creating an inclusive space where employees are valued for their skills, experiences, and unique perspectives. Our platform connects people from across the globe and so does our workplace. At TikTok, our mission is to inspire creativity and bring joy. To achieve that goal, we are committed to celebrating our diverse voices and to creating an environment that reflects the many communities we reach. We are passionate about this and hope you are too.
USDS Reasonable Accommodation
USDS is committed to providing reasonable accommodations in our recruitment processes for candidates with disabilities, pregnancy, sincerely held religious beliefs or other reasons protected by applicable laws. If you need assistance or a reasonable accommodation, please reach out to us at
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.