Aptean is seeking a Lead Marketing Operations Specialist who is adept at navigating complex systems and data, as well as driving change across cross-functional teams. This role demands strong analytical abilities to examine data infrastructures, recommend improvements, and build reports to communicate insights effectively. If you're comfortable with data complexity within a broad product portfolio and eager to work with minimal supervision, this opportunity is for you.
Roles and Responsibilities
- Work extensively in our data orchestration tool, RingLead, to manage data, including:
- Cleansing data (removing duplicates, matching, and converting Leads to Accounts).
- Transforming data (setting fields based on others, formatting entries).
- Updating data (corrections, reassigning accounts).
- Enriching records (Leads, Contacts, Accounts with firmographic and demographic information).
- Routing Leads (assigning Leads and Contacts based on territories).
- Establish and manage processes and tool linkages for data cleaning, both automated and manual.
- Establish regular cycles to update existing data, determining timing and processes for non-automated updates.
- Identify new processes/sources for new data and/or to create relationship structures around existing data (e.g., identifying related accounts as separate locations of the same company).
- Analyze data issues by pulling data from CRM into Excel, manipulating it, and determining necessary corrections.
- Build infrastructure/database structures to organize data meaningfully and usability for Marketing and Sales (e.g., structuring related accounts). This includes identifying new fields and processes for population.
- Perform manual data cleaning, such as populating new fields for new data structures via data uploads.
- Create reports to communicate the state of the data.
Skills and Abilities
- Strong knowledge of CRM systems and data (Salesforce.com preferred).
- Advanced experience with Excel, including building and manipulating large datasets, building models, and assessing fit to specific criteria.
- Demonstrated experience owning and using a data tool/platform (RingLead preferred).
- Experience pulling large sets of data from CRMs or external tools (such as D&B).
- Strong understanding of databases and data structures and comfort with large datasets.
- Excellent technical skills in Salesforce.com and Excel.
- Detail-oriented with strong analytical and time management skills.
- Curiosity and ability to identify solutions to data problems creatively.
- Able to operate successfully in a lean, fast-paced organization.
- Strong written and verbal communication skills.
- Self-starter with a take charge mentality and a proven ability to get things done.
- Intermediate facilitation skills with the ability to drive issues to closure.
- Self-motivated and able to handle tasks with minimal supervision or questions.
- Ability to compare technologies and make recommendations to senior members of the team.
- Experience working with database and CRM field structures.
- Experience with Segmentation modeling is a plus.
- Experience with SQL or similar is a plus.
Qualifications
- Education: Bachelor's degree (Bachelor's degree in Statistics, Computer Science, Engineering, Mathematics, related quantitative discipline, or equivalent practical experience preferred).
- Work Experience: 3-5 years of data quality or similar level data analysis experience required.
