OT/ICS Data Analyst: Asset Inventory & Dashboards

COLSA

Huntsville (AL)

On-site

USD 90,000 - 120,000

Full time

37 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Medical and Dental Benefits
401(k) with company match
Paid Time Off

Job summary

COLSA is seeking a Control Systems Data Analyst to support Army OT/ICS assets at Redstone Arsenal, Huntsville, AL. You will manage asset inventories, validate data, and develop dashboards and reports for decision support in OT/ICS environments.

The role requires strong data management, analytical skills, and ability to interpret technical documentation. US citizenship and Active Secret clearance are required.

Qualifications

  • Bachelor’s degree or higher in a related field with 2+ years of relevant experience or equivalent combinations.
  • Active Secret security clearance required.
  • Experience with data cleansing, validation, reconciliation, quality assurance, and large datasets.
  • Advanced Excel proficiency including pivot tables, lookups, conditional formatting, error checking, and 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.
  • OT/ICS environments experience including SCADA or BAS.

Responsibilities

  • Review field-collected evidence and manufacturer documentation.
  • Extract and validate asset data including model/serial, firmware/OS, connectivity, and relationships.
  • Build and maintain OT inventory records with traceability to evidence.
  • Apply naming conventions and standardize data fields.
  • Analyze datasets and perform data quality assurance.
  • Identify and reconcile data discrepancies with stakeholders.
  • Design data structures, dictionaries, and validation rules.
  • Automate data processes and inventory workflows using Excel, Power Query, Power Pivot, and VBA.
  • Build dashboards, queries, reports, and visualizations for decision support.
  • Coordinate with field personnel, engineers, cybersecurity staff, and other stakeholders.
  • Follow data security and mission requirements.

Skills

Data Analysis
Excel
Power Query
Power Pivot
VBA
SQL
Data Cleansing
Dashboards
Reporting
OT/ICS Knowledge
SCADA
Communication
Attention to Detail

Education

Bachelor’s degree or higher in a related field
Associate’s degree in a related field
High school diploma or equivalent

Tools

Microsoft Excel
Power Query
Power Pivot
VBA
SQL

Job description

COLSA is seeking a Control Systems Data Analyst to support Army OT/ICS assets at Redstone Arsenal, Huntsville, AL. You will manage asset inventories, validate data, and develop dashboards and reports for decision support in OT/ICS environments.

The role requires strong data management, analytical skills, and ability to interpret technical documentation. US citizenship and Active Secret clearance are required.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

OT/ICS Control Systems Data Analyst & Dashboards
OT/ICS Control Systems Data Analyst & Dashboards

COLSA Corporation • Huntsville (AL)

On-site
USD 80,000 - 110,000
Medical
Dental
Vision
+5
Secret-Cleared OT/ICS Systems Assessment Analyst
Secret-Cleared OT/ICS Systems Assessment Analyst

COLSA • Huntsville (AL)

On-site
USD 90,000 - 120,000
Medical insurance
Dental insurance
Vision insurance
+2
Control Systems Data Analyst
Control Systems Data Analyst

COLSA • Huntsville (AL)

On-site
USD 90,000 - 120,000
Medical and Dental Benefits
401(k) with company match
Paid Time Off
Control Systems Data Analyst
Control Systems Data Analyst

COLSA Corporation • Huntsville (AL)

On-site
USD 80,000 - 110,000
Medical
Dental
Vision
+5
OT/ICS Control Systems Assessment Analyst
OT/ICS Control Systems Assessment Analyst

nLogic • Huntsville (AL)

On-site
USD 90,000 - 130,000
Mission-Critical Control Systems Data Analyst–Field Engineer
Mission-Critical Control Systems Data Analyst–Field Engineer

Oasys, Inc. • Huntsville (AL)

On-site
USD 65,000 - 90,000
Healthcare benefits
401K with matching
Tuition reimbursement
+2
OT/ICS Systems Assessment Specialist
OT/ICS Systems Assessment Specialist

COLSA • Huntsville (AL)

On-site
USD 90,000 - 130,000
Medical
Dental
Vision
+3
OT/ICS Systems & Infrastructure Analyst
OT/ICS Systems & Infrastructure Analyst

COLSA • Huntsville (AL)

On-site
USD 100,000 - 140,000
Senior OT/ICS Analyst — Critical Infrastructure
Senior OT/ICS Analyst — Critical Infrastructure

Colsa • Huntsville (AL)

On-site
USD 95,000 - 150,000
On-Site OT Control Systems Analyst - Secret Clearance
On-Site OT Control Systems Analyst - Secret Clearance

IronMountain Solutions • Huntsville (AL)

On-site
USD 90,000 - 130,000