Marketing Project Data Analyst

Position Overview

This role combines hands‑on data management, Salesforce support, user training, reporting and process improvement. The analyst will play a key role in ensuring Project and Pursuit data is accurate, complete, and actionable across the firm.

• Data Quality, Analysis and Research
  • Own the quality, accuracy, and completeness of Pursuit and Project data within Salesforce.
  • Research, collect, validate, and enter Project, Pursuit, and Client data into Salesforce.
  • Partner with marketing and project management teams to identify data gaps and prioritize missing information.
  • Perform regular data audits and quality reviews, implementing processes and standards that improve long‑term data quality.
  • Develop dashboards, reports, and visualizations to track data quality.
  • Automate recurring reporting processes to improve efficiency and accuracy.
  • Conduct ad‑hoc analysis to support leadership and regional marketing teams.
• Salesforce Administration
  • Support the Salesforce Administrator in maintaining CRM data integrity, governance standards, and best practices.
  • Support marketing and project management Salesforce users and the Salesforce Action Team.
  • Participate in testing new Salesforce functionality, enhancements, automations, and integrations in sandbox environments.
  • Troubleshoot system issues and provide user support.
  • Collaborate with stakeholders to improve Salesforce usability and adoption.
• Training & User Enablement
  • Support the development, maintenance, and delivery of Salesforce training programs for marketing and project management teams.
  • Support onboarding and refresher training sessions with the Salesforce Administrator.
  • Partner with stakeholders to identify training needs and develop targeted learning materials.
  • Support change management efforts by communicating system updates, process changes, and best practices to end users.
  • Monitor user adoption and feedback to improve training content and effectiveness.
• A/E Industry & Business Process Support
  • Assist marketing, project managers and other end users in updating the system and reporting as necessary.
  • Support proposal and pursuit tracking, including opportunity lifecycle management.
  • Assist in standardizing data across regions and offices.
  • Coordinate and support the Firm's data initiatives through the completion of processes as outlined by marketing leadership.

• Bachelor’s degree in Business, Marketing, Data Analytics, Information Systems or a related field.
• 5+ years in professional service environments, preferably the AEC industry.
• 2+ years Salesforce Sales Cloud experience.
• Experience with data visualization and reporting tools such as Power BI, Tableau, Python or R (a plus).
• Experience with Open Asset.
• Robust analytical, problem‑solving and communication skills.
• Strong relationship‑building skills across all levels.
• Analytical mindset with strong attention to detail.
• Self‑starter with ability to manage multiple priorities.

Are you ready to join a team of creative professionals working on transformational projects around the world?

Compensation for this role is based upon experience, qualifications, location, and education and typically ranges from $70,000 to $95,000.

SOM is proud to be an equal opportunity and affirmative action employer, and we have been recognized with the highest ranking awarded on the Human Rights Campaign Foundation’s Corporate Equality Index. We publish an annual Impact Report as part of our ongoing commitment to advancing equity in our practice and the profession.