Data Analyst (Mostly Remote) — Bethesda, MD

This position requires 1 day per week on site in Bethesda, MD.

Salary: $85,000 - 90,000/year

We are seeking a Data Analyst to join our growing analytics practice. This position collaborates directly with accounts across public sector agencies (federal, state, and municipal), enterprise businesses, and mission-driven non-profits to design and execute evidence-based outreach strategies. In this role, you will bridge quantitative measurement, business intelligence, and audience insights to evaluate multi-channel campaigns, improve public engagement initiatives, and guide executive decision-making.

Key Responsibilities

• Interrogate structured and unstructured multi-source data to uncover meaningful patterns, risks, and strategic growth drivers.

• Build balanced scorecards, core key performance indicators (KPIs), and measurement frameworks to track campaign reach, community engagement, and return on investment.

• Conduct target audience segmentation, demographic profiling, and cross-channel performance evaluations.

• Execute ad hoc statistical investigations and exploratory data analysis to solve complex client questions.

• Leverage statistical modeling, predictive analytics, and pattern extraction to inform long-term client messaging and program architecture.

• Architect and maintain dynamic, automated dashboards and executive reporting suites across multiple BI environments.

• Transform raw metrics into digestible data stories, executive slide decks, and comprehensive narrative reports.

• Track digital ecosystem performance across web analytics, paid media, organic social channels, and public awareness initiatives.

• Enforce rigorous quality assurance and verification standards to satisfy strict client and contractual reporting mandates.

• Extract, transform, clean, and consolidate disparate data streams across CRM platforms, ad engines, web properties, and internal relational databases.

• Write complex SQL queries and build scalable data models to ensure data accessibility and structural integrity.

• Champion data governance protocols, metadata documentation, and data-cleansing best practices.

• Identify routine reporting bottlenecks and deploy scripted automation to streamline operational workflows.

Required Experience & Qualifications

• 3–5 years in a data analytics, campaign measurement, business intelligence, or market research capacity.

• Bachelor’s degree in Data Analytics, Applied Mathematics, Statistics, Computer Science, Information Management, or an equivalent quantitative discipline.

• Prior exposure to agency settings, strategic communications, management consulting, or government contracting environments.

• Demonstrated proficiency writing advanced queries in SQL.

• Hands-on scripting experience for data manipulation and analysis using Python or R.

• Proven expertise authoring dashboards in business intelligence tools such as Tableau, Power BI, or comparable software.

• Advanced Microsoft Excel capabilities (complex lookup functions, nested formulas, pivot models, data manipulation).