Project Title: Enhancing Placement Funnel through Data Integration

Mitchell Martin

Details
Project Title Enhancing Placement Funnel through Data Integration
Project Topics Artificial Intelligence & Machine Learning Data Management Information Technology (IT) Innovation Operations
Skills & Expertise Data Collection Engineering Analysis Python Statistics
Project Synopsis: Challenge/Opportunity
Mitchell Martin, a leader in the professional services industry, excels in connecting talent with opportunities, leveraging robust marketing strategies and operational efficiency. However, a critical challenge they currently face is the lack of integration between their Marketing and Productivity tools, leading to fragmented data that hampers their Placement Funnel's efficiency. This disconnection means that valuable insights remain untapped, which can result in missed placements and reduced overall effectiveness of their recruitment strategies.

The corporate partner is Anthony Giardina. He is an established change agent, successful in leading organizations through strategic development, program management and technical delivery to drive and adapt to change.
Project Synopsis: Activities/Actions Required
Key activities for this project will include, but are not limited to:

1. Data collection from existing ATS, Marketing and Productivity tools, leveraging Python, Snowflake, Dagster, & DBT.

2. Utilize data-cleaning methodologies to ensure accuracy and completeness, followed by exploratory data analysis to identify trends and patterns. 

3. Create visual dashboards with Power BI to present findings and recommendations effectively.

Deliverables will include a functional data pipeline including data gathering, storage, transformation, analysis, integrity and visualization. 
Project Synopsis: Expected Results
The expected outcomes of this project includes a functional data pipeline including data gathering, storage, transformation, analysis, integrity and visualization. 

  • Students will achieve SMART goals such as capturing 100% of marketing data, and reconciles ATS & productivity data, delivering a visual that meets professional standards, and enhancing their teamwork and communication skills through collaborative efforts.
  • From a business perspective, Mitchell Martin will receive actionable insights that can lead to improved operational efficiency and a more effective Placement Funnel, ultimately resulting in increased placements and satisfied clients.

Project Timeline

Touchpoints & Assignments Date Type

Getting Started: Complete Your Student Onboarding Form

Aug 27 2025, 17:00 PM EST (UTC-05:00) Action Item

Welcome to the Fall 2025 Industry Capstone Program!

Sep 02 2025 Project Milestone

Academic Calendar

Sep 02 2025 Other

Fall 2025 Midterm Student Self Reflection

Nov 07 2025, 23:59 PM EST (UTC-05:00) Evaluation

Fall 2025 Midterm Presentation

Nov 07 2025, 23:59 PM EST (UTC-05:00) Project Milestone

Fall 2025 Final Presentation

Dec 19 2025, 23:59 PM EST (UTC-05:00) Project Milestone

Fall 2025 Final Self Reflection

Dec 19 2025, 23:59 PM EST (UTC-05:00) Evaluation

Program Managers

Name Organization