Data Warehouse Engineer

GardaWorld Security Services U.S. is seeking a Data Warehouse professional to build and maintain secure, scalable data solutions supporting security, operations, and risk management analytics. In this role, you will design and optimize data models, develop robust ETL pipelines, and ensure the integrity and availability of critical operational data. You will collaborate with security, operations, and finance teams to translate reporting and analytics needs into reliable data structures. Ideal candidates bring strong SQL, data warehousing, and performance tuning skills, with a commitment to data accuracy, security, and continuous improvement in a fast-paced, mission-driven environment.

Responsibilities

• Design, implement, and maintain data warehouse structures to support reporting and analytics
• Develop, schedule, and monitor ETL processes to integrate data from multiple operational systems
• Collaborate with security, operations, and finance teams to define data and reporting requirements
• Ensure data quality, integrity, and consistency through validation and monitoring
• Optimize SQL queries and data models for performance and scalability
• Implement and maintain data security, access controls, and governance standards
• Support business intelligence and dashboard solutions used for security and operational insights
• Document data models, ETL workflows, and technical standards
• Troubleshoot data issues and drive root-cause analysis and resolution
• Continuously improve warehouse architecture, tools, and processes

Required Skills

• Data warehousing design
• SQLETL development
• Data modeling (star/snowflake)
• Relational databases (e.g., SQL Server, Oracle, Postgres)
• Data quality and validation
• Performance tuning and optimization
• Business intelligence/reporting tools
• Data security and access control
• Documentation and technical specifications