Data Analyst (Mostly Remote)

This position requires 1 day per week on site in Bethesda, MD. Salary: $85,000 - 90,000/yearWe 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 ResponsibilitiesInterrogate 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 & Qualifications3–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).