Data Analyst (Mostly Remote)

Job Description

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).