Senior Business Intelligence Analyst

Job Description

Job Description

Who we are:ICMA is a mission-driven nonprofit organization dedicated to advancing professional local government. Founded in 1914, ICMA is the leading professional association for local government leaders, managers, staff, and stakeholders – serving more than 14,000 members across the globe. As a membership association, we equip professionals with the research, knowledge, and tools needed to create and sustain thriving communities. By advancing professional local government, we help communities deliver better services, engage residents, enable economic development, strengthen leadership, uphold ethics, and provide forward-thinking management. We ensure a diverse and inclusive workplace by welcoming people of different backgrounds, experiences, abilities, and perspectives and by learning from each other, individually and collectively. A Great Opportunity:Do you have a passion for delving into the many facets of a business's operations to identify meaningful data and insights to support and guide organizational decision-making? Does mission-driven work and making an impact excite you? If so, we have an excellent opportunity waiting for you!ICMA is seeking a Senior Business Intelligence Analyst to serve as the organization's primary resource for data collection, analysis, and reporting across digital marketing, association operations, the association management system (AMS), and research initiatives. This role transforms data from multiple platforms into actionable insights - supporting campaign performance, membership intelligence, executive decision-making, and organizational research. The selected candidate must be willing to commute to our state-of-the-art headquarters on a regular basis, which is conveniently located near Union Station and Capitol Hill in Washington, D.C.The salary for the Senior Business Intelligence Analyst is based on experience, with a range of $86,295 to $107,867.This position reports directly to the Special Assistant to the CEO/ED and Executive Board Liaison.What you'll do:Reporting & Data InfrastructureDevelop and maintain reports, dashboards, and data visualizations using Microsoft Reporting Services, Power BI, Tableau, or equivalent tools. Build and maintain database views and stored procedures to support reporting accuracy and data quality. Integrate data from various sources - including AMS, CRM, event registration, email, web, and paid media - into unified reporting views. Maintain documentation for data definitions, reporting methodologies, and data sources to ensure consistency across the organization. Respond to ad hoc reporting and data query requests from staff across departments in a timely manner. AMS Reporting and Member Intelligence Extract, analyze, and report on AMS data to support membership, program, event, and revenue reporting for staff, leadership, and the board. Track membership trends - including acquisition, retention, renewal rates, and engagement patterns - and develop reports that identify at-risk members, lapsed segments, and high-potential prospects to support recruitment and retention strategies. Partner with operations staff to resolve data issues, ensure consistent field usage, and identify opportunities to leverage AMS data more effectively across departments. Support the information technology team in data migration, audits, and cleanup initiatives as needed. Marketing, Social Media & Branding AnalyticsTrack and analyze performance across all digital channels - PPC, display, email, social media, and web - reporting on KPIs including conversion rates, ROAS, engagement, reach, and follower growth. Build and maintain dashboards; conduct A/B testing and funnel analysis to optimize campaign structure, keyword opportunities, and audience targeting. Monitor website traffic and user behavior; benchmark brand and social performance against peers; identify audience segmentation opportunities. Provide early warning tracking on email performance (opt-outs, deliverability, engagement trends) and ensure data accuracy across all marketing platforms.Research and PublicationsSupport data needs of innovation and research team as needed. Integrate survey and other research data into ICMA's overall business intelligence processes.Business Intelligence Needs Meet with internal stakeholders to identify BI needs and deliver reporting solutions that produce actionable information for operational and strategic decision-making. Support tracking and reporting on the organization's strategic roadmap, including progress against goals, milestones, and performance indicators for leadership and board reporting. Identify trends, anomalies, and emerging patterns in organizational data and proactively communicate findings to relevant teams. Assist in budget development and tracking program-related income and expenses. Collaborate with internal and external developers to maintain and improve data-related applications and reporting infrastructure. Perform other job-related duties as assigned. What you need to be successful in this role:Bachelor's degree in Data Analytics, Business Intelligence, Information Systems, Marketing, Statistics, or a related field. Five (5) or more years of experience in data analytics or similar role (collecting, organizing, and analyzing datasets to inform agency operations and reporting) and managing digital platforms and applications.Proficiency in core data analysis tools including Google Analytics, Tableau or Power BI, SQL, and Excel. Experience querying and reporting from an AMS or CRM platform and working with email marketing platforms (e.g., Informz, HubSpot, Mailchimp, or similar). Strong understanding of digital marketing channels and performance metrics. Strong written and verbal communication skills; able to present complex data clearly to non-technical audiences. Preferred Qualifications Experience in an association, nonprofit, or membership-based organizationExperience analyzing trends and performance variations across U.S. and international regions to inform marketing strategy and regional tactics. Experience with A/B testing, including test design, analysis, and translating results into actionable recommendations. Familiarity with marketing automation platforms (e.g., HubSpot, Marketo, Salesforce Marketing Cloud); Higher Logic Informz a plus. Familiarity with AMS or CRM platforms (e.g., NetForum, iMIS, Fonteva, Salesforce, YourMembership, MemberSuite, or similar). Working knowledge of SEO/SEM metrics, UX indicators (bounce rates, user flow), and campaign tracking best practices (UTM tagging, Google Tag Manager). Familiarity with e-commerce platforms . Experience with statistical analysis and survey research methodologies.Knowledge, Skills, and Abilities (KSAs)Analytical Skills: Ability to interpret data, identify trends, and provide insights.Technical Proficiency: Strong skills with Google Analytics, CRM systems, SQL, and Excel for data analysis.Data Management Practices and Visualization: Proficient in data management practices such as collecting, organizing, analyzing, and maintaining datasets to support decision-making and reporting requirements. Experience creating dashboards and visual reports using tools like Tableau, Power BI.Attention to Detail: High accuracy in data analysis and reporting, with a focus on data quality.Communication Skills: Excellent public speaking, interpersonal, and written communication skills with the ability to translate data insights for non-technical stakeholders.Organizational Skills/Time Management: Outstanding organizational skills, attention to detail, and ability to manage multiple projects and deadlines efficiently. Problem-Solving Skills: Ability to think critically and propose data-driven solutions.Adaptability and Learning Agility: Willingness to stay updated with the latest marketing tools and trends.Ability to be responsive to diverse constituencies within the organization.Physical Requirements/Work EnvironmentThe work environment and physical demands described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.Work is regularly performed in-person at ICMA's headquarters in Washington, D.C. Work is typically performed in an office environment free from hazards or unpleasant environmental conditions.Work requires travel up to 10% of time, primarily within the U.S.What we can offer you:A collaborative and collegial working environment where teamwork and individual contributions are valuedA competitive salaryA comprehensive benefits package that includes employer sponsored health, dental, life, disability, and employee assistance benefitsPaid time off to include vacation, sick leave, holidays, and floating daysGenerous retirement planOpportunities for ongoing professional developmentThis position is based out of ICMA's headquarters, located in Washington, D.C. The selected individual must be able to work the core business hours from 8:30 am to 5:00 pm ET.A high-speed internet connection is required when working virtually. Personnel will provide the internet service at their own expense. The internet connection must be of sufficient bandwidth to allow the team member to efficiently perform their regular job functions and participate in virtual meetings.The selected candidate must be legally authorized to work in the United States without the need for employer sponsorship, now or at any time in the future.EEO StatementAt ICMA, we strive to promote and sustain a culture of diversity, inclusion, and belonging every day. ICMA is an equal opportunity and affirmative action employer. We do not discriminate in recruiting, hiring or promotion, and all qualified applicants will receive consideration for employment without regard to race, color, ethnicity, national origin, religion, sex/gender, sexual orientation, gender identity or expression, age, disability, protected veteran status, or on any other basis or characteristic prohibited by applicable federal, state, or local law. We proudly support and encourage people with military experience (active, veterans, reservists, and National Guard) as well as military spouses to apply for ICMA job opportunities.