Business Intelligence Coordinator
- Information about the organization (e.g., type, size, location, specific division/department in which you will be employed)
Yoh, A Day & Zimmermann Co. was founded in Philadelphia as Duncan Tool Design by Harold L. Yoh in the 1940s. The company started out staffing for war production and training only to expand their customer base to include Lockheed, DuPont, General Electric, McDonnell Douglas, IBM and Western Electric before the 1950s. Mr. Yoh merged his company with Day & Zimmermann to form one of the largest technical service organizations to date. Yoh has surpassed over $500 Million in Revenue with many acquisitions just in the last decade. In recent years, Yoh has won several Staffing Awards.
Yoh is headquartered in Philadelphia, PA – with more than 75 locations nationally. I will be working in the Business Intelligence department as a Business Intelligence Coordinator.
- Job function (e.g., overall role, assigned tasks)
- Act as SAP C4C and InsightSquared administrator; adding, removing, editing existing users, clients and data-reporting dashboards.
- Perform regular data verification checks to ensure ATS data is flowing into our platform in a timely and accurate manner.
- Identify, implement and improve current processes within the organization to continue to increase revenue though data accuracy.
- Presented an idea to better utilize our Sales Intelligence System; worked with support to generate a non- production test environment to begin testing user restriction by setting up an internal organizational hierarchy.
- Coordinate with PMO teams to extract VMS data, manipulate and put into QBR PowerPoint presentations for MSP Clients.
- Assisted in collecting ATS user ideas and rates of those ideas to enhance and centralize the use of our ATS system; making it a more universally valuable tool to our organization.
- How the job relates to your major (describe how you will apply course work to the job or which course(s) helped you get this job).
This position directly correlates with my major due to the extensive and intense use of mass databases warehouses, ATS, CRMs, and other data reporting tools that I have learned about and exercised during my MIS courses. I have been able to use the visualization tools I developed in Data Analytics to tell a better story with the data I export to present to leadership. My job requires me to better processes, ensure data accuracy and coordinate with other departments to validate information. I am able to understand the flow of data in order to catch an error, or point out a more cost effective and time efficient way of performing the task.
Business Intelligence Internship
Job function (e.g., overall role, assigned tasks)
- Sales automation – clean-up and reporting from our CRM system. We use SAP Hybrid Cloud for Customer.
- Regular Reporting – run and format reports from multiple systems including Cloud for Customer, IQNavigator, SAP, Fieldglass, Bullhorn, etc. for distribution to customers and internal departments to help manage their business.
- Surveying Process – Pull reports from the system for analysis and inclusion in customer reviews
- Data Handling – pull data from Bullhorn and other applications. Assist with business review process.
- Sales Support – Provide industry insights including sales research on customers as well as rate analysis in support of proposal and customer requests.
Examples of projects (e.g., list the projects you worked on and what you accomplished)
- Harris ATS-VMS API configuration – Create a single spreadsheet with unique identifiers that will identify a candidate, job, company, and placement for data merge.
- Maxsys – Working with Bullhorn engineers to delete duplicate profiles within the ATS after a business acquisition.
- QBR – Export, manipulate and present quarterly data for MSP clients that our PMO teams present. Spend, contractor headcount, supplier scorecards, and term reports are key elements in the metrics of the QBR.
- Matador – Collect data from our current Bullhorn users and compile them for leadership to review and decide what changes to make to our ATS system. The purpose is to optimize Bullhorn to drive business success.
- IS2 access Sandbox – Heading my own project working with InsightSquared Engineers to create a sandbox test environment in IS2, connected to our production Bullhorn, in order to build test dashboards and Access Groups that would limit what our team leads see and edit. This is to build a hierarchy within IS2 that somewhat mirrors our financial profit center hierarchy.
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)
- Not only have I developed great professional skills in my time in an office, but the different data warehouses that are spoken about in my MIS courses drive the BI team. The team lived in C4C, Bullhorn, Fieldglass and InsightSquared. Our sales teams reported in SAP C4C, where I would export data daily and upload into our data visualization tool, IS2. Our recruiters and salespersons in specialty used our Bullhorn ATS to track our applicants, there companies and placements. And Fieldglass was for our program managers, and that data was extracted for our Quarterly Business Reviews. Although I know of many other uses for these systems, I really got a close look at our front line business; our sales persons. While one road of MIS can take you down the SQL park, I enjoyed the data reporting and analysis part. Looking at the data, pivoting it out in Excel, finding mistakes and even offering my ideas of how to make the process better was my favorite part. My time in MIS data analytics really prepared me for this internship and this internship therefore prepared me for my classes to come.