OT/ICS Control Systems Data Analyst & Dashboards

COLSA Corporation

Huntsville (AL)

On-site

USD 80,000 - 110,000

Full time

5 days 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
Dental
Vision
Life Insurance
Short-Term Disability
Long-Term Disability
401(k) with company match
Paid Time Off

Job summary

COLSA Corporation seeks a Control Systems Data Analyst to support the Army at Redstone Arsenal in Huntsville, AL. You will manage OT/ICS asset data, build validated inventories, and develop dashboards and reports for decision support.

The role requires strong data management and analytical skills, the ability to interpret technical OT/ICS information, and close collaboration with field personnel, engineers, and cybersecurity staff. Travel up to 15% may be required.

Qualifications

  • Bachelor's degree or higher with 2 years of relevant experience or an equivalent combination
  • Active Secret clearance is required
  • Experience with data cleansing, validation, reconciliation, QA, and large datasets
  • Advanced Excel proficiency (pivot tables, lookups, conditional formatting)
  • Experience with Power Query, Power Pivot, and VBA
  • Experience with SQL and relational databases
  • Experience developing reports, dashboards, queries, and visualizations
  • Ability to interpret technical documentation and manage multiple inventory packages
  • Travel up to 15% for customer site visits and assessments

Responsibilities

  • Review field-collected evidence (photos, notes, labels, displays, docs)
  • Extract and validate asset data (manufacturer, model/serial, firmware, connectivity)
  • Maintain OT baseline inventories with traceability to evidence
  • Apply naming conventions and validate data completeness
  • Analyze datasets and perform data quality assurance
  • Identify and resolve data discrepancies with stakeholders
  • Design relational data structures, data dictionaries, and queries
  • Automate data processes and inventories using Excel, Power Query, VBA
  • Build dashboards, standard reports, visualizations for decision support
  • Coordinate with field engineers, cybersecurity staff, and other stakeholders
  • Follow data security, handling, and mission requirements

Skills

Data management
Data analysis
Advanced Excel
Power Query
Power Pivot
VBA
SQL
Dashboards
Data quality
OT/ICS domain knowledge

Education

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

Tools

Power BI
Microsoft Excel
SQL Server

Job description

COLSA Corporation seeks a Control Systems Data Analyst to support the Army at Redstone Arsenal in Huntsville, AL. You will manage OT/ICS asset data, build validated inventories, and develop dashboards and reports for decision support.

The role requires strong data management and analytical skills, the ability to interpret technical OT/ICS information, and close collaboration with field personnel, engineers, and cybersecurity staff. Travel up to 15% may be 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 – Secret, Onsite
OT/ICS Control Systems Data Analyst – Secret, Onsite

COLSA • Huntsville (AL)

On-site
USD 80,000 - 120,000
Medical, Dental, Vision
401(k) with company match
Paid Time Off and Holidays
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 Analyst for Critical Infrastructure (Onsite Huntsville)
OT/ICS Analyst for Critical Infrastructure (Onsite Huntsville)

COLSA • Huntsville (AL)

On-site
USD 90,000 - 130,000
OT/ICS Control Systems Assessment Analyst
OT/ICS Control Systems Assessment Analyst

nLogic • Huntsville (AL)

On-site
USD 90,000 - 130,000
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 Corporation • Huntsville (AL)

On-site
USD 80,000 - 110,000
Medical
Dental
Vision
+5
Control Systems Data Analyst
Control Systems Data Analyst

COLSA • Huntsville (AL)

On-site
USD 80,000 - 120,000
Medical, Dental, Vision
401(k) with company match
Paid Time Off and Holidays
OT Control Systems Analyst - Huntsville, On-Site
OT Control Systems Analyst - Huntsville, On-Site

Energy Jobline ZR • Huntsville (AL)

On-site
USD 110,000 - 150,000
OT/ICS Systems Assessment Specialist
OT/ICS Systems Assessment Specialist

COLSA • Huntsville (AL)

On-site
USD 90,000 - 130,000
Medical
Dental
Vision
+3
Control Systems Data Analyst/Field Engineer
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