Data Warehouse Manager at Kimley-Horn in Raleigh, NC | Kablio

Role

Description

etl management

data integrity

performance tuning

technical guidance

documentation

data modeling

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

Requirements

sql certification

ssis

azure data factory

python

oracle

aws

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

Benefits

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

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found

Company

Overview

1967 Founded

Year Established

The company was established in 1967, marking the beginning of its journey to become a leading name in planning and engineering.

Top Ranked

Service Excellence Ranking

The company is consistently recognized as one of the top engineering firms in the U.S. for its exceptional service quality.

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.

Culture + Values

Honesty, integrity and ethics
Exceptional client service
High expectations
Sharing and caring
Sustained profitability
Core purpose: provide an environment for our people to flourish
Slogan: "Expect More and Experience Better"

Environment + Sustainability

100% clean energy

Achieved by Port of Virginia

Supported the Port of Virginia in achieving 100% clean energy use by 2024, surpassing its 2040 net-zero target.

10+ Years Experience

Sustainability initiatives expertise

Over 10 years of experience in supporting zero-emission vehicle infrastructure with thousands of stations planned and permitted.

Tracking and reporting firm-wide GHG emissions (Scope 1, 2, and 3) in Corporate Responsibility Report
Operating initiatives: green leasing, green purchasing, fleet energy-efficiency, electronic review, virtual meetings, regional Sustainability Champions coordinating recycling/composting and cleanup/tree-planting activities
Client services include measuring emissions baselines, implementing GHG mitigation and decarbonization strategies, life cycle assessments, EPD use, net-zero and carbon-neutral planning
Utilize green checklists for office site selection (efficiency, transit/EV/bike access) and procurement (recycled/remanufactured products, end-of-life management)

Inclusion & Diversity

Fortune Awards

Consecutive Recognition as Best Workplaces for Women

Recognized by Fortune as one of the Best Workplaces for Women annually from 2017 to 2023.

CREW Catalyst

Award Recognition

Received the CREW Catalyst award in 2021 for commitment to diversity, equity, and inclusion.

Recruit diverse workforce, reduce unconscious bias, fund STEM volunteer activities for underrepresented groups, support transparency and report metrics.
D&I Committee comprised of HR director, recruiting lead, Board rep, at‑large member, plus seven regional reps.
Support ERGs: Black Kimley‑Horn Network, KHAPI (Asian Pacific Islander), Military KHonnections, Pride KHonnect, Unidos @ KH, Women @ KH.
Strategic goal: recruit, mentor, develop and retain diverse staff at all levels; metrics tracked and reported.
DEI training offered; inclusive environment promoting emotional safety, respect and authenticity.
Gender outcomes: Woman‑focused awards and ERG; Fortune recognition Best Workplaces for Women every year since 2017.

Articles

Careers – Join Our Team

Services – Markets

Client Service – What Makes Us Different

Role

Description

etl management

data integrity

performance tuning

technical guidance

documentation

data modeling

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

Requirements

sql certification

ssis

azure data factory

python

oracle

aws

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

Benefits

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

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found

Company

Overview

1967 Founded

Year Established

The company was established in 1967, marking the beginning of its journey to become a leading name in planning and engineering.

Top Ranked

Service Excellence Ranking

The company is consistently recognized as one of the top engineering firms in the U.S. for its exceptional service quality.

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.

Culture + Values

Honesty, integrity and ethics
Exceptional client service
High expectations
Sharing and caring
Sustained profitability
Core purpose: provide an environment for our people to flourish
Slogan: "Expect More and Experience Better"

Environment + Sustainability

100% clean energy

Achieved by Port of Virginia

Supported the Port of Virginia in achieving 100% clean energy use by 2024, surpassing its 2040 net-zero target.

10+ Years Experience

Sustainability initiatives expertise

Over 10 years of experience in supporting zero-emission vehicle infrastructure with thousands of stations planned and permitted.

Tracking and reporting firm-wide GHG emissions (Scope 1, 2, and 3) in Corporate Responsibility Report
Operating initiatives: green leasing, green purchasing, fleet energy-efficiency, electronic review, virtual meetings, regional Sustainability Champions coordinating recycling/composting and cleanup/tree-planting activities
Client services include measuring emissions baselines, implementing GHG mitigation and decarbonization strategies, life cycle assessments, EPD use, net-zero and carbon-neutral planning
Utilize green checklists for office site selection (efficiency, transit/EV/bike access) and procurement (recycled/remanufactured products, end-of-life management)

Inclusion & Diversity

Fortune Awards

Consecutive Recognition as Best Workplaces for Women

Recognized by Fortune as one of the Best Workplaces for Women annually from 2017 to 2023.

CREW Catalyst

Award Recognition

Received the CREW Catalyst award in 2021 for commitment to diversity, equity, and inclusion.

Recruit diverse workforce, reduce unconscious bias, fund STEM volunteer activities for underrepresented groups, support transparency and report metrics.
D&I Committee comprised of HR director, recruiting lead, Board rep, at‑large member, plus seven regional reps.
Support ERGs: Black Kimley‑Horn Network, KHAPI (Asian Pacific Islander), Military KHonnections, Pride KHonnect, Unidos @ KH, Women @ KH.
Strategic goal: recruit, mentor, develop and retain diverse staff at all levels; metrics tracked and reported.
DEI training offered; inclusive environment promoting emotional safety, respect and authenticity.
Gender outcomes: Woman‑focused awards and ERG; Fortune recognition Best Workplaces for Women every year since 2017.

Articles

Careers – Join Our Team

Services – Markets

Client Service – What Makes Us Different