"Alerted.org

Description

Senior Smartsheet Developer (Remote Contract) Duration: 8–10 Weeks Location: Remote (U.S.-based) Vendor: TEKsystems Global Services Start Date: ASAP Employment Type: Contract (W2 or C2C) Position Overview Key Responsibilities 1. Core Architecture & Data Structure • Design and implement a Centralized Objective/KPI Tracker in Smartsheet as the single source of truth for all Policy & Legal Ops+ objectives and KPIs. • Establish parent/child relationships between KPIs and supporting projects. • Develop standardized tracking assets using Objective/KPI Control Center blueprints. • Build a scalable architecture to support future enhancements (e.g., time tracking, resource management, Microsoft Copilot integration). 2. Project Intake & Management • Configure project intake forms to require KPI linkage before submission. • Automate project creation upon approval, linking new projects to their respective KPIs. • Ensure each dashboard project entry includes a direct link to its detailed project plan. 3. Dashboard & Reporting • Develop a main dashboard view consolidating all L2 (Darth Vaughn) Objectives/KPIs. • Implement a nested project view under each KPI. • Enable automated status roll-up from child projects to parent KPIs. • Create executive-ready visuals with real-time data updates. • Incorporate comprehensive filtering by KPI, objective, status, and organizational level. • Display key metrics such as % complete, milestone progress, and R/Y/G status indicators. 4. Automation & Workflow • Configure automated KPI updates based on milestone completion. • Leverage Smartsheet automation to minimize manual data entry and reduce administrative burden. 5. User Access & Experience • Use Smartsheet WorkApps to create role-based views for leadership, legal ops, and project owners. • Configure Dynamic View for secure, tailored stakeholder access. 6. Vendor Engagement, Training & Support • Conduct weekly stakeholder check-ins to review progress, demonstrate work, and align on next steps. • Provide change management support, including communication templates and adoption strategies • Execute a formal solution hand-off, including final demonstration and verification. • Provide comprehensive documentation, including: - Data dictionary - System architecture diagrams - Administrative and user guides • Offer post-deployment support for a minimum of four weeks to address bugs and assist with minor adjustments. Required Qualifications • Proven experience designing and implementing Smartsheet Control Center solutions. • Expertise in Smartsheet automation, WorkApps, and Dynamic View. • Strong understanding of project management principles and KPI tracking. • Experience integrating Smartsheet with enterprise systems. • Excellent communication and stakeholder engagement skills. • Ability to deliver executive-level dashboards and visual reporting. • Familiarity with change management and training program development. Preferred Qualifications • Experience working with automotive or legal operations teams. • Knowledge of Microsoft Copilot and its integration potential.

Additional Skills & Qualifications

. This 8–10 week remote contract role will focus on restructuring project tracking by aligning initiatives with strategic objectives and Key Performance Indicators (KPIs), while significantly reducing administrative overhead through automation and integration. Key Responsibilities 1. Core Architecture & Data Structure • Design and implement a Centralized Objective/KPI Tracker in Smartsheet as the single source of truth for all Policy & Legal Ops+ objectives and KPIs. • Establish parent/child relationships between KPIs and supporting projects. • Develop standardized tracking assets using Objective/KPI Control Center blueprints. • Build a scalable architecture to support future enhancements (e.g., time tracking, resource management, Microsoft Copilot integration). 2. Project Intake & Management • Configure project intake forms to require KPI linkage before submission. • Automate project creation upon approval, linking new projects to their respective KPIs. • Ensure each dashboard project entry includes a direct link to its detailed project plan. 3. Dashboard & Reporting • Develop a main dashboard view consolidating all L2 (Darth Vaughn) Objectives/KPIs. • Implement a nested project view under each KPI. • Enable automated status roll-up from child projects to parent KPIs. • Create executive-ready visuals with real-time data updates. • Incorporate comprehensive filtering by KPI, objective, status, and organizational level. • Display key

Experience Level

Expert Level

Pay and Benefits

The pay range for this position is $75.00 - $75.00/hr.

Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:

• Medical, dental & vision • Critical Illness, Accident, and Hospital • 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available • Life Insurance (Voluntary Life & AD&D for the employee and dependents) • Short and long-term disability • Health Spending Account (HSA) • Transportation benefits • Employee Assistance Program • Time Off/Leave (PTO, Vacation or Sick Leave)

Workplace Type

This is a fully remote position.

Application Deadline

This position is anticipated to close on Oct 31, 2025.

h4>About TEKsystems:

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

About TEKsystems and TEKsystems Global Services

We’re a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We’re a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We’re strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We’re building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.