OT/ICS Control Systems Data Analyst – Secret, Onsite

COLSA

Huntsville (AL)

On-site

USD 80,000 - 120,000

Full time

3 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Medical, Dental, Vision
401(k) with company match
Paid Time Off and Holidays

Job summary

COLSA is seeking a Control Systems Data Analyst to support our Army customer at Redstone Arsenal in Huntsville, AL. The role focuses on managing OT/ICS asset data, validating inventories, and developing reports and dashboards to support decision-making.

The ideal candidate will have strong data management skills, experience with Excel, Power Query, Power Pivot, VBA, and SQL, and the ability to interpret technical information within OT/ICS environments. Secure clearance is required.

Qualifications

  • 􀁲 Bachelor’s degree or higher plus 2 years of relevant experience, or 2nd option per listed combinations.
  • 􀁲 U.S. Citizenship and an Active Secret security clearance required.
  • 􀁲 Experience with data cleansing, validation, reconciliation, QA, and large datasets.
  • 􀁲 Advanced Excel proficiency with pivots, lookups, conditional formatting, and data validation.
  • 􀁲 Experience with Power Query, Power Pivot, and VBA; SQL and relational databases.
  • 􀁲 Experience creating reports, dashboards, queries, and data visualizations.

Responsibilities

  • Review field-collected evidence: photos, notes, labels, diagrams, docs.
  • Extract and validate asset data: manufacturer, model, serial, firmware, connectivity.
  • Maintain OT baseline inventory; ensure traceability with evidence.
  • Apply naming conventions; validate completeness; standardize fields.
  • Analyze datasets; perform data QA for accuracy and completeness.
  • Identify data discrepancies; coordinate resolutions with stakeholders.
  • Design data structures, dictionaries, validation rules, and queries.
  • Automate data processes and inventories with Excel, PQ, PV, VBA.
  • Build dashboards, reports, and decision-support products.
  • Coordinate with field personnel and engineers.
  • Follow data security and mission requirements.

Skills

Advanced Excel
Power Query
Power Pivot
VBA
SQL
Data validation
Data quality assurance
Dashboards
OT/ICS knowledge
Security clearance

Education

Bachelor's degree
Associate degree
High school diploma

Tools

SQL databases
Power BI
Microsoft Word
Microsoft PowerPoint

Job description

COLSA is seeking a Control Systems Data Analyst to support our Army customer at Redstone Arsenal in Huntsville, AL. The role focuses on managing OT/ICS asset data, validating inventories, and developing reports and dashboards to support decision-making.

The ideal candidate will have strong data management skills, experience with Excel, Power Query, Power Pivot, VBA, and SQL, and the ability to interpret technical information within OT/ICS environments. Secure clearance is 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
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
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
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
Control Systems Data Analyst
Control Systems Data Analyst

COLSA Corporation • Huntsville (AL)

On-site
USD 80,000 - 110,000
Medical
Dental
Vision
+5
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
OT/ICS Control Systems Assessment Analyst
OT/ICS Control Systems Assessment Analyst

nLogic • Huntsville (AL)

On-site
USD 90,000 - 130,000
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
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