The Hubspot System Administrator & CRM Data Analyst will be responsible for the security, fidelity, and accuracy of the data in the HubSpot system as well as the maintenance of role-based access, data quality, and ongoing user support of SBM’s HubSpot environment. The analyst will work closely with other CRM Team members and business subject matter experts to process data hygiene requests, update requirements and business processes specifications, and aid in large projects. The analyst will also work closely with IT development teams on projects intended to improve user experience and operational functionality; they must also work closely with SME’s to reconcile sales data between CRM and corporate systems of record. In addition, the analyst may assist in developing proposals for new policies and procedures, metrics, and for documenting process flows. Overall, the successful candidate in this role will have a strong track record and passion for Marketing, Technology, and Analytics.
Roles and Responsibilities
Qualifications
Roles and Responsibilities
- Serve as the single point of contact for SBM’s Hubspot environment
- Control system access, monitor data quality, and provide customer service to user com Serve as the single point of contact for SBM’s Hubspot environment
- Control system access, monitor data quality, and provide customer service to user community for optimal use of the system and the resulting analytics
- Specialize in collecting, organizing, and analyzing data from various systems
- Develop an in-depth understanding of the interrelationships of data and multiple data domains
- Create and maintain thorough documentation artifacts
- Identify and document data migration paths and processes
- Demonstrate commitment to providing customer-focused quality service
- Develop and perform standard queries to ensure data quality, identify data inconsistencies, and missing data then resolve as needed
- Perform data extraction, storage, manipulation, processing, and analysis
- Collect, profile, collate, and map appropriate data for usage in new or existing solutions as well as for ongoing data analysis activities
- Interpret customers’ functional and information needs and turn them into functional or data requirements, process models, etc.
- Perform other duties as deemed relevant based upon experience.
Qualifications
Education and/ or Experience
- Bachelor’s Degree or equivalent with 5 or more years of experience related to this position
- Prior Hubspot system experience required in a power user and/or system administrator role
- Experience or exposure to Extract/Transform/Load (ETL) and/or Business Intelligence
- Experience completing technical design via iterative mockups
- Expert experience using MS Office Suite (esp. Word and Excel)
- Must have experience creating and managing workflows to optimize the customer journey
Certificates, Licenses, Registrations
- May be required to have a valid driver’s license.
Knowledge, Skills, and Abilities
- High-level knowledge of enterprise IT organizational, business, and technical environments
- High aptitude in analytical and logical thinking
- Demonstrated experience with data models and data mapping
- Ability to perform ad-hoc analysis and maintain clear and comprehensive documentation of decision-making, data preparation, and processes
- Knowledge of Cloud based ERP solutions highly desirable
- Openness to learning new skills and software as necessary
- Demonstrated ability to manage simultaneous work flows while maintaining quality output and meeting deadlines
- Strong verbal and written communication skills with demonstrated ability to communicate at different levels of the organization
- Demonstrated ability to produce highly detailed, comprehensive documentation artifacts
- Client-focused attitude
- Ability to analyze processes and recommend improvements as needed
- Knowledge of role-based access logic and key controls for separation of duty to ensure optimal data reliability and need to know permissions
- Knowledge and application of relational database concepts