A family office for your family.
Community Analytics Manager
Location
United States
Posted
1 day ago
Salary
$95K - $105K / year
Seniority
Senior
Job Description
Community Analytics Manager
Mercer Advisors
• Serve as the primary analytics partner for Community Marketing and Client Development. • Help define the analytics roadmap and key measurement priorities for Community programs. • Partner with Community Marketing leadership to prioritize opportunities based on business impact. • Develop hypotheses, business cases, and recommendations that inform strategic decisions. • Lead analyses across advisor referrals, client referrals, COI programs, events, specialty initiatives, advisor-sourced opportunities, and emerging Community programs. • Diagnose performance trends and identify root causes of business challenges and opportunities. • Conduct market-level, advisor-level, and program-level analyses to uncover growth opportunities and performance gaps. • Evaluate lead quality, conversion performance, pipeline contribution, and program ROI. • Translate complex findings into clear, actionable recommendations that influence decision-making. • Own the development, maintenance, and ongoing enhancement of Community Power BI dashboards, executive scorecards, reporting packages, and self-service reporting tools. • Develop scalable reporting solutions that reduce manual effort and increase visibility into Community performance. • Partner with Business Intelligence, Salesforce, and Operations teams to improve data quality, reporting automation, and measurement capabilities. • Identify gaps in tracking, attribution, reporting logic, and operational processes. • Help standardize KPIs, reporting definitions, and performance methodologies across Community programs. • Leverage AI-enabled tools, including Claude, to accelerate analysis, reporting, insight generation, and workflow automation. • Own recurring business reviews, executive scorecards, performance updates, and operating cadences for Community Marketing. • Drive the weekly Community Program Office (PO) process, including agenda development, initiative tracking, status reporting, action item management, and follow-up. • Provide executive leadership with clear visibility into program performance, priorities, blockers, risks, dependencies, and areas requiring support or intervention. • Support quarterly business reviews, annual planning, and strategic planning efforts through reporting, analysis, and recommendations. • Develop forecasts for leads, SQLs, opportunities, pipeline, and revenue. • Establish success metrics and measurement frameworks for Community programs and new initiatives. • Monitor performance, identify optimization opportunities, and partner with program owners to drive improvements. • Support annual planning, goal setting, and performance tracking activities. • Build strong partnerships across Community Marketing, Client Development, Revenue Partner leadership, Salesforce, Operations, and Business Intelligence. • Act as a trusted advisor to Community program owners and leadership teams. • Drive a culture of accountability, measurement, and continuous improvement through data-driven decision making.
Job Requirements
- Bachelor's degree in Analytics, Statistics, Economics, Finance, Business, Marketing, or a related field.
- 4-7 years of experience in analytics, business intelligence, strategy, consulting, marketing analytics, revenue operations, or a related discipline.
- Advanced Excel and data analysis capabilities.
- Experience building and maintaining dashboards in Power BI or similar business intelligence tools.
- Strong understanding of sales and marketing funnels, lead generation, conversion measurement, and performance optimization.
- Experience working with CRM data and reporting environments (Salesforce preferred).
- Strong problem-solving and analytical thinking skills.
- Ability to synthesize large datasets into concise recommendations for both technical and non-technical audiences.
- Excellent written, verbal, and presentation skills.
- Experience leveraging AI tools (e.g., Claude) to accelerate analysis, reporting, insight generation, and workflow automation.
- Demonstrated ability to independently manage complex projects and competing priorities.
Benefits
- Company Paid Basic Life & AD&D Insurance
- Company Paid Short-Term and Long-Term Disability Insurance
- Supplemental Life & AD&D; Short-Term Disability; Accident; Critical Illness; and Hospital Indemnity Insurance
- Three Cigna medical plans offerings including two High Deductible Health Plans and a Traditional Co-Pay medical plan.
- Kaiser Medical plans available in California
- Health Savings Account (HSA) with company contributions if enrolled in either HDHP medical plan.
- Two comprehensive Dental Plans
- Vision Insurance Plan
- Dependent Care Savings Account for child and dependent care.
- 14 Company Paid Holidays including a full week off at Thanksgiving.
- Generous paid time off program for vacation and sick days
- Employee Assistance Plan
- Family Medical Leave
- Paid Parental Leave (8 weeks)
- Maternity benefits utilizing company paid STD, any supplemental STD, plus Parental Leave (8 weeks) to provide time for recovery, baby bonding, and enjoying your family time.
- Adoption Assistance Reimbursement Program
- Company Paid Concierge Services for you and your loved ones for the spectrum of caring needs for your aging parents, young children, life’s challenges and more.
- 401(k) Retirement Plan with both Traditional and Roth plans with per pay period match as well as an after-tax option
- Pet Insurance
- Personalized financial planning and guidance from Mercer Advisors professionals, offered at preferred employee pricing
Related Guides
Related Categories
Related Job Pages
More Data Analyst Jobs
Monitoring, Evaluation and Research Analyst – Technology and Data
MotrizWe drive the engine of change for a more just and equitable Brazil, strengthening governments through people!
• Build and maintain data ingestion, processing, and integration pipelines from multiple sources (educational assessments, school management systems, and public databases such as the School Census and INEP). • Model relational databases and analytical structures that support efficient, scalable queries. • Automate routines for data updating, validation, and quality checks. • Develop and maintain panels, dashboards, and data visualization interfaces for use by education secretariat managers and internal teams. • Translate analytical needs of non-technical users into clear, intuitive visualization solutions. • Iterate on data access and navigation features based on user feedback. • Work closely with the technology team to define data architecture and system integrations. • Document technical processes, database structures, and indicator logic to ensure maintainability and continuity. • Support the specification of technical requirements for new analytical features with vendors or the development team. • Produce exploratory analyses and indicators to inform studies and reports for the monitoring, evaluation, and research (MER) area. • Support the methodological validation of predictive models and learning indicators. • Provide technical support to users of data tools, including training and troubleshooting.
• Elicit business, Marketing and consumer experience requirements and translate them into data solutions and products. • Map, document and integrate consumer data from multiple sources (e-commerce, CRM, websites, apps, campaigns, loyalty programs, Customer Service, marketing automation and CDPs). • Perform data mapping between source systems and the Azure platform, defining integration, transformation and enrichment rules. • Build and maintain data models and documentation (Customer Profile, Customer Journey, segmentations, Data Dictionary, Business Rules, Data Lineage and Customer Data Models). • Support the creation of a 360° consumer view by defining KPIs and working with Data Engineering on pipeline development and data modeling. • Ensure data quality, governance and compliance (LGPD), supporting CRM, Marketing Analytics, personalization and audience activation initiatives. • Act as a liaison between Marketing, CRM, Consumer Insights and technical teams.
• Lead analytical efforts to drive data informed decision-making across the entire organization by gathering, analyzing, and visualizing / presenting technical insurance data. • Collaborate with data engineering, insurance product, claims, finance, and operations teams to improve data integrity and automate reporting capabilities using VBA, SQL, and Python. • Transform complex insurance data into clear, compelling insights for both technical and non-technical stakeholders through required reporting and data visualization. • Conduct deep-dive data analysis, develop analytical tools, deliver dedicated solutions to help other departments automate their workflows, and identify opportunities to enhance business performance and operational effectiveness. • Provide ad hoc analytical support and research as needed to ensure Ledgebrook continues to operate with data-driven precision.
Advanced Specialist, Business Analytics
Pearson VUEThe potential of every professional. The promise of every industry.
• Document current payroll processes, workflows, handoffs, controls and dependencies across countries or initiatives. • Create and maintain clear process maps, standard operating procedures, workflow documentation and operational playbooks. • Support payroll transformation initiatives by assessing readiness, identifying risks, documenting impacts and tracking key actions. • Gather and validate inputs from stakeholders across Payroll, HR Operations, Finance, Technology, Legal, Procurement and external providers. • Support business change activities, including vendor transitions, platform changes, service delivery improvements and M&A-related payroll workstreams. • Identify manual workarounds, process gaps and automation opportunities for further review by technology or transformation teams. • Coordinate governance activities such as readiness checkpoints, issue logs, decision records and action trackers. • Share documentation standards, process insights and best practices to support consistent ways of working.




