Data Warehouse Engineer Intern (Data Platform, Local Services) - 2027 Start

Team Introduction
Our Data Platform Business Partnering team is at the core of Tik Tok Local Services business, responsible for generating a tremendous amount of data and providing access services and applications. We empower many business & engineering teams to analyze and develop innovative strategies and products driving business growth. We are looking for passionate and talented engineers to join us to drive the future of Local Services together.

We are looking for talented individuals to join us for an internship. Our internship program offers students hands-on experience, industry exposure, and opportunities to apply their knowledge to real-world challenges while building a strong foundation for personal and professional growth. Interns will gain practical experience, explore potential career paths, and participate in social events, learning programs, and development workshops alongside industry professionals. Candidates may apply to a maximum of two positions across Our Company and its affiliates globally. Applications will be considered in the order they are submitted. Applications are reviewed on a rolling basis, so we encourage you to apply early. Please clearly state your availability in your resume, including your start and end dates.

Responsibilities:

• Translate business requirements and end-to-end solution designs into technical implementations, and build batch and real-time data warehouses.
• Lead data modeling design, and develop, maintain, and optimize ETL jobs.
• Collaborate with business teams to define and build data metrics based on the data warehouse.
• Build and maintain data products that support business analysis and decision-making.
• Participate in system rollouts, upgrades, implementations, and releases to streamline internal processes and improve operational efficiency.
• Develop and implement analytical techniques and data applications to transform raw data into meaningful insights using data-oriented programming languages and visualization tools.
• Apply data mining, data modeling, natural language processing, and machine learning techniques to extract and analyze information from large-scale structured and unstructured datasets.
• Visualize, interpret, and communicate data findings, including the creation of dynamic reports and dashboards.

Requirements:

• Minimum Qualification(s)

• Currently pursuing an Undergraduate in Computer Science or a related technical discipline.

• Solid understanding of computer science fundamentals, including data structures and algorithms, SQL, and computer networks.

• Strong coding skills with proficiency in at least one programming language, such as C, C++, Java, Python, or Golang.

• Preferred Qualification(s)

• Strong interest in data warehousing, ETL development, data analysis, and Local Services.

• Strong communication skills and the ability to quickly learn new business domains and technical concepts.

• Strong cross-functional collaboration skills, with the ability to build effective working relationships across teams and stakeholders.