Senior Analyst (Modeling & Simulation)

WILLCOR Inc; Crystal City (TX); On-site; USD 120,000 - 160,000; Full time

Job summary

WILLCOR Inc. in Crystal City, MD is seeking a Senior Analyst (Modeling & Simulation) to support an advanced M&S lab.

You will configure Windows systems, manage SQL Server 2019, perform GIS analyses with ArcGIS Pro, and develop Python scripts to automate tasks and deliver data-driven insights. Ideal candidates have 8+ years in modeling, lab support, and analytics, with expert Excel/VBA skills and SSRS reporting.

Qualifications

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

Responsibilities

• M&S Lab Support: configure and maintain Windows 10/11 systems.
• Install updates and configure software to support M&S activities.
• Develop lab layouts with Sketch-Up to optimize space for performance.
• Specify, install, and configure Windows-based PCs to meet lab needs.
• Manage SQL Server 2019 and SSRS reporting; ensure data integrity and security.
• Develop Python scripts to automate GIS tasks and data processing.
• Conduct data analysis, V&V, and present insights to stakeholders.
• Collaborate with technical and non-technical teams to communicate project status.

Skills

Windows administration

Data analysis

V&V

Communication & presentation

Lab support

Education

Bachelor’s degree in Computer Science, Data Science, Engineering, or related field

Tools

Windows 10/11 administration

Microsoft SQL Server 2019

Excel (advanced)

VBA coding

SSRS

Python

ArcGIS Pro

Job description

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 2019 to 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 in Microsoft 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