Job SummaryYou'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 ResponsibilitiesOwn 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 AbilitiesExtract 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.QualificationsIdeal candidate will have:5 years of relevant work and/or academic experience in a highly quantitative environmentAdvanced Excel experienceFamiliarity with MS SQL Server and T-SQL, along with optimizing large SQL queriesExperience with SQL Server Reporting ServicesExperience with MySQL serverExperience with Python, R or other analytics-focused languagesStrong grasp of statistics and enterprise systemsExperience with visual analytics such as Tableau, Power BI, SEM RushIntellectual curiosity, attention to detail, ample initiative, self-reliance, and solid project management skillsCollaborative team player with a willingness to shift from high-level critical thinking to necessary mundane tasks required to complete a jobExcellent interpersonal, verbal, and written communications skillsAbility to manage multiple projects simultaneouslyAbility to protect extremely confidential informationA bachelor's degree or the equivalent work experience is desiredBenefits/CompensationComprehensive health insurance including group medical, dental, vision, life, accident, and disability optionsGenerous PTO program (15 days at hiring) plus eight standard holidays and two personal days401k plan with up to 5% employer matching contributionInclusive workplace-an Equal Opportunity Employer that supports Diversity, Equity, and InclusionEmpowering environment-2019, 2020, 2021, 2022, 2023 Denver Post Top Workplace$400 annual Beauty and Wellness AllowanceFor 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 ApplyIf 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-timePay: $70,000.00 - $90,000.00 per yearBenefits:401(k)Dental insuranceFlexible spending accountHealth insuranceHealth savings accountLife insurancePaid time offVision insuranceSchedule:8 hour shiftDay shiftMonday to FridayWork Location: Hybrid remote in Golden, CO 80401