Job Description

Job Summary

Your idea of a good time is gathering and harnessing data, analyzing for insights, and communicating your findings. When given a challenge or question, your natural instinct is to dig in and find out “why.” You know your way around analytics tools and relational databases and can build smart dashboards that deliver. You are an analytical, critical thinker who generates actionable insights to enhance business practices, sales, marketing, and customer experience.

This position reports to the PAC Senior Director of Operations and works closely with several departments, including Information Technology 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 58 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. 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 of key metrics across all PAC operating businesses.
• Responsible for various data-focused projects to support planning/forecasting, ongoing operations, and corporate development, as necessary.
• Support requests from staff across the organization to query datasets from customer management system/relational database.
• In charge of performance analytics and key learnings for PAC’s marketing campaigns and channels (e.g., social media, email, etc.).
• Develop insights and recommendations to help drive membership growth and improve member experience and retention.
• 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 tools to analyze data, as necessary.
• Sanitize and correlate disparate sources of data to drive business initiatives.
• Exercise inquisitive mindset to transform business questions into actionable data exploration exercises, as well as take reported data and shape it into actionable business take-aways.
• Translate insights into effective presentations that are outcome- and action-oriented, supported by data storytelling.
• Display intellectual curiosity, attention to detail, initiative, self-reliance, and solid project management skills.
• Collaborate with stakeholders and be excited to shift from high-level critical thinking to hands-on routine tasks to get the job done.
• Display excellent interpersonal, verbal, and written communications skills.
• Manage multiple projects simultaneously.
• Show discretion and protect extremely confidential information.
• The non-curious need not apply.

Qualifications

The ideal candidate will possess many of the following:

• 3+ years of relevant work and/or academic experience in a quantitative environment
• Proficiency in writing SQL queries and pulling data from various sources
• Proficiency in extracting data from a large, transactional database
• Proficiency in scrubbing and cleaning data
• Experience in Microsoft Office analytics software is preferred, including:

Power BI

Microsoft OneLake

Azure Analysis Services

Microsoft Fabric

Microsoft SQL Server and T-SQL

ETL for SQL data into Microsoft Fabric

Excel

• Proficiency in Google Analytics
• Experience with SEM Rush a bonus
• Experience with statistical analysis using R, Python, or similar languages a bonus
• A bachelor’s degree or the equivalent work experience is desired

Benefits/Compensation

• Comprehensive health insurance including medical, dental, vision, accident, life, and disability options offered
• Paid time off (PTO) accrues per hour worked; you can earn up to 17 days of PTO in the first year. PTO accruals increase after 2 years of employment (up to 20 days per year) and after 10 years of employment (up to 23 days per year).
• Eight paid standard holidays
• One paid day to volunteer annually
• Eligible for two-week paid sabbatical after 5 years of employment
• Immediate 401k participation with up to 5% company match
• Inclusive workplace—an Equal Opportunity Employer
• $400 annual Beauty and Wellness Allowance

 

For this salaried, exempt position, the competitive compensation range is $85,000–$95,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.

 

Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.

 

Colorado Residents: In any materials you submit, you may redact or remove age-identifying information such as age, date of birth, or dates of school attendance or graduation. You will not be penalized for redacting or removing this information.

Applicants: Must live in the Denver metro area and be available for in-office work 60% of the work week.

To apply, please send your resume and cover letter to outreach@abmp.com. No phone calls or drop-ins. No relocation available; only area residents need apply.

Job Tags

Hourly pay, Holiday work, Work experience placement, Immediate start, Work from home, Relocation, Work visa, Shift work, Monday to Friday,

Similar Jobs