New

Data Analyst

AEM Corporation

$95,000-$105,000

United States, D.C., Washington

Sep 16, 2025

Data Analyst

Position Summary

Join our team as a Data Analyst and become a trusted expert on the federal agency's data ecosystem, including its sources, structures, quality challenges, and areas for improvement. You will work closely with government subject matter experts to quickly gain a comprehensive understanding of the agency's most important data domains and top data quality concerns. In our Scrum environment, you will drive delivery as the data specialist by writing SQL, profiling and analyzing data for user stories, and shaping functional strategies to continually enhance data quality. You will also design and conduct complex analyses using statistical tools to support decision-making, highlight risks, and validate results, always focusing on clarity, speed, and effective action.

What You'll Do

Become a data SME for a federal agency: map systems, source-to-target flows, business rules, and quality pain points; maintain living documentation (glossary, data dictionary, lineage) that the whole team trusts.
Support the Scrum team as the data expert: refine user stories, propose data-first acceptance criteria, estimate data tasks, and demo analytic outcomes that move the needle.
Write production-grade SQL to profile data, validate assumptions, generate datasets for analytics/BI, and prototype transformations that inform engineering backlogs.
Design & execute complex analyses using Microsoft Excel (advanced functions, Power Query, PivotTables) or similar statistical tools (e.g., Python) to quantify issues, test hypotheses, and measure impact.
Diagnose and improve data quality: define and operationalize rules, profiling checks, and remediation workflows; monitor results and close the loop with business owners.
Tell the story with data: build clear, consumable tables, visuals, and narratives (e.g., Power BI/Excel) that help stakeholders decide quickly and confidently.
Partner with stakeholders (product owners, program leads, security/privacy) to translate policy and program requirements into precise, testable data logic.
Contribute to team excellence: share patterns, templates, and how-to guides; propose automation and standards that increase velocity and reduce error.

What You'll Bring (Required Qualifications)

Ability to obtain a Public Trust background investigation.
Bachelor's degree in mathematics, computer science, or a related field.
5+ years of professional data analysis experience (or 3+ years with a related advanced degree).
Expert SQL for data profiling, validation, and dataset creation across relational warehouses and/or lakehouse query engines.
Advanced Microsoft Excel (Power Query, PivotTables, complex formulas).
Proficiency with at least one of the following tools: Power BI, Tableau, Python, or R.
Quantitative and qualitative data analysis skills; able to design a data analysis, integrate structured/unstructured sources, and apply appropriate analytic methods.
Demonstrated experience turning ambiguous questions into clear analytic plans and delivering insights that stand up to scrutiny.
Data quality mindset: hands-on experience defining rules, measuring quality, and leading remediation with business/IT partners.
Excellent communication and collaboration skills; comfortable facilitating working sessions with government SMEs and presenting to mixed technical/non-technical audiences.
Experience working in a Scrum/Agile delivery model (backlog refinement, story mapping, demo, retro).

Preferred Qualifications

Experience with multiple tools across Power BI, Tableau, Python, and R; familiarity with Stata and/or SAS is a plus.
Familiarity with Azure Synapse/Databricks/SQL Server or comparable analytics platforms; able to query data at scale.
Experience with Power BI data modeling and DAX.
Exposure to data governance and metadata/lineage tooling (e.g., Microsoft Purview) and to privacy/security controls in government contexts.
Background in program evaluation, statistical testing, causal inference, or experimental design.
Relevant certifications (e.g., Microsoft Data Analyst Associate, Azure Enterprise Data Analyst).

How We Work

Scrum-aligned: We collaborate tightly with product owners and agency stakeholders, write crisp acceptance criteria, and demo working insights every sprint.
Team-first: We seek help early, offer help often, and raise the bar through pairing, peer reviews, and shared playbooks.
Outcome driven: We focus on key metrics that matter, including quality trends, cycle time, and decision impact. We are always learning to iterate and deliver value faster.

Federal law requires AEM and its affiliates to verify identity and employment eligibility with information from your Form I-9. The E-Verify system is used.

The California Consumer Privacy Act of 2018 ("CCPA") imposes specific obligations on businesses processing personal information of California residents. Pursuant to the CCPA, AEM and its affiliates are required to provide applicants who are California residents a notice, used at or before the point of collection of such personal information, which identifies the categories of personal information that may be collected and why AEM and its affiliates collect such information. Applicants can find information about AEM's privacy policy and CCPA here.