Senior Data Analyst

Location : Dahlgren, VA

Clearance : Secret

Position Type : Full-Time

AERMOR is seeking a Senior Data Analyst to provide expert-level data analysis, design, and integration support for enterprise data warehousing and business intelligence initiatives. The individual will develop data models, define requirements, and design integration frameworks to support analytics and decision-making processes within Working Capital Fund, Enterprise Resource Planning (ERP), financial, and human resources systems. This position requires deep technical expertise in SQL, data modeling, data validation, and database performance optimization to ensure efficient and reliable data management in complex DoD and enterprise environments.

Responsibilities :

• Perform analysis, design, and development activities related to data warehousing, data integration, and business intelligence systems.
• Develop logical and physical data models to support system integration, analytics, and enterprise reporting requirements.
• Define and document data requirements, interface specifications, and database performance criteria.
• Create and maintain structured query language (SQL) scripts for data extraction, transformation, and validation.
• Design and implement processes for data loading, performance tuning, and data validation.
• Conduct data analysis to ensure quality, accuracy, and completeness of enterprise data.
• Support data conversion activities, including migration from legacy systems to modern platforms.
• Collaborate with system architects, database administrators, and functional stakeholders to align data solutions with operational needs.
• Provide expertise in data knowledge acquisition, metadata management, and business rules documentation.
• Develop on-line queries, reports, and dashboards to support data-driven decision-making.
• Participate in the design and development of data governance and standardization practices.

Qualifications :