At New York City Public Schools I developed scalable Looker Studio dashboards to clean and standardize inconsistent Google Analytics data, enabling recruitment teams to access reliable insights. Previously, fragmented reporting slowed analysis and limited visibility into marketing performance. By automating and streamlining the process I provided leadership and recruitment teams with accurate data that directly supported teacher recruitment efforts tied to the class‑size‑reduction initiative. I also designed and launched a UTM‑standardization tool that improved data accuracy across marketing channels and reduced manual quality checks. These solutions delivered reliable insights, improved efficiency, strengthened campaign management, and helped the organization allocate resources more effectively.

I applied strategic and analytical frameworks from Columbia’s MBA core. Courses in strategy and decision modeling taught me how to structure data for actionable insight, rather than abstract reporting, and how to connect analytics to organizational goals. An Education Leadership course gave me contextual knowledge about the complexities of the New York City school system and the challenges of teacher recruitment, which informed my analysis and problem‑solving. Python for MBAs provided the technical skills to work with large datasets, analyze data, and design dashboards. Together, these tools enabled me to deliver a solution that combined analytical rigor with sector understanding.

A key challenge was inheriting a data structure I had not helped design. Because I joined after the initial tagging and setup, I needed to quickly understand the logic behind earlier decisions and evaluate whether they still met the project’s objectives. This required learning the context of the data, assessing its quality, and deciding whether to adapt the framework or rebuild it. Working independently meant taking full responsibility for those choices. Another challenge was cleaning, categorizing, and visualizing data in a way that told a compelling story without oversimplifying. These obstacles taught me to be adaptable, to take ownership of inherited work, and to make strategic decisions with imperfect information.

My internship underscored the importance of data‑driven decision‑making in public education. Improving teacher recruitment efforts through more accurate analytics revealed how evidence‑based strategies can support broader organizational goals and ultimately strengthen opportunities for students. I learned that projects bringing together data, people, and planning can have a significant community impact. Going forward, I am eager to apply these insights to other initiatives at the intersection of education and analytics.