DataJobs.io
← Back to all jobs

Job Description

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.

Similar Jobs