Control Systems Data Analyst

• Review field-collected evidence, including photographs, field notes, equipment labels, controller displays, screenshots, diagrams, and manufacturer documentation.
• Extract and validate technical asset data, including manufacturer, model/serial number, firmware/OS, connectivity, location, and system relationships.
• Build and maintain accurate OT baseline inventory records and ensure traceability between inventory entries and supporting evidence.
• Apply approved naming conventions and identifiers, validate completeness, and standardize data fields.
• Analyze technical datasets and perform data quality assurance to ensure accuracy and completeness.
• Identify and reconcile data discrepancies and coordinate resolutions with appropriate stakeholders.
• Design and support relational data structures, data dictionaries, validation rules, and reporting queries.
• Automate data processes and inventory workflows using Excel, Power Query, Power Pivot, and VBA.
• Build dashboards, queries, standard reports, visualizations, and decision-support products.
• Coordinate with field personnel, engineers, cybersecurity staff, and other stakeholders.
• Follow all applicable data security, handling, and mission requirements.

• One of the following combinations of education and relevant experience:
• Bachelor’s degree or higher in a related field and 5+ years of relevant experience
• Associate’s degree in a related field and 9+ years of relevant experience
• High school diploma or equivalent and 13+ years of relevant experience
• U.S. Citizenship and an Active Secret security clearance are required.
• Experience with data cleansing, validation, reconciliation, quality assurance, and large datasets.
• Advanced Excel proficiency, including pivot tables, lookups, conditional formatting, error checking, and structured data validation.
• Experience with Power Query, Power Pivot, and VBA.
• Experience with SQL and relational databases.
• Experience developing reports, dashboards, queries, and data visualizations.
• Ability to interpret technical documentation and manage multiple inventory packages.
• Experience supporting OT, ICS, FRCS, infrastructure assessments, or related technical environments.
• Working knowledge of OT/ICS control environments, including SCADA, Building Automation Systems (BAS), or similar systems.
• Ability to analyze system dependencies, infrastructure relationships, operational impacts, and technical risks.
• Strong analytical, organizational, communication, and attention-to-detail skills.
• Proficiency with Microsoft Word and PowerPoint.
• Ability to travel approximately 15% in support of customer site visits and assessment activities., * Prior experience supporting U.S. Army Materiel Command (AMC).
• Experience conducting site assessments, system inventories, validation audits, or similar technical evaluations.
• Experience with OT/ICS asset discovery, inventory, or data management activities.
• Experience analyzing or documenting OT/ICS architectures, components, dependencies, or infrastructure relationships.
• Familiarity with a range of OT/ICS technologies and environments, including SCADA, Building Automation Systems (BAS), HVAC controls, or similar control systems.

At COLSA, people are our most valuable resource and centered at our core value. We invite you to unite your talents with opportunity and be a part of our “Family of Professionals!” Learn about our employee-centric culture and benefits here: https://www.colsa.com/culture_benefits