Job Summary
Here at Prosites, the Revenue Operations Analyst works closely to provide reporting and analytics support to all stakeholders on the Go-To Market team. This position plays a crucial role in providing data visualization, client analysis, internal auditing, and driving access to data. Further, this individual will be a champion of using data proactively to drive growth, and as such will also be a key member of ensuring data hygiene. To accomplish this, a successful hire will demonstrate high levels of professionalism, accuracy, curiosity, competency, and communication skills.
The ideal candidate has experience owning data visualization systems, specifically PowerBI, and is highly proficient with Salesforce. They also have a proven history of managing a database for field completion and data accuracy, and some experience in sourcing missing information when necessary. This candidate is extremely skilled with Excel; knowledge of connecting the workbook to Salesforce via Power Query and manipulating object data without pivot tables are examples of regular work activities. Has moderate familiarity with the digital marketing industry (understands what SEO is, how it works on a high level, and why companies do it).
Essential Duties and Responsibilities:
-
Work directly with stakeholders to understand and drive their analytical needs, including identifying critical KPIs, and deliver actionable insights to relevant decision-makers.
-
Proactively analyze data to answer key questions from stakeholders regarding improvements in business performance
-
Provide regular updates on the progress of initiatives and team performance, with non-exhaustive examples including metrics for executive meetings, board presentations, acquisitions, rep performance management, etc.
-
Create and maintain rich interactive visualizations through data interpretation and analysis integrating various reporting components from multiple data sources.
-
Maintain databases by acquiring and managing data from primary and secondary sources and auditing for data hygiene.
-
Build reusable reports within Excel for stakeholders across the organization.
Qualifications (Required):
-
Extremely strong Excel skills are required to be successful in this position. Candidates must feel extremely comfortable using complex formulas and connecting workbooks to Salesforce via Power Query for refreshable data manipulation.
-
2+ years of Salesforce experience, with 1+ years of experience as a Salesforce Admin.
-
2+ years of experience working cross-functionally with stakeholders at all levels.
-
2+ years of proven experience managing the quality of an internal database.
-
1+ year of Power BI experience building drillable, actionable reports and dashboards connected to both static and dynamic sources
-
Proven track record of analytical skills, data mining, evaluation, analysis and extrapolation, and data visualization.
-
Advanced presentation skills.
Qualifications (Preferred):
-
Salesforce Administrator certification is preferred
-
Microsoft Power BI Data Analyst certification is preferred
-
Experience with ethical web-scraping
-
Experience developing in VBA (write macros for automation/creation of reporting)
Physical/Mental Requirements for the Job:
-
Prolonged periods of seating
-
Frequent usage of electronics, including but not limited to computers and/or smart devices
-
May be requested to work overtime and weekends if deemed necessary
-
Must be able to lift at least 20 pounds
-
Certain management positions might be required to occasional travel