Welcome to the Bootcamp
Congratulations — you made it into the Data Engineering Internship. Over the next 12 weeks you will go from SQL queries to full end-to-end data pipelines. This handbook is your day-to-day reference. Read it once now, then keep it open.
A Note on How This Program is Structured
This internship is self-paced, and that is intentional.
Stratpoint's active projects are enterprise and high-profile in nature. The confidentiality requirements, client expectations, and production stakes involved mean that placing interns directly on live client work would not be fair to you, your team, or the client. This is not a reflection of your capability — it is simply the reality of how professional-grade projects operate.
What we have built instead is a program that prepares you for exactly that environment. You will work with the same tools, the same standards, and the same workflows used on real projects. More importantly, you will develop the habits that make someone genuinely ready for one.
Beyond the technical skills, this program is designed to build:
- Self-discipline — no one will chase you for your output. You manage your own time and your own progress.
- Independence — you will get stuck. The expectation is that you try first, try hard, and ask for help at the right moment — not immediately, and not never.
- Resourcefulness — the answer is almost always in the documentation, the error message, or a well-formed search. Learning to find it yourself is part of the training.
- Communication and professional conduct — through daily standups, activity presentations, and working alongside co-interns, mentors, and managers, you will practise how professionals collaborate, give feedback, and carry themselves at work.
We want you to leave this program not just with technical skills, but with the working habits and professional confidence to thrive on a real team.
Welcome aboard.
Your Instructors
| Name | Role |
|---|---|
| Jemima Villanueva | Lead Instructor |
| Raymond Laguerta | Instructor |
| Jesse Louise Calasin | Instructor |
What the 12 Weeks Look Like
| Week | Phase | Primary Focus | You Deliver |
|---|---|---|---|
| Day 0 | Setup | Environment configuration | Working local stack |
| 1 | Foundations | Database design, data warehousing, ERD, star schema | ERD + star schema design + presentation |
| 2 | Foundations | Core tools — Python, PySpark, Pandas, PostgreSQL, SQL | End-to-end pipeline: download → load → clean → query |
| 3–5 | Pipelines | ETL vs ELT, dbt transformations, Airflow orchestration | dbt + Airflow ETL pipeline |
| 6–7 | Visualisation | Power BI, DAX, data storytelling, dashboards | Interactive Power BI dashboard |
| 8–12 | Capstone | Integrate all skills on a real analytics problem | Movie analytics system |
What This Bootcamp Will and Will Not Cover
| Covered | Not Covered |
|---|---|
| Relational and non-relational databases | Cloud services (AWS, GCP, Azure) |
| Python, Pandas, PySpark data processing | Production client projects with live business users |
| dbt transformations and data modelling | Real-time streaming infrastructure |
| Airflow orchestration and scheduling | Enterprise-scale deployment |
| Power BI dashboards and DAX | ML model training and deployment |
| Git and GitHub for version control |
Pro Tip
The first week feels like drinking from a firehose. That is normal.
You will not understand everything immediately. Focus on running the commands, then understanding why.
Stuck for more than 30 minutes? Post in the help channel immediately. Do not sit on blockers.