Data Warehouse

GardaWorld Security Services U.S. seeks a Data Warehouse professional to design, build, and maintain secure, reliable data solutions supporting security operations and risk management. In this fast paced, mission driven environment, you will develop ETL pipelines, optimize warehouse performance, and ensure data quality across operational, incident, and compliance systems. You'll partner with operations, finance, and risk teams to deliver accurate, timely reporting and analytics that guide critical decisions, uphold safety and integrity, and support nationwide security services.

Responsibilities

• Design, develop, and maintain the enterprise data warehouse environment
• Build and manage ETL pipelines to integrate data from security, operations, and finance systems
• Model data structures to support reporting, dashboards, and analytics
• Ensure data quality, validation, and reconciliation across multiple sources
• Optimize database and query performance for high volume, mission critical workloads
• Implement and enforce data security, access controls, and compliance standards
• Collaborate with operations, finance, and risk teams to define data and reporting requirements
• Develop and support BI reports and dashboards for leadership and field teams
• Document data models, ETL processes, and technical standards
• Monitor, troubleshoot, and resolve data warehouse and integration issues

Required Skills

• Data warehousing design
• SQLETL development
• Data modeling (star/snowflake schemas)
• Data integration tools (e.g., SSIS, Informatica, Talend)
• Relational databases (e.g., SQL Server, Oracle, Postgre
• SQL)
• Data quality and validation
• Performance tuning and optimization
• Reporting/BI tools (e.g., Power BI, Tableau)
• Data security and compliance