Quick Overview
Seniority
Mid Senior
Employment type
Full Time
Work mode
Hybrid
Location
Shawnee Mission, Kansas, United States
OracleSQLSQL ServerETLSnowflakeTableauPower BIPython
Job Description
GardaWorld Security Services U.S. seeks a Data Warehouse professional to design, build, and maintain a secure, reliable data environment supporting operations, risk management, and client reporting. You will develop and optimize ETL processes, create scalable data models, and ensure data quality across multiple security and operational systems. Partnering with operations, finance, and leadership, you'll translate business needs into actionable data solutions, dashboards, and analytics. This role operates in a fast-paced, mission-driven setting with strong focus on integrity, standards, and continuous improvement.
Responsibilities
- Design, build, and maintain the enterprise data warehouse environment
- Develop, schedule, and monitor ETL workflows to integrate data from multiple security and business systems
- Create and optimize data models, schemas, and stored procedures for analytics and reporting
- Ensure data quality, integrity, and security across all warehouse objects and pipelines
- Collaborate with operations, finance, and leadership to translate requirements into data solutions and dashboards
- Develop and support BI reports and self-service analytics for internal stakeholders
- Monitor performance and capacity, tuning queries and systems for reliability and speed
- Document data structures, data flows, and standards; support audits and compliance needs
- Partner with IT and security teams to enforce access controls and protect sensitive data
- Support continuous improvement of tools, processes, and standards in a fast-paced environment
Required Skills
- Data warehousing
- SQLETL development
- Data modeling (star/snowflake schemas)
- Database administration (e.g., SQL Server, Oracle, Postgre
- SQL)
- Business intelligence/reporting tools (e.g., Power BI, Tableau)
- Stored procedures and query optimization
- Data quality and validation
- Scripting (Python or similar)
- Security and access control for data systems
Similar jobs
- BO
Associate Systems Engineer - Health Management
NewBoeing
Hazelwood, Missouri🇺🇸Hybrid25 minutes agoAgileTechnology - BO
Lead Systems Engineer
NewBoeing
Hazelwood, Missouri🇺🇸$136.8k - $185.2k/yrHybrid25 minutes agoTechnology - YU
Cyber Security JOB Training Program
NewYear Up United
Seattle, Washington🇺🇸Hybrid28 minutes agoTechnology - IT
Need Locals: Cloud Solutions Architect -- Austin, TX /Hybrid Onsite /C2C/
NewIntellisoft Technologies
Austin, TX🇺🇸On-siteYesterdayDockerMicroservicesOracle+15Technology - SG
SAP Business Objects (BOBJ) / Business Warehouse (BW) / EUNA Budget Senior Dev Support
NewSage Group
San Diego, CA🇺🇸HybridYesterdayPower BISAPTechnology - CO
Network Test Automation Engineer
NewCognowiz
Foster City, CA🇺🇸On-siteYesterdayTCP/IPBashPython+1Technology