Data Analyst

*You:* 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 full-time, exempt 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.
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.
* Other responsibilities o 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 disabilityoptions * 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 full-time, exempt position, the competitive compensation range is $70,000–$90,000 a year.
_The pay for this job level ($70,000–$90,000 a year) 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 to outreach@abmp.
com or via Indeed by May 3, 2024.
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) * 401(k) 5% Match * AD&D insurance * Dental insurance * Dependent health insurance coverage * Disability insurance * Flexible spending account * Health insurance * Health savings account * Life insurance * Paid holidays * Paid time off * Vision insurance Experience level: * 5 years Schedule: * 8 hour shift * Day shift * Monday to Friday Ability to Relocate: * Golden, CO 80401: Relocate before starting work (Required) Work Location: Hybrid remote in Golden, CO 80401