Data Analyst (Mostly Remote)

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