Control Systems Data Analyst

COLSA Corporation

Huntsville (AL)

Sur place

USD 80 000 - 110 000

Plein temps

Il y a 5 jours
Soyez parmi les premiers à postuler

Obtenez une réponse de cet employeur

Votre CV et votre lettre de motivation, adaptés exactement à ce que l’employeur recherche.

Passez les filtres ATS

Avantages offerts par ce poste

Medical
Dental
Vision
Life Insurance
Short-Term Disability
Long-Term Disability
401(k) with company match
Paid Time Off

Résumé du poste

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

Responsabilités

  • 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

Connaissances

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

Formation

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

Outils

Power BI
Microsoft Excel
SQL Server

Description du poste

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.

  • 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
  • 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.

Obtenez votre examen gratuit et confidentiel de votre CV.

ou faites glisser et déposez votre fichier ici.

Similar jobs

Postes similaires à comparer

Control Systems Data Analyst
Control Systems Data Analyst

COLSA • Huntsville (AL)

Sur place
USD 80 000 - 120 000
Medical, Dental, Vision
401(k) with company match
Paid Time Off and Holidays
Operational Technology (OT) / Industrial Control Systems (ICS) Analyst
Operational Technology (OT) / Industrial Control Systems (ICS) Analyst

COLSA • Huntsville (AL)

Sur place
USD 90 000 - 130 000
Operational Technology (OT) / Industrial Control Systems (ICS) Analyst Huntsville, AL
Operational Technology (OT) / Industrial Control Systems (ICS) Analyst Huntsville, AL

Colsa • Huntsville (AL)

Sur place
USD 95 000 - 150 000
OT/ICS Systems Assessment Analyst – Critical Infrastructure Huntsville, AL
OT/ICS Systems Assessment Analyst – Critical Infrastructure Huntsville, AL

Colsa • Huntsville (AL)

Sur place
USD 90 000 - 130 000
Medical
Dental
Vision
+3
OT/ICS Systems Assessment Analyst – Critical Infrastructure
OT/ICS Systems Assessment Analyst – Critical Infrastructure

COLSA • Huntsville (AL)

Sur place
USD 90 000 - 130 000
Medical
Dental
Vision
+3
OT/ICS Systems Assessment Analyst – Critical Infrastructure
OT/ICS Systems Assessment Analyst – Critical Infrastructure

COLSA • Huntsville (AL)

Sur place
USD 90 000 - 120 000
Medical insurance
Dental insurance
Vision insurance
+2
OT/ICS Systems Assessment Specialist
OT/ICS Systems Assessment Specialist

Colsa • Huntsville (AL)

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

COLSA • Warner Robins (GA)

Sur place
USD 110 000 - 150 000
Medical
Dental
Vision
+2
Systems Integration Engineer, Senior
Systems Integration Engineer, Senior

COLSA • Warner Robins (GA)

Sur place
USD 120 000 - 190 000
Senior Cybersecurity Analyst (RMF/ISSO Lead)
Senior Cybersecurity Analyst (RMF/ISSO Lead)

Colsa • Huntsville (AL)

Sur place
USD 120 000 - 160 000