Senior Business Intelligence Analyst Job Washington area,District of Columbia USA,IT/Tech

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 Infrastructure

Develop 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 Analytics

Track 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 Publications

Support data needs of innovation and research team as needed.

Integrate survey and other…