Community Management Analyst

Mecklenburg County Government; Charlotte (NC); On-site; USD 63,000 - 95,000; Full time

Job summary

The Community Management Analyst at Mecklenburg County Government plays a key role in supporting small businesses affected by transportation projects. The position focuses on transforming data into actionable insights, managing case workflows, and ensuring timely communication across BOAST initiatives.

You will develop dashboards, reports, and performance metrics; administer CRM platforms; and implement the BOAST hotline and ticketing systems to handle inquiries about construction schedules and

Qualifications

• Minimum of two years experience in a related field.
• Bachelor’s degree in business administration, Public Administration, Data Analytics or a related field.
• Combination of relevant education and relevant experience accepted?: YES

Responsibilities

• Collect, organize, interpret, and report data from business site visits, hotline services, surveys, ticketing system, and BOAST activities.
• Develop and implement business hotline and ticketing systems by contributing to intake workflows, case routing logic, data capture standards, and user experience.
• Interpret data trends to identify emerging issues, business needs, and construction‑related impacts.
• Serve as the primary administrator of multiple CRM platforms, managing case records, data integrity, workflow automation, and user permissions.
• Develop and implement regular reports and dashboards in Salesforce to monitor case volume, response times, resolution rates, and trends across project areas and business types.

Skills

Data analysis

CRM administration

Dashboard creation

Communication

Project coordination

Education

Bachelor’s degree in business administration

Bachelor’s degree in Public Administration

Bachelor’s degree in Data Analytics

Tools

Salesforce

Power BI

Job description

CommunityManagement Analyst

Salary Range: $63,080.00 - $94,620.00

This is an exempt (salaried) position. Please note: pay rates are based on education, skill, experience level and internal equity. Internal equity considerations include an assessment of the applicant’s salary history and qualifications in comparison to the market rate and requirements for the job.

At Mecklenburg County, you’ll have the chance to build a career as unique as you are with support, inclusive culture, and technology to become the best version of you. We’re counting on YOUR unique voice and perspective to help Mecklenburg County become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.

POSITION SUMMARY

The Community Management Analyst plays a critical role in supporting small businesses and entrepreneurs adversely affected by transportation development and infrastructure construction throughout Mecklenburg County. This position serves as the analytical and operational backbone of the Business Opportunity and Supportive Transit (BOAST) initiative, transforming complex data into actionable insights, managing case workflows, and ensuring timely, accurate communication across programs.
The Analyst is responsible for collecting and interpreting data from business site visits, hotline interactions, surveys, CRM systems, and ticketing platforms to identify emerging issues, business needs, and construction‑related impacts. The role develops and maintains dashboards, reports, and performance metrics that guide decision‑making for leadership, program managers, and partner agencies.
The Analyst will develop and implement the BOAST hotline and ticketing systems, ensuring that inquiries related to construction schedules, access disruptions, and mitigation resources are handled with accuracy, urgency, and professionalism. The position ensures all cases are documented, triaged, routed, and resolved in alignment with established protocols.

This role requires strong analytical skills, exceptional attention to detail, and the ability to communicate complex information clearly to diverse audiences. The Analyst maintains SOPs, ensures data security and confidentiality, and supports cross‑departmental coordination to strengthen the County’s ability to respond to business needs. Through this work, the Community Management Analyst plays a vital role in helping small businesses remain resilient, informed, and supported during periods of construction‑related disruption.

DUTIES AND RESPONSIBILITIES

This position supports businesses and entrepreneurs impacted by transportation development and infrastructure construction. The management analyst will provide innovative solutions for BOAST Hotline and Ticketing System by designing and improving the tools and systems that enable responsive, high‑quality business assistance.

ESSENTIAL FUNCTIONS

• Collect, organize, interpret, and report data from business site visits, hotline services, surveys, ticketing system, and Business Opportunity And Supportive Transit (BOAST) activities.
• Develop and implement business hotline and ticketing systems by contributing to the design, configuration, and continuous improvement of intake workflows, case routing logic, data capture standards, and user experience. Collaborate with BOAST staff and technical teams to build efficient, responsive systems that support businesses experiencing construction‑related impacts.
• Interpret data trends to identify emerging issues, business needs, and construction‑related impacts.
• Serve as the primary administrator of multiple CRM platforms, managing case records, data integrity, workflow automation, and user permissions to ensure accurate tracking of all business assistance activities.
• Develop and implement regular reports and dashboards in Salesforce to monitor case volume, response times, resolution rates, and trends across project areas and business types.
• Develop, implement, and maintain BOAST metrics. Analyst will prepare weekly, monthly, and quarterly updates for leadership, program staff, and partner agencies.
• Manage the ticketing/help desk system to ensure timely intake, routing, and resolution of business inquiries and concerns. Open, assign, triage, and resolve ticketing cases submitted by businesses experiencing construction‑related impacts, ensuring each case is documented with complete and accurate information.
• Operate and monitor a dedicated business hotline, providing timely, accurate responses to urgent inquiries related to upcoming construction schedules, road closures, access disruptions, and available resources.
• Identify recurring issues and flag trends that require programmatic or policy attention. Escalate high‑priority or unresolved cases to field staff, program managers, or partner agencies and track resolution status through to closure.
• Support BOAST Staff by preparing data packets, GIS maps, outreach materials for pop‑up markets and door‑to‑door visits.
• Continuously assess and recommend improvements to case management workflows, Salesforce configuration, and hotline operations to increase efficiency and responsiveness to vulnerable businesses.
• Assist with logistics, scheduling, and documentation for business site visits and community engagement events.
• Coordinate with the BOAST staff to track service provider performance, cohort milestones, and contract deliverables. Collaborate with BOAST staff to ensure that in‑person business interactions, referrals, and site visits are accurately entered and linked to corresponding case records.
• Provide regular updates to internal teams on business needs, construction impacts, and program outcomes.
• Document and maintain standard operating procedures (SOPs) for case management workflows, hotline protocols, and data entry standards to ensure consistency across the team.
• Maintain confidentiality and data security standards for all business records, ensuring compliance with organizational policies and applicable privacy regulations.
• Support cross‑departmental coordination by sharing data insights and ensuring alignment across programs.
  Cultivate and managerelationships with ecosystem partners including nonprofits, government agencies, and philanthropic organizations.
• Maintain a digital resource guideand referral network to serve small businesses across Mecklenburg County.
• Maintains current knowledge of economic development policies, best practices, and industry trends; participate in ongoing training and professional development to enhance performance.
• Participates in regular staff and project meetings; maintains organized paper and electronic records; completes required forms and documentation in a timely manner.
  Proficient utilization of standard office equipment, including computers and tablets, may operate a County or personal vehicle to attend off‑site meetings and visit client locations.
• Performs other duties as assigned in response to evolving program needs and a dynamic work environment.

• Work on occasional evenings and weekends to attend programs to support small business

MINIMUM QUALIFICATIONS

Experience:
Minimum of two years experience in a related field.

Education:
Bachelor’sdegree in business administration, Public Administration, Data Analytics or a related field.

Combination of relevant education and relevant experience accepted?: YES

PREFERRED QUALIFICATIONS

• High personal and professional integrity, self‑motivation, and a commitment to advancing small business success.
• Demonstrated ability to work collaboratively with diverse audiences, including business owners, community leaders, faculty, and students.
• Proven track record of problem‑solving, innovation, and successful project execution.
• Ability to collect, clean, analyze, and interpret complex datasets from multiple sources (CRM, hotline, surveys, ticketing systems) and translate findings into actionable insights.
• Proficiency in creating dashboards and visual reports (e.g., Salesforce, Power BI) to communicate trends, performance metrics, and program outcomes.
• Demonstrated computer skills, proficiency in Microsoft Word, Excel, PowerPoint, and internet research.
• Experience managing CRM platforms, including data integrity, workflow automation, user permissions, and case management best practices.
• Understanding of how transportation and infrastructure projects affect small businesses, including access disruptions, foot‑traffic changes, and operational challenges.
• Ability to manage intake, triage, routing, and resolution of cases using structured ticketing or help desk tools.
• Skill in assessing workflows, identifying inefficiencies, and recommending improvements to case management, hotline operations, and CRM configuration.
• Ability to prepare concise updates, summaries, and reports for leadership, program staff, and partner agencies.
• Capacity to cultivate and maintain relationships with nonprofits, government agencies, philanthropic partners, and business‑support organizations.
• Understanding of privacy regulations, secure data handling, and confidentiality standards for sensitive business information.
• Ability to establish and maintain effective relationships with fellow employees, outside agency personnel, and the public.
• Ability to perform a wide variety of duties and responsibilities with accuracy and speed under the pressure of time‑sensitive deadlines.
• Ability to focus on the needs of the customer, and on developing strong relationships with our customers.
• Previous experience with Salesforce.
• Multilingual applicants preferred.

REASONABLE ACCOMODATIONS STATEMENT

To accomplish this job successfully, an individual must be able to perform, with or without reasonable accommodation, each essential function satisfactorily. Reasonable accommodations may be made to help enable qualified individuals with disabilities to perform the essential functions.

DISCLAIMER STATEMENT

This is not intended to be an all-inclusive list of job-related responsibilities, duties, skills, requirements or working conditions. Other duties may be assigned based on business need and the supervisor’s request. Mecklenburg County reserves the right to revise the job description at anytime. Designated positions may be required to assist in emergency and/or disaster situations.