Control Systems Data Analyst

COLSA

Huntsville (AL)

On-site

USD 90,000 - 120,000

Full time

38 hours 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 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 our Army customer at Redstone Arsenal in Huntsville, AL. This role will support the management and analysis of Operational Technology (OT) and Industrial Control System (ICS) asset data across Army facilities, including building and maintaining accurate, validated asset inventories and developing reports, dashboards, and other decision-support products. The position requires strong data management and analytical skills, attention to detail, and the ability to interpret technical information within OT/ICS environments.

Duties and Responsibilities
  • Review field-collected evidence, including photographs, field notes, equipment labels, controller displays, screenshots, diagrams, and manufacturer documentation.
  • Extract and validate technical asset data, including manufacturer, model/serial number, firmware/OS, connectivity, location, and system relationships.
  • Build and maintain accurate OT baseline inventory records and ensure traceability between inventory entries and supporting evidence.
  • Apply approved naming conventions and identifiers, validate completeness, and standardize data fields.
  • Analyze technical datasets and perform data quality assurance to ensure accuracy and completeness.
  • Identify and reconcile data discrepancies and coordinate 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.
  • Build dashboards, queries, standard reports, visualizations, and decision-support products.
  • Coordinate with field personnel, engineers, cybersecurity staff, and other stakeholders.
  • Follow all applicable data security, handling, and mission requirements.

At COLSA, people are our most valuable resource and centered at our core value. We invite you to unite your talents with opportunity and be a part of our “Family of Professionals!” Learn about our employee-centric culture and benefits here: https://www.colsa.com/culture_benefits

Required Experience
  • One of the following combinations of education and relevant experience:
    • Bachelor’s degree or higher in a related field and 2 years of relevant experience
    • Associate’s degree in a related field and 6 years of relevant experience
    • High school diploma or equivalent and 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 proficiency, 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, 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 PowerPoint.
  • Ability to travel approximately 15% in support of customer site visits and assessment activities.
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 and environments, including SCADA, Building Automation Systems (BAS), HVAC controls, or similar control systems.

Applicant selected will be subject to a government security investigation and must meet eligibility requirements for access to classified information. COLSA Corporation is an Equal Opportunity Employer, Minorities/Females/Veterans/Disabled. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin.

Salary Type

Annually

The salary range, if referenced, represents a good faith estimate. COLSA considers various factors when determining base salary offers, but not limited to, location, the role, function and associated responsibilities, a candidate’s particular combination of education, knowledge, skills, competencies, and experience, as well as contract-specific affordability and organizational requirements.

  • COLSA offers a comprehensive and customizeable benefits program which includes Medical, Dental, Vision, Life Insurance, Short-Term Disability, Long-Term Disability, Accidental Death & Dismemberment, Supplemental Income Protection Programs, 401(k) with company match, Flexible Spending Accounts, Employee Assistance Program, Education & Certification Reimbursement, Employee Discount Program, Paid Time Off and Holidays.

This position will be posted for a minimum of 3 business days. If a candidate has not been selected at that time, it will continue to be posted until a suitable candidate is selected or the position is closed.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Control Systems Data Analyst
Control Systems Data Analyst

COLSA Corporation • Huntsville (AL)

On-site
USD 80,000 - 110,000
Medical
Dental
Vision
+5
Operational Technology (OT) / Industrial Control Systems (ICS) Analyst Huntsville, AL
Operational Technology (OT) / Industrial Control Systems (ICS) Analyst Huntsville, AL

Colsa • Huntsville (AL)

On-site
USD 95,000 - 150,000
OT/ICS Systems Assessment Analyst – Critical Infrastructure
OT/ICS Systems Assessment Analyst – Critical Infrastructure

COLSA • Huntsville (AL)

On-site
USD 90,000 - 120,000
Medical insurance
Dental insurance
Vision insurance
+2
Operational Technology (OT) / Industrial Control Systems (ICS) Analyst
Operational Technology (OT) / Industrial Control Systems (ICS) Analyst

COLSA • Huntsville (AL)

On-site
USD 100,000 - 140,000
OT/ICS Systems Assessment Analyst – Critical Infrastructure
OT/ICS Systems Assessment Analyst – Critical Infrastructure

COLSA • Huntsville (AL)

On-site
USD 90,000 - 130,000
Medical
Dental
Vision
+3
Systems Integration Engineer, Senior
Systems Integration Engineer, Senior

COLSA • Warner Robins (GA)

On-site
USD 110,000 - 150,000
Medical
Dental
Vision
+2
Systems Integration Engineer, Senior
Systems Integration Engineer, Senior

COLSA • Warner Robins (GA)

On-site
USD 120,000 - 190,000
Cybersecurity Analyst (MSIC)
Cybersecurity Analyst (MSIC)

COLSA • Huntsville (AL)

On-site
USD 110,000 - 140,000
Medical Insurance
Dental Insurance
Vision Insurance
+1
Senior Cybersecurity Analyst (RMF/ISSO Lead)
Senior Cybersecurity Analyst (RMF/ISSO Lead)

Colsa • Huntsville (AL)

On-site
USD 120,000 - 160,000
Cybersecurity Analyst (MSIC) Huntsville, AL
Cybersecurity Analyst (MSIC) Huntsville, AL

Colsa • Huntsville (AL)

On-site
USD 110,000 - 140,000