Data Analytics Intern: ETL & BI Focus

Personal Collection Direct Selling Inc.; Quezon City; On-site; PHP 167,000 - 234,000; Full time

Job summary

Personal Collection Direct Selling Inc. is seeking a motivated undergraduate to assist in documenting ETL processes, optimize SQL queries, and support data flow improvements within the BI team. You will work across ETL workflows and collaborate with data engineers to ensure accurate reporting and stable data pipelines.

You will gain hands-on experience in data modeling, database validation, and documentation while collaborating with data engineers and analysts in a team-oriented environment.

Qualifications

• Currently pursuing a Bachelor's degree in a related field.
• Basic knowledge of SQL and relational databases.
• Willingness to learn and work in a team.

Responsibilities

• Review and document existing ETL processes with clear diagrams.
• Collaborate with BI team and Data Engineers to standardize naming conventions and storage locations.
• Analyze, validate, and optimize ETL workflows and SQL queries for performance and reliability.
• Convert fact views into physical database tables to boost reporting speed.
• Perform data validation and integrity checks across ETL processes and database objects.
• Maintain up-to-date technical documentation for ETL workflows and schemas.

Skills

SQL

Relational databases

Data transformation

ETL concepts

Teamwork

Education

Bachelor's degree in Computer Science/IT/IS/Data Science or related field

Job description

Personal Collection Direct Selling Inc. is seeking a motivated undergraduate to assist in documenting ETL processes, optimize SQL queries, and support data flow improvements within the BI team. You will work across ETL workflows and collaborate with data engineers to ensure accurate reporting and stable data pipelines.

You will gain hands-on experience in data modeling, database validation, and documentation while collaborating with data engineers and analysts in a team-oriented environment.