Data Warehouse Administrator

Job Posting

Important Recruitment Information for this vacancy:

* Job Posting closes:
July 26, 2026

Kansas Department of Transportation

The Kansas Department of Transportation (KDOT) delivers transportation that keeps Kansans moving forward. Our employees are our most valuable resource. We depend on our employees and business partners to get the job done. KDOT strives to provide a work environment that motivates people and encourages them to be productive. KDOT is a great place to work, so come be part of our team!

Verification of identity and employment eligibility to work in the United States is required by federal law. For a list of acceptable documents that establish these criteria, please refer to the federal Form I-9. KDOT does not provide sponsor ships for this position.

E-Verify:
The Kansas Department of Transportation (KDOT) participates in E-Verify and will provide the federal government with your I-9 information to confirm that you are authorized to work in the U.S. For additional information regarding E-Verify, please . For additional information regarding Immigrant and Employee Rights (IER) please .

About the Position:

* Who can apply:
Anyone

* Classified/Unclassified Service:
Unclassified

* Full/Part-time:
Full-Time

* Regular/Temporary:
Regular

* Work Schedule:

Monday - Friday

* Eligible to Receive Benefits:
Yes

* Veterans' Preference Eligible:
Yes

* Search :

* Annual Salary Range: $63,356.80 - $70,401.58

* Hourly Pay Range: $30.46 - $33.85

Employment Benefits:

* Work-Life Balance Programs:

* Paid Leave:
Vacation, Holidays, Parental, Military, Sick, Funeral and Jury Duty

* Employee Assistance Program

* For help managing daily life at no cost to you

* Infant at Work Program

* Voluntary Benefits:
Accident, Critical Illness, and Hospital Indemnity Insurance

* First-Day Coverage:

* Medical Insurance

* Dental Insurance

* Vison Insurance

* Tax Advantage Accounts: HSA, HRA, FSA with qualifying plans

* Life Insurance:

* Employer paid basic group life

* Optional group life insurance available at a reasonable cost.

* Retirement:

* KPERS and Deferred Compensation

* Other Benefits:

* Tuition reimbursement

* Paid on-the-job training programs.

* Personal and Professional Development Opportunities

* Employee discounts with the STAR Program

* And more!

Visit the Employee Benefits page for more information…

Position Summary & Responsibilities:

Position Summary:

This Data Warehouse Administrator position is located in Topeka, at the Eisenhower State Office Building, and is within the Office of Information Technology Services. This position is responsible for the full lifecycle of KDOT's data warehouse and business intelligence environment, from backend architecture to end-user reporting.

Job Responsibilities may include but are not limited to the following:

* Perform advanced design, development, and administration of core data warehouse structures, including views, tables, functions, stored procedures, permissions, and environment configurations within SQL Server Management Studio (SSMS).

* Design, engineer, test, troubleshoot, and sustain complex ETL processes that extract, transform, and load diverse data sources into the KDOT Data Warehouse using SQL Server Integration Services (SSIS).

* Architect, develop, validate, and maintain the SAP Universe semantic layer across all operational environments.

* Design and enhance analytical reports using Crystal Reports, Web Intelligence, and Power BI to meet the information needs of business stakeholders.

* Administer and configure the Reports Portal using the Central Management Console.

* Contribute to the creation and preservation of comprehensive technical documentation essential for ensuring operational continuity within the DW/BI unit.

* Conduct research on emerging information technologies and evaluate their applicability to KDOT's data warehousing and business intelligence environment.

Note:

If you would like to view the full Position Description, please contact us .Job Apps

Qualifications:

Minimum Qualifications:

* Successful completion of 24 hours in computer science coursework or certification and four years of experience coding, testing and debugging application programs or five years of…