Mercer Advisors logo
Mercer Advisors

A family office for your family.

Community Analytics Manager

Data AnalystData AnalystFull TimeRemoteSeniorTeam 501-1,000Since 1985H1B No SponsorCompany SiteLinkedIn

Location

United States

Posted

1 day ago

Salary

$95K - $105K / year

Seniority

Senior

Bachelor Degree4 yrs expEnglish

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 Categories

Related Job Pages

More Data Analyst Jobs

Motriz logo

Monitoring, Evaluation and Research Analyst – Technology and Data

Motriz

We drive the engine of change for a more just and equitable Brazil, strengthening governments through people!

Data Analyst1 day ago
Full TimeRemoteTeam 51-200H1B No Sponsor

• 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.

Brazil
Full TimeRemoteTeam 1,001-5,000H1B No Sponsor

• 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.

Brazil
Ledgebrook logo

Data Associate – Data Excellence

Ledgebrook

Modernizing the Specialty insurance industry

Data Analyst1 day ago
Full TimeRemoteTeam 51-200Since 2021H1B No Sponsor

• 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.

Poland
zł12.5K - zł20.5K / month
Pearson VUE logo

Advanced Specialist, Business Analytics

Pearson VUE

The potential of every professional. The promise of every industry.

Data Analyst1 day ago
Full TimeRemoteTeam 1,001-5,000Since 1994H1B No Sponsor

• 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.

Philippines