Physical Security Systems Audit Data Analyst

Blue Star Partners LLC; Columbus (OH); On-site; USD 48,216 - 75,768; Full time

Job summary

Blue Star Partners LLC is looking for a Physical Security Systems Audit & Data Analyst in Columbus, OH. This hybrid role, requiring 4+ years of audit or data validation experience, focuses on ensuring the integrity and accuracy of physical security systems. The analyst will collaborate with various technical teams and use tools like Microsoft Excel and SiteOwl. The position offers a competitive rate of $35 – $55/hr in a contract-to-hire format, emphasizing attention to detail and problem-solving skills.

Qualifications

• 4+ years of experience in audit, assurance, data validation, or risk analysis.
• Strong analytical skills with experience reviewing large datasets.
• Exceptional attention to detail and accuracy.

Responsibilities

• Perform audits of physical security systems including access control and alarms.
• Validate data accuracy and completeness across multiple tools.
• Reconcile users and configurations between systems.

Skills

Analytical skills

Attention to detail

Problem-solving skills

Documentation skills

Tools

Microsoft Excel

SiteOwl

CCure

Avigilon

SureView

Job description

Job Title: Physical Security Systems Audit & Data Analyst
Location: Columbus, OH (Hybrid: 3 times a week Tuesday - Thursday)
Duration: 1-Year Contract-to-Hire
Rate: $35 – $55/hr (W2)
Work Authorization: Must be authorized to work in the United States now and in the future without the need for employment-based visa sponsorship. Sponsorship is not available for this position.

Position Overview

We are seeking a Physical Security Systems Audit & Data Analyst to ensure the accuracy, integrity, and ongoing quality of physical security systems and related data across the enterprise. This role is responsible for auditing physical security platforms, validating data consistency, identifying discrepancies, and supporting long-term system reliability.

This position is ideal for someone with a strong audit, assurance, or data validation background who is highly detail-oriented and enjoys identifying anomalies, reconciling data, and improving system quality. The role is not focused on regulatory compliance, but rather on ensuring physical security systems are configured correctly, data is accurate, and records are clean and defensible.

The analyst will partner closely with Physical Security Engineering, Cybersecurity, IT, Facilities, and vendors to support a mature and well-governed physical security environment.

Technologies Utilized

• SiteOwl
• CCure
• Avigilon
• SureView
• Microsoft Excel
• Microsoft Office Suite (Word, Outlook, PowerPoint)

Required Qualifications

• 4+ years of experience in audit, assurance, data validation, risk analysis, or control testing
• Strong analytical skills with experience reviewing large and complex datasets
• Demonstrated ability to identify inconsistencies, anomalies, and data quality issues
• Exceptional attention to detail and accuracy
• Experience working in structured, process-driven environments
• Ability to manage multiple review efforts simultaneously without sacrificing quality
• Strong documentation skills with the ability to clearly record findings, recommendations, and outcomes
• Advanced proficiency with Microsoft Excel and strong working knowledge of Word, Outlook, and PowerPoint
• Strong problem-solving and troubleshooting skills
• Clear and effective written and verbal communication skills

Preferred Qualifications

• Background in corporate tax audit, internal audit, financial audit, or assurance functions
• Experience performing reconciliations between systems, applications, or databases
• Familiarity with physical security systems, access control concepts, or cybersecurity fundamentals
• Experience working with technologies such as SiteOwl, CCure, Avigilon, or SureView
• Exposure to IT systems, identity/access management, or operational monitoring environments

Key Responsibilities

System Audits & Data Validation

• Perform detailed audits of physical security systems including access control, video management, and alarm platforms
• Validate data accuracy and completeness across multiple physical security tools and systems of record
• Reconcile users, permissions, devices, alarms, and configuration data between upstream and downstream systems
• Identify discrepancies, misconfigurations, orphaned records, outdated entries, and systemic data issues

Data Integrity & Governance

• Ensure physical security systems remain clean, consistent, and trustworthy through recurring review and validation
• Verify that system configurations and data align with established internal standards and approved designs
• Track and document findings, corrections, and validation outcomes to support long-term system reliability

Issue Analysis & Remediation Support

• Analyze root causes of data inconsistencies and recurring errors
• Work with Physical Security Engineering, Cybersecurity, IT, Facilities, and vendors to resolve identified issues
• Confirm corrective actions are accurately implemented and sustained over time

Process & Quality Improvement

• Identify patterns, trends, and systemic weaknesses in system data or configurations
• Support improvements to processes that reduce manual error, improve repeatability, and enhance auditability
• Help develop structured review routines, validation checklists, and standard operating procedures

Reporting & Communication

• Prepare clear, concise summaries of findings, discrepancies, trends, and corrective actions for internal teams and leadership
• Translate technical system information into understandable observations and recommendations
• Communicate issues in a factual, evidence-based manner with clarity and precision

Learning & Technical Development

• Develop a working knowledge of physical security technologies, system architecture, and data flows through training and hands-on experience
• Learn how physical security tools integrate with cybersecurity platforms, identity systems, and operational monitoring processes

Key Attributes for Success

• Meticulous, methodical, and highly detail-oriented
• Comfortable questioning data, validating assumptions, and investigating inconsistencies
• Strong sense of ownership for data quality and system accuracy
• Organized, disciplined, and process-driven
• Able to work independently while collaborating effectively with technical and business teams
• Strong curiosity and willingness to learn new technologies and systems

Success in This Role

• Physical security systems and records remain accurate, clean, and reliable
• Data discrepancies and configuration issues are identified and resolved proactively
• Internal teams have greater confidence in the integrity of system data and reporting
• Processes become more repeatable, auditable, and less prone to error