Data Analyst

Zachary Piper Solutions is seeking a Data Analyst to support a Federal IT Consulting Firm for a fully onsite role in Falls Church, VA. The Data Analyst will support enterprise data warehousing, metadata quality, and standardized data element definitions across the data ecosystem for a large DOD customer. The Data Analyst ensures accuracy, traceability, and consistency of data elements across multiple systems and domains.

Responsibilities of the Data Analyst:

• Support the baseline data inventory by through in-person or remote session to collect metadata—including system details, lineage, access controls, and business definitions.
• Support analysis of enterprise data warehouse structures, mapping data fields, validating data lineage, and reviewing transformation logic via virtual collaboration tools.
• Develop and maintain standardized data element definitions, including metadata fields, classifications, reference values, and usage context aligned with DHA, DOW, and NIST standards.
• Maintain and update the enterprise data dictionary and definition catalogs.
• Conduct metadata quality checks (completeness, accuracy, alignment) and work with stakeholders to resolve gaps.
• Assist in preparing metadata, definitions, and documentation for onboarding into the interim centralized repository, ensuring consistency with folder standards, taxonomies, and metadata fields.
• Contribute to governance artifacts, including RACI matrices, workflows, and metadata framework deliverables.
• Produce documentation including inventory outputs, definition libraries, reports, decision logs, and briefings for DHA stakeholders.
• Ensure all deliverables are version controlled, auditable, and delivered through DHA approved remote tools.

Qualifications for the Data Analyst:

• 8+ years of experience in data analysis, metadata management, data warehouse or analytics
• Experience working with enterprise data warehouses, relational structures, and standardized data definitions.
• Strong understanding of metadata standards, data dictionaries, and governance frameworks.
• Experience communicating and coordinating with Government stakeholders in in-person and remote environments and excellent communication skills suited for distributed stakeholders.
• Experience with Jira and other DHA approved project tools. 
• U.S. Citizenship required; eligibility for security clearance; active DoD security clearance preferred.  
• Desired Skills:
  • Bachelor’s degree in Information Systems, Business Administration, Data Management, or related field.
  • Experience working within federal government settings or supporting federal data initiatives.
  • Experience with metadata crosswalks, validation processes, or catalog federation activities. 
  • Data analytics or governance certifications (CDMP, PL300/DA100, etc.).
  • Cloud certifications (AWS, Azure, GCP) beneficial but not required.
  • Agile certifications (Scrum, SAFe, Agile PM). 

Compensation for the Data Analyst:

• Salary Range: $100,000 - $130,000 *depending on experience*
• Comprehensive Benefits: Cigna Medical, Dental, Vision, 401k Plan, PTO, Holidays, Sick Leave if required by law

#LI-MS1

#LI-ONSITE

Keywords: enterprise data warehousing, enterprise data warehouse analysis, metadata management, metadata governance, metadata standards, data inventory, baseline data inventory, metadata collection, data lineage, data traceability, data accuracy, data consistency, relational databases, relational data structures, data mapping, field mapping, data transformation logic, ETL validation, standardized data element definitions, data element standardization, metadata fields, data classifications, reference data management, business definitions, enterprise data dictionary, definition catalogs, metadata repository, centralized repository onboarding, taxonomy alignment, folder standards, metadata quality checks, data quality assessment, completeness validation, accuracy validation, alignment validation, metadata crosswalks, catalog federation, governance frameworks, data governance artifacts, RACI matrices, governance workflows, metadata frameworks, configuration management, version control, auditability, documentation management, inventory reporting, definition libraries, decision logs, stakeholder briefings, virtual collaboration tools, remote stakeholder coordination, Government stakeholder engagement, DHA standards, DOD data standards, DOW standards, NIST standards, information assurance compliance, Jira, Agile methodology, Scrum, SAFe, Agile PM, enterprise analytics, data analytics, SQL, data validation, requirements gathering, business process analysis, security clearance eligibility, active DoD clearance, federal data initiatives, cloud platforms AWS Azure GCP, data governance certification CDMP, Microsoft PL300 DA100, distributed team communication, cross-functional coordination, data lifecycle management