Project Manager Irving, TX

Retail Technology Project Manager, Google Workspace Migration Direct Client

Location:

Irving , TX United States Hybrid: 3 Days onsite 2 days Remote

Contract:

3 Months ( with possible extension) Job Summary

Job Description:

We are seeking a highly motivated and experienced Project Manager to lead the migration of our existing Retail Technology project intake and reporting process from Smartsheet to Google Workspace. This role will be instrumental in streamlining user experience, automating reporting, enhancing efficiency, and optimizing operational costs.

• Project Planning & Discovery:
• Define project scope and requirements by reviewing existing Smartsheet processes, documenting workflows, and identifying data fields for migration.
• Identify and communicate with all stakeholders, including requestors, approvers, assigned parties, managers, and dashboard users.
• Confirm tool selection (Google Forms, Google Sheets, Google Apps Script/Add-ons, Looker Studio/Qlik).
• Develop a data migration strategy for historical Smartsheet data.
• Create a detailed project schedule with milestones, deadlines, and assigned roles and responsibilities.
• Design & Development:
• Set up Google Forms for intake, ensuring all necessary fields are included and linked to a master Google Sheet.
• Configure the master Google Sheet for optimal data entry, readability, and status tracking.
• Develop automation using Google Apps Script or a suitable Add-on for email notifications, assigned party identification, and deadline checks.
• Integrate scoping details, either through direct editing in the master sheet or via a secondary Google Form.
• Create user-specific views using Filter Views or advanced Apps Script/separate sheets.
• Develop dashboards in Looker Studio or Qlik, connecting to the master Google Sheet and designing key performance indicators (KPIs) and visualizations.
• Testing & Refinement:
• Conduct comprehensive internal testing of the entire workflow, including form submissions, email notifications, and user-specific filtering.
• Coordinate User Acceptance Testing (UAT) with a select group of end-users, gather feedback, and address findings.
• Create detailed user guides and administrator guides for all components of the new system.
• Implement necessary refinements based on testing feedback and optimize performance.
• Deployment & Go-Live:
• Execute historical data migration from Smartsheet to Google Sheets.
• Create a Google Microsite for form access and stakeholder training.
• Communicate the go-live date to all stakeholders and provide access to the new system.
• Conduct training sessions for users as needed.
• Plan and execute the phased decommissioning of the Smartsheet process.
• Training, Adoption & Post-Launch Support:
• Develop and implement a comprehensive training plan for different user groups using various formats (live sessions, video tutorials, written guides).
• Actively monitor the system for issues and establish a support channel for user questions.
• Gather initial user feedback and conduct performance reviews against initial requirements.
• Plan for future enhancements and iterations based on user feedback and evolving business needs.

• Proven experience in managing technology migration projects, preferably from Smartsheet to Google Workspace.
• Strong proficiency with Google Workspace applications, including Google Forms, Google Sheets, Google Apps Script, and Looker Studio.
• Experience with data migration strategies and data cleansing.
• Excellent communication, interpersonal, and stakeholder management skills.
• Ability to develop and deliver effective training materials.
• Strong problem-solving and analytical skills.
• Ability to work independently and as part of a team in a fast-paced environment.