Marketing Database Coordinator

Responsibilities

• 1. Data Entry and Maintenance: Ensures marketing data is accurately entered, maintained, and updated in the CRM (Deltek Vantagepoint) and DAM (OpenAsset). Works proactively to identify missing or outdated information and takes corrective action in alignment with established standards.
• 2. Data Audits and Data Quality Initiatives: Conducts regular data validation checks, de-duplication, and clean-up activities to uphold data accuracy and usability. Helps ensure adherence to firmwide data governance standards while actively addressing data quality issues in real time.
• 3. Frontline User Support: Serves as the first point of contact for questions related to Deltek Vantagepoint, OpenAsset, and marketing data processes. Assists users in navigating the system and resolving common issues. Escalates more complex issues to the Senior Marketing Database Coordinator, IT, or vendor support as needed.
• 4. Liaison Between Marketing and IT: Collaborates with the Senior Marketing Database Coordinator to support communication between Marketing and IT. Tracks user-reported system issues, assists with user acceptance testing for upgrades and enhancements, and helps ensure users are aware of upcoming changes.
• 5. Data Searches and Reports: Runs basic and advanced data searches and produces reports based on requests from Marketing, Business Development, and other stakeholders. Ensures search and report parameters align with firmwide standards and data governance expectations. Prepares and distributes reports as directed.
• 6. Training Delivery and Documentation: Assists in delivering system training for new and existing users. Provides hands-on training support, helps answer questions, tracks follow-up items, and contributes to maintaining user guides, job aids, and process documentation.
• 7. System Process Documentation: Supports the capture and organization of process documentation related to data management, system workflows, and user protocols. Regularly reviews documentation to ensure alignment with current processes and communicates updates to users when necessary.
• 8. Digital Marketing Analytics Support: Supports the collection, validation, and reporting of website and campaign performance data using Google Analytics and other reporting tools. Maintains recurring reports and dashboards, monitors key engagement and conversion metrics, and helps identify trends and data quality issues for Digital Marketing.
• 9. Marketing Automation Platform Support: Supports the implementation, administration, and ongoing use of AEI’s marketing automation platform under the direction of Digital Marketing. Assists with audience segmentation, campaign and automated workflow setup and testing, contact data management, CRM synchronization, and performance reporting.
• 10. Special Projects and Continuous Improvement Efforts: Provides administrative and data-related support for projects involving system enhancements, data migrations, or process improvements. Works under the direction of the Director of Marketing and Senior Marketing Database Coordinator to support broader data governance and technology integration efforts.

Requirements

• Education and prior experience:
• Education: Bachelor’s degree in information management, computer science, marketing, business, or a related analytical field.
• Experience: One to three years of experience in marketing, data management, information technology, or a related business area.
• Technical Skills: Proficiency with Microsoft Office (Word, Excel, PowerPoint, OneNote) and basic knowledge of marketing tools.
• Attention to Detail: Demonstrated attention to detail and accuracy in data management tasks.
• Experience with CRM and DAM systems — particularly Deltek Vantagepoint and OpenAsset — is preferred.
• Preferred Industry Experience: Experience working within a professional services firm, with preference for candidates familiar with marketing processes in the architecture, engineering, and construction (AEC) industry.
• Process Documentation: Experience drafting or maintaining system-related documentation or training materials preferred.

Preferred

• Experience with CRM and DAM systems — particularly Deltek Vantagepoint and OpenAsset — is preferred.
• Experience providing system training, user support, or process documentation is also preferred.
• Preferred Industry Experience: Experience working within a professional services firm, with preference for candidates familiar with marketing processes in the architecture, engineering, and construction (AEC) industry.
• Process Documentation: Experience drafting or maintaining system-related documentation or training materials preferred.

Benefits

• We provide a flexible and collaborative work environment demonstrating our dedication to employee appreciation and collective commitment to excellence.
• We offer a professional culture that encourages professional development and growth.
• We deliver an exceptional benefits package (health, dental, vision) and a year-end bonus based on company profits, individual responsibility, and excellent performance.