Data Warehouse Manager

Overview

Manage, design, and optimize data warehouse solutions and ETL processes.

Key Responsibilities

• data modeling
• data governance
• etl management
• technical guidance
• documentation
• performance tuning

Tasks

-Create and optimize data models and structures for the warehouse to ensure efficient data storage and retrieval. -Ensure the accuracy, integrity, and security of data within the warehouse, establishing policies and auditing regularly. -Implement and manage Extract, Transform, and Load (ETL) processes to move data from various sources into the warehouse. -Provide technical guidance and support to team members. -Document technical designs, workflows, and best practices to facilitate knowledge sharing and maintain system documentation. -Monitor and optimize database and system performance, troubleshooting issues to ensure efficiency.

Requirements

• oracle
• sql server
• python
• adf
• aws
• bs computer

What You Bring

-5-10 years of experience -Experience with relational database design and development a plus, Oracle and SQL Server ideal. -Bachelors degree in Computer Science or related field -Familiarity with programmatic data analysis tools (e.g., Python, R) is a plus. -Experience with SSIS and Azure Data Factory -Certification in SQL, BI, or related areas (e.g., Microsoft Certified: Azure Data Engineer Associate, CBIP). -Experience with cloud-based BI and data solutions (e.g., AWS, Azure).

People Also Searched For

Benefits

-Professional Development: Tuition reimbursement and extensive internal training programs. -Time Off: Personal leave, flexible scheduling, floating holidays, and half-day Fridays. -Exceptional Retirement Plan: 2-to1- company match on up to 4% of eligible compensation (salary + bonus) and additional profit-sharing contribution. -Comprehensive Health Coverage: Low-cost medical, dental, and vision insurance options. -Financial Wellness: Student loan matching in our 401(k), and performance-based bonuses. -Family-Friendly Benefits: New Parent Leave, family building benefits, and childcare resources.

About Kimley-Horn

-Specializing in innovative solutions across diverse sectors, from transportation to energy and water. -Known for delivering complex, large-scale projects, with a focus on sustainable and efficient designs. -The company has worked on iconic infrastructure, from airports to bridges, and urban redevelopment projects. -Its team combines technical expertise with a deep commitment to customer satisfaction and project success. -The firm’s commitment to innovation and adaptability makes it a leader in a rapidly evolving industry.

Sector Specialisms