Data Analyst (Mostly Remote)

Job Description

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

\n

\n

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

\n

\n

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.

\n

\n

Key Responsibilities

\n

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

\n

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

\n

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

\n

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

\n

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

\n

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

\n

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

\n

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

\n

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

\n

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

\n

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

\n

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

\n

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

\n

\n

\n

Required Experience & Qualifications

\n

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

\n

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

\n

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

\n

• Demonstrated proficiency writing advanced queries in SQL.

\n

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

\n

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

\n

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

\n

\n

\n