Senior Analyst (Modeling & Simulation)

Job Title: Senior Analyst (Modeling & Simulation)
Location: Crystal City, MD
Required Clearance: CPB BI (DHS)
Salary: Negotiable

Job Description:
We are seeking an experienced and highly skilled Senior Analyst (Modeling & Simulation) to support a cutting-edge Modeling & Simulation (M&S) lab. The ideal candidate will have strong expertise in Windows administration, SQL Server management, GIS analysis, and coding in Python and VBA. This position involves configuring and maintaining M&S lab systems, conducting data analysis, and developing insightful reports and presentations to support decision-making and project execution.

Key Responsibilities: 

• M&S Lab Support: 
• Provide technical support for the M&S lab, including configuring and maintaining Windows 10/11 systems.  
• Perform software installations, updates, and system configurations to support M&S activities.  
• Develop and implement lab layouts using Sketch-Up to plan and optimize lab space for performance and functionality.
• Specify, install, and configure Windows-based PCs to meet operational and simulation requirements.  
• Troubleshoot and resolve hardware and software issues in the lab environment.
• Install, configure, and manage Microsoft SQL Server 2019to support data analysis and reporting needs.  
• Develop and maintain SQL Server Reporting Services (SSRS) using Microsoft Report Builder to create detailed and insightful reports.  
• Ensure the integrity and security of the SQL database environment.  
• Develop complex Excel models and automate processes using VBA.  
• Create VBA code that integrates with MS SQL Server to enable seamless data processing and analysis.  
• Provide advanced Excel expertise to support data modeling and decision-making processes.  
• Utilize ESRI ArcGIS Pro 3.2+to perform GIS analyses and visualizations.  
• Develop Python scripts to automate GIS tasks and enhance geospatial data processing capabilities.  
• Conduct spatial analysis to support simulation and modeling projects.
• Perform Verification & Validation (V&V) analyses to ensure simulation models accurately reflect real-world scenarios.  
• Conduct data analysis to identify trends, patterns, and performance gaps.  
• Provide actionable insights to improve simulation accuracy and efficiency.  
• Develop and deliver high-quality presentations to stakeholders, explaining complex analytical findings in a clear and concise manner.
• Work closely with technical and non-technical teams to communicate project status, insights, and recommendations.  

Qualifications: 

• Bachelor’s degree in Computer Science, Data Science, Engineering, or a related field.  
• 8+ years of experience in modeling and simulation, lab support, and analytical roles.  
• Proficiency in Windows administration, configuration, and software installation.  
• Expertise inMicrosoft SQL Server(installation, setup, management, and reporting).  
• Advanced Excel skills, including complex formula creation and VBA coding.  
• Strong Python scripting skills and experience with ArcGIS Pro.  
• Demonstrated ability to conduct complex data analysis and present findings effectively.  

Preferred: 

• Master’s degree in a related field.  
• Experience with Sketch-Up for lab layout and planning.  
• Background in defense, aerospace, or government projects.  
• Strong understanding of modeling and simulation methodologies.  

Skills: 

• Windows 10/11 administration and hardware configuration  
• Microsoft SQL Server 2019 setup and management  
• Excel (advanced) and VBA coding  
• SQL Server Reporting Services (SSRS)  
• Python and ArcGIS Pro  
• Data analysis and V&V  
• Strong communication and presentation skills