COLSA Corporation is hiring a Control Systems Data Analyst to support an Army customer at Redstone Arsenal in Huntsville, AL (onsite). In this role, you will help keep validated OT/ICS asset inventories up to date by extracting technical data from field evidence, performing data quality assurance, and delivering dashboards and decision-support reporting to stakeholders.
What you’ll do
- Review field-collected evidence such as photographs, field notes, equipment labels, controller displays, screenshots, diagrams, and manufacturer documentation.
- Extract and validate technical asset details, including manufacturer, model and serial number, firmware or OS, connectivity, location, and system relationships.
- Build and maintain accurate OT baseline inventory records with traceability back to supporting evidence.
- Apply approved naming conventions and identifiers, validate data completeness, and standardize data fields.
- Analyze technical datasets and conduct data quality assurance to ensure accuracy and completeness.
- Identify and reconcile data discrepancies, coordinating 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.
- Create dashboards, queries, standard reports, visualizations, and decision-support products.
- Coordinate with field personnel, engineers, cybersecurity staff, and other stakeholders while following all applicable data security, handling, and mission requirements.
What you bring
- Education and relevant experience must match one of the following:
- Bachelor’s degree or higher in a related field plus 2 years of relevant experience
- Associate’s degree in a related field plus 6 years of relevant experience
- High school diploma or equivalent plus 10 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 skills, 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 and 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 Microsoft PowerPoint.
- Ability to travel approximately 15% to support customer site visits and assessment activities.
Tools and technologies
Excel, Power Query, Power Pivot, VBA, SQL, relational databases, SCADA, Building Automation Systems (BAS), Microsoft Word, Microsoft PowerPoint
Preferred qualifications
- 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, including SCADA, BAS, HVAC controls, or similar control systems.