Marketing Data Integrity Assistant

Job Description:

The Marketing department is seeking a detail-driven, systems-oriented Marketing Data Integrity Assistant for a targeted 2- to 4-month engagement. This role focuses on conducting a comprehensive audit, cleanup, and restructuring of project records within Teamwork across multiple institutions.

The primary objective is to standardize project architecture and backfill essential metadata required for real-time reporting, executive visibility, and Power BI dashboards. The contractor will also serve as a vital data-governance bridge as internal department team members transition to self-serve project creation.

Key Responsibilities & Deliverables

1. Data Audit & Remediation · Perform an exhaustive audit of active, completed, and legacy project records within Teamwork across all institutional accounts. · Identify, resolve, and update missing metadata, misconfigured project tags, outdated completion statuses, and broken task dependencies. · Ensure naming conventions, milestone formats, and task lists strictly align with departmental operational standards.
2. Executive Dashboard & BI Field Population

• Systematically verify and backfill critical tracking fields, including strategic priority alignments, delivery milestones, resource tags, baseline vs. actual dates, and budget/financial tracking data.
• Ensure data hygiene directly supports downstream reporting structures, specifically integration with Power BI executive dashboard cards and milestone tracking views.

3. Intake Standardization & Governance Support

• Review newly submitted, self-serve projects initiated by internal marketing team members against standardized intake templates.
• Validate custom field compliance, correct misclassifications, and apply necessary governance filters before projects enter active operational workflows.
• Flag structural discrepancies, broken workflows, or data inconsistencies to the Marketing Operations lead.

Core Qualifications & Requirements

• Technical & System Proficiency: Direct, hands-on experience using cloud-based work management and project tracking platforms (experience with Teamwork is strongly preferred; comparable proficiency in Asana, Monday.com, Jira, or ClickUp will be considered).
• Data Hygiene & Auditing Acumen: Demonstrated experience auditing complex, multi-tiered project databases, tracking fields, custom forms, and metadata for business intelligence reporting.
• Analytical Precision: High attention to detail with the ability to spot data inconsistencies, formatting errors, and taxonomy discrepancies across hundreds of active and archived records.
• Business & Marketing Acumen: Basic familiarity with marketing workflows, creative asset development lifecycles, and institutional project structures.
• Autonomy & Organization: Self-directed worker who can manage project milestones against a 2–4 month roadmap with minimal oversight.

Compensation & Benefits This opportunity is budgeted at $$30.00 hourly base compensation. Additional compensation factors may impact total compensation. To learn more about our competitive benefits and additional rewards, including generous paid time-off, medical and dental insurance coverage, life and disability insurance, retirement plan with employer contribution, multiple flexible spending accounts, tuition reimbursement, click the link below. https://www.tcsedsystem.edu/careers/

The Community Solution is an Equal Opportunity Employer.

Application Process Please note the screening, recruitment, and selection process is managed by recruiting staff and hiring managers with the aid of artificial intelligence to evaluate candidates against job requirements. The artificial intelligence tool is a resource only and all employment decisions are made by staff members.

When you apply, it is recommended you utilize the option to parse your resume into the application. To ensure your experience is accurately reflected, please review and complete all application fields - even if you auto-fill from your resume.

For the best results, tailor your resume to the job description, highlight key qualifications and skills, and use clear, consistent formatting. This helps our AI tools read and assess your application more effectively. We are committed to regularly monitoring the process for fairness and remove personally identifiable information during evaluation.