Data management intern
Job function (e.g., overall role, assigned tasks)
- Data management intern
- Internship working on a team performing a major salesforce migration project for 50K+ account relationships for non-profit media organization.
- The goal of the internship was to work on a team assisting in the migration project, establishing relationships between data points.
- Create high level presentations for upper-level management.
- Create documentation for training purposes on how to manipulate and add data.
Examples of projects (e.g., list the projects you worked on and what you accomplished):
- The transition I took part on performing was from a software called BEAT, a multimedia marketing platform, using SQL for data manipulation and hierarchal mapping, and utilized tableau for data visualization.
- I performed high-level hierarchical data mapping using 5+ sources and consulted with team on backend data storage, storage configuration, access controls, and briefed a variety of different teams on how to access, manipulate and upload data.
- Collaborated with development team to oversee quality assurance, UAT and migration to final production.
- Reported to VP of Digital Marketing weekly with findings, gave presentation to executives with results of data merge following the completion of the project.
- This was during the summer of 2023; I was doing this internship while completing a summer I semester.
What you learned and how it relates to your major (e.g., describe what you learned from this experience in the context of specific courses)
- As a personal anecdote, it was a fantastic opportunity to utilize the skills learned in my SQL class, as well as statistics class to complete a large project for such a prestigious company. It was interesting to see which of those skills were found valuable by executive and upper management, and how hard it was to explain data management to the non-data-centric teams.
- I utilized my MIS courses to create databases in excel as well, using macros to make things easier and provide a smoother transition process when combing through and scrubbing these large sets of data.
- I truly appreciate the opportunity that I was given at the Ad council, and it forced me to work as a team and collaborate more than ever before. Typically, in my courses, this is something I have struggled with, although in this situation I had to rely on those around me, and others’ input. It was a wonderful experience.