Marketing Project Data Analyst

Skidmore Owings & Merrill•Washington DC, DC

About The Position

At SOM, we are a collective committed to shaping a better future for our clients, communities and planet. We aspire to create the most sustainable, impactful work through creative, interdisciplinary teams with all the resources and diversity of a global firm. We value those who are passionate about excellence, innovation, integrity, inclusivity, and collaboration. Together we can achieve great things. Success at SOM Means Ideas: We believe in a meritocracy of ideas. We look to everyone to actively contribute to the discourse in the firm. Knowledge: We believe that expertise is the result of lifelong learning. We are not expected to know everything, but rather to passionately pursue answers, develop new skills and deepen our knowledge. Product: We strive for excellence in the concept, quality, and delivery of our work. Individual: We value individuals who bring the highest standards of professionalism and personal integrity in the way they work. Each person can develop and contribute their wealth of attributes, skills and knowledge to support the overall health of the firm. Team: We value the power of interdisciplinary integration. A positive team culture in which everyone collaborates openly towards common goals is essential. Firm: We have a history of making transformative contributions to the profession and our communities. We are constantly innovating and attempting to bring new approaches, solutions and processes to our work.

Requirements

Bachelor’s degree in Business, Marketing, Data Analytics, Information Systems or related field
5+ years in professional service environments, preferably the AEC industry
2+ years Salesforce Sales Cloud experience required
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

Nice To Haves

Experience with data visualization and reporting tools - such as Power BI, Tableau, Python or R - a plus
Experience with OpenAsset

Responsibilities

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, prioritize missing information, and improve overall data completeness.
Perform regular data audits and data 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.
Serve as support to 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.
Support the development, maintenance, and delivery of Salesforce training programs for marketing and project management teams.
Support onboarding and refresher training sessions, in collaboration with the Salesforce Administrator, for Salesforce users across the firm.
Partner with stakeholders to identify training needs and develop targeted learning materials for new processes, system enhancements, and data initiatives.
Support change management efforts by communicating system updates, process changes, and best practice to end users.
Monitor user adoption and feedback to improve training content and effectiveness.
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.
Assists with other tasks and responsibilities as may be required, working closely with the Global Marketing Directors.