Data Warehouse

GardaWorld Security Services U.S. is seeking a Data Warehouse professional to design, maintain, and optimize our security data environment. In this role, you will build and support data pipelines, integrate data from multiple operational and security systems, and ensure accurate, timely reporting for leaders across the organization. You will collaborate with IT, operations, and risk teams to develop dashboards and analytics that improve safety, staffing, and incident response. This position thrives in a fast-paced, mission-driven culture and requires strong SQL, ETL, and data modeling skills with high attention to security and data integrity.

Responsibilities

• Design, implement, and maintain data warehouse structures to support analytics and reporting
• Develop and manage ETL processes to integrate data from multiple security and operational systems
• Ensure data quality, consistency, and integrity across all warehouse layers
• Implement and monitor data security, access controls, and compliance standards
• Optimize database performance, including indexing, partitioning, and query tuning
• Collaborate with operations, risk, and IT teams to define data requirements and reporting needs
• Build and support BI dashboards and reports for leadership and field teams
• Document data models, data flows, and technical procedures
• Support incident analysis and operational decision-making through reliable data access
• Troubleshoot data issues and drive continuous improvement of data warehouse processes

Required Skills

• Data warehousing
• SQLETL development
• Data modeling (star/snowflake)
• Database administration (e.g., SQL Server, Oracle, Snowflake)
• Business intelligence/reporting tools
• Data security and access control
• Performance tuning and optimization
• Data quality and validation
• Scripting (Python, Shell, or similar)