Data Analytics Intern

Personal Collection Direct Selling Inc. is one of the leading direct-selling businesses in the Philippines, providing quality and affordable products that improve everyday living for every Filipino. For more than 20 years, we’ve empowered entrepreneurs, employees, and dealers to grow with purpose. At PC, together, we make lives and careers great.

What you'll do:

• Review and document existing ETL processes by developing clear, accurate, and comprehensive process flow diagrams.
• Collaborate with the Business Intelligence (BI) Team and Data Engineers to standardize naming conventions and organize the storage locations of existing database tables.
• Analyze, validate, and optimize ETL workflows and SQL queries to improve data processing performance, efficiency, and reliability.
• Convert fact views into physical database tables to enhance reporting performance and support efficient data retrieval.
• Perform data validation and integrity checks to ensure consistency, accuracy, and reliability across ETL processes and database objects.
• Maintain up-to-date technical documentation for ETL workflows, database schemas, process improvements, and implementation changes.

What makes you great a fit:

• Currently pursuing a Bachelor's degree in Computer Science, Information Technology, Information Systems, Data Science, or a related field
• Basic knowledge of SQL and relational databases
• Understanding of data structures, data transformation, and ETL concepts is an advantage. -Familiarity with data visualization or business intelligence tools.
• Willingness to learn new technologies and work in a team environment.