Job Details
Job Summary
You re a business or marketing professional who loves working with data to generate actionable insights. When confronted with a challenge or question, your natural instinct is to dig in and find out why. You know your way around Excel and relational databases and can create data models and visualizations with ease. You are relied upon for your analytical and problem-solving capabilities, as well as functional experience to cultivate a positive customer relationship. You are expected to analyze customer data and offer recommendations on sales, marketing, and other business data centric initiatives. You can work with non-technical stakeholders to translate their requests into a query or report that provides the information they need. You re looking to hone and grow your skillset by taking on new challenges and are also excited about learning how our business works and bringing fresh ideas and approaches to problem solving. Your idea of a good time is gathering data, looking for insights, and communicating your findings.
This position reports to the PAC Senior Director of Marketing and works closely with several departments, including Information Services and the CEO.
Us:
We are Professional Assist Corporation (PAC), an employee-owned, private corporation operating a group of professional membership associations based in Genesee, CO. Our primary sister associations include Associated Bodywork & Massage Professionals (ABMP), Associated Skin Care Professionals (ASCP,) and Associated Hair Professionals (AHP). Each of these is a leading professional association in the professions we serve, offering our members benefits, practice-building tools, and liability insurance to help them be successful in their careers. We have a staff of 57 talented, dedicated employees who work collaboratively to support our members, as well as a supportive, empowering company culture. We invest in people and resources to produce member benefits that meet and exceed individual and professional expectations.
Where:
PAC is situated in the foothills west of Golden, Colorado (local candidates only). We have a beautiful view of the spectacular Colorado high country. Our empowering environment is filled with high-energy, talented people who share your enthusiasm. We embrace a hybrid work environment. Tuesday through Thursday we work from our mountain office; Mondays and Fridays we have the option to work from home.
Core Responsibilities
Own day-to-day processes and infrastructure for the collection, analysis, and reporting key metrics across all PAC operating businesses.
Responsible for various special data-focused projects to support planning/forecasting, ongoing operations, and corporate development, as necessary.
In charge of day-to-day management and on-going optimizations of the organization s Customer Relationship Management (CRM) database systems and marketing automation tools, including processes and workflow to ensure efficiency.
Build and deploy prospect and member email and SMS campaigns.
Develop insights and recommendations to help drive membership growth and improve member experience and retention.
Own the CRM platform from a marketing project management and change implementation perspective.
Create and maintain regular marketing and business reporting, including distributing weekly reports and dashboard creation/maintenance.
Focus on business intelligence and marketing insights with other research, analytics, and database projects.
Make an estimated 25 expired member outreach calls per week (a duty shared by PAC employees) to help members renew their membership.
Knowledge, Skills, and Abilities
Extract and manipulate data from a variety of systems and offline reporting, utilizing analytics tools to analyze data, as necessary.
Exercise inquisitive mindset to transform business questions into actionable data exploration exercises, as well as take reported data and shape it into actionable business questions.
Translate insights into effective presentations that are outcome- and action-oriented supported by data storytelling.
Qualifications
Ideal candidate will have:
5+ years of relevant work and/or academic experience in a highly quantitative environment
Advanced Excel experience
Familiarity with MS SQL Server and T-SQL, along with optimizing large SQL queries
Experience with SQL Server Reporting Services
Experience with MySQL server
Experience with Python, R or other analytics-focused languages
Strong grasp of statistics and enterprise systems
Experience with visual analytics such as Tableau, Power BI, SEM Rush
Intellectual curiosity, attention to detail, ample initiative, self-reliance, and solid project management skills
Collaborative team player with a willingness to shift from high-level critical thinking to necessary mundane tasks required to complete a job
Excellent interpersonal, verbal, and written communications skills
Ability to manage multiple projects simultaneously
Ability to protect extremely confidential information
A bachelor s degree or the equivalent work experience is desired
Benefits/Compensation
Comprehensive health insurance including group medical, dental, vision, life, accident, and disability options
Generous PTO program (15 days at hiring) plus eight standard holidays and two personal days
401k plan with up to 5% employer matching contribution
Inclusive workplace an Equal Opportunity Employer that supports Diversity, Equity, and Inclusion
Empowering environment 2019, 2020, 2021, 2022, 2023 Denver Post Top Workplace
$400 annual Beauty and Wellness Allowance
For this salaried, exempt position, the competitive compensation range is $70,000 $90,000 a year.
The pay for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), and other law.
To Apply
If this posting resonates with you, we d love to learn more about you. Please submit your cover letter and resume via LinkedIn. No phone calls or drop-ins, please.
COLORADO RESIDENTS ONLY.
Job Type: Full-time
Pay: $70,000.00 - $90,000.00 per year
Benefits:
- 401(k)
- Dental insurance
- Flexible spending account
- Health insurance
- Health savings account
- Life insurance
- Paid time off
- Vision insurance
Schedule:
- 8 hour shift
- Day shift
- Monday to Friday
Work Location: Hybrid remote in Golden, CO 80401