Sql data analyst Jobs in Fontana, CA

Data Analyst Graduate (Supply Chain and Logistics- Fulfillment Centers Operations) - 2027 Start

Location: Fontana

Employment Type: Regular

Job Code: A17691A

Responsibilities

Team Overview TikTok Shop's Supply Chain & Logistics' mission is to improve delivery experience while minimizing costs from Fulfillment by TikTok (FBT) via seamless integrated FBT product solution and operation. We are looking for talented individuals to join our team. As a graduate, you will get opportunities to pursue bold ideas, tackle complex challenges, and unlock limitless growth. Successful candidates must be able to commit to an onboarding date by the end of the year. Please state your availability and graduation date clearly in your resume. Candidates can apply to a maximum of two positions and will be considered for jobs in the order you apply. The application limit is applicable to TikTok and its affiliates' jobs globally. Applications will be reviewed on a rolling basis. We encourage you to apply as early as possible.

- Build and optimize an hourly-level monitoring system for 3PL production performance, enabling real-time visibility of operational progress and rapid identification of risks and bottlenecks across FCs.

- Develop data-driven quality monitoring frameworks (e.g., Missing, Damage, Wrong orders), perform root cause analysis, and drive continuous improvement to enhance customer experience.

- Leverage historical data to identify network-level risks and develop readiness plans for peak seasons (e.g., BFCM), ensuring SLA achievement.

- Participate in SOP design for new processes and system launches, ensuring alignment with operational capabilities across FCs.

- Support the development of the Control Tower system by designing proactive alert mechanisms across capacity, quality, and SLA dimensions.

- Provide daily/weekly reporting and data insights for regional operations, including daily standups and exception reporting.

Qualifications

Minimum Qualifications - Individuals who are completing or have recently completed a Bachelor's degree in Business, Logistics, Operations, Engineering or a related discipline - Strong data analysis skills (SQL, Python), with experience in BI tools

Preferred Qualifications - Experience in e-commerce fulfillment or warehouse management - Familiar with WMS systems and warehouse workflows

Compensation and Benefits

The base salary range for this position in the selected city is $70304 - $115200 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 TikTok

TikTok is the leading destination for short-form mobile video. At TikTok, our mission is to inspire creativity and bring joy. TikTok's global headquarters are in Los Angeles and Singapore, and we also have offices in New York City, London, Dublin, Paris, Berlin, Dubai, Jakarta, Seoul, and Tokyo.

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.