Work with a nationally ranked CPA and advisory firm that is passionate for what's next. Aprio has 22 U.S. office locations, one in the Philippines and more than 2,100 team members that speak 60+ languages across the globe. By bringing together proven expertise, deep understanding, and strategic foresight for fast-growing industries, Aprio ensures clients are prepared for wherever life or business may take them. Discover a top-rated culture, vast growth opportunities and your next big career move with Aprio.
Join Aprio's Business Operations, Growth team and you will help clients maximize their opportunities. Aprio is a progressive, fast-growing firm looking for a CRM Data Integration Specialist to join their dynamic team.
Aprio is seeking a detail-oriented and analytical CRM Data Integration Specialist to join our Digital Marketing Team. This role is crucial in ensuring the accuracy, completeness, and consistency of our client and prospect data within our CRM system, HubSpot. You will be responsible for extracting, cleaning, transforming, and importing data from various sources, including Excel spreadsheets and other CRMs, into HubSpot.
Position Responsibilities:
- Data Extraction: Retrieve data from diverse sources, including Excel spreadsheets and other CRM systems.
- Data Cleansing: Scrutinize data for inconsistencies, errors, duplicates, and missing information. Implement data cleansing processes to ensure data accuracy and integrity.
- Data Mapping: Establish clear mappings between data fields from different sources and HubSpot’s corresponding fields, ensuring data consistency.
- Data Migration: Transfer cleaned and mapped data into the HubSpot CRM platform, preserving data integrity throughout the process.
- Data Quality Assurance: Conduct regular data quality checks to maintain data accuracy and completeness.
- Process Improvement: Identify opportunities to streamline data integration processes and enhance efficiency.
- Collaboration: Work closely with cross-functional teams to understand data requirements and ensure data alignment.
Qualifications:
- Minimum 2 years in data cleaning, transformation, and integration techniques.
- Strong Excel skills, including data manipulation and analysis.
- Experience with CRM systems, preferably HubSpot.
- Familiarity with data management tools and databases.
- Attention to detail and ability to handle large datasets accurately.
- Strong analytical and problem-solving skills.
- Excellent organizational and time management abilities.
- Ability to work independently and as part of a team.
Preferred Qualifications:
- Knowledge of data integration tools and ETL processes.
- Experience with scripting languages (Python, SQL).
- Understanding of data warehousing and data modeling concepts.
- HubSpot certifications.
Perks/Benefits we offer for full-time team members:
- Wellness program
- HMO coverage
- Rewards and Recognition program
- Free shuttle service (provided by CDC | for onsite employees)
- Free lunch meal (For onsite employees)
- On-demand learning classes
- Discretionary time off and Holidays
- Performance-based salary increase
- Discretionary incentive compensation based on client or individual performance
- Hybrid set up to selected roles/location, terms and conditions may apply
- CPA & Certification Assistance and Bonus Program
What's in it for you:
- Working with an industry leader: Be part of a high-growth firm that is passionate for what's next.
- A great team: Work with a high-energy, passionate, caring, and ambitious team of professionals in a collaborative culture.
- Growth opportunities: Grow professionally in an environment that fosters continuous learning and advancement.
- Competitive compensation: You will be rewarded with competitive compensation.
EQUAL OPPORTUNITY EMPLOYER
Aprio is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race; color; religion; national origin; sex; pregnancy; sexual orientation; gender identity and/or expression; age; disability; genetic information, citizenship status; military service obligations or any other category protected by applicable federal, state, or local law.
