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 sponsorships 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 click here . For additional information regarding Immigrant and Employee Rights (IER) please click here .

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 Keywords: Topeka, Holton, Oskaloosa, Lawrence, Ottawa, Osage City, Eskridge, Alma, Wamego

Compensation:

• 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 at

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 experience coding, testing, and debugging application programs.
• Education may be substituted for experience as determined relevant by the agency. Transcripts are required for education to be considered.

Preferred Qualifications:

• Strong understanding of data, data relationships, data modeling, visualization, and data analytics.
• Experience with SQL and SSIS
• Experience developing and writing reports, with hands-on knowledge of SAP BusinessObjects (Crystal Reports, Web Intelligence, CMC).
• Excellent verbal and written communication skills.
• Strong organizational skills.
• Ability to explain complex technical solutions clearly to business end users.

Post-Offer/Pre-employment Requirements:

• Kansas Tax Clearance Certificate : A valid Kansas Tax Clearance Certificate is a condition of employment for all employees of the State of Kansas. Applicants (including non-residents) who receive a formal job offer for a State job, are required to obtain a valid Tax Clearance within ten (10) days of the job offer . A Tax Clearance can be obtained through the Kansas Department of Revenue who reviews individual accounts for compliance with Kansas Tax Law. If you have a missing tax return(s) or you owe taxes to the State of Kansas, please know that the Kansas Department of Revenue will work with you. The Kansas Department of Revenue can set you up on a payment plan to receive a Tax Clearance so you can get a job working for the State of Kansas. The Kansas Department of Revenue can be contacted at . Kansas Department of Revenue - Tax Clearance Frequently Asked Questions

Recruiter Contact Information:

• Name: Tulsa Wade
• Email:
• Phone:

Job Application Process

• First Sign in or register as a New User.
• Complete or update your contact information on the Careers -> "My Account Information" page. *This information is included on all your job applications.
• Start your draft job application, upload other required documents, and submit when it is complete.
  • Manage your drafted and submitted applications on the Careers -> "My Job Applications" page.
• Check your email and the "My Job Notifications" page for written communications from the Recruiter.
  • Email - sent to the Preferred email on the "My Account Information" page.
  • Notifications - view the Careers -> "My Job Notifications" page.

Helpful Resources at jobs.ks.gov : "How to Apply for a Job - Instructions" and "How to Search for a Job - Instructions"

Optional Documents for this Application to be Complete

Upload these on the Careers - My Job Applications page

• Transcripts (if substituting education for experience)
• DD214 (if you are claiming Veteran's Preference)

Upload these on the Attachments step in your Job Application

• Resume (or choose existing if you have one)
• Cover Letter

Helpful Resources at jobs.ks.gov : "How, What, & Where do I Upload Documents"

How to Claim Veterans Preference

Veterans' Preference Eligible (VPE): Former military personnel or their spouse that have been verified as a "veteran"; under K.S.A. 73-201 will receive an interview if they meet the minimum competency factors of the position. The veterans' preference laws do not guarantee the veteran a job. Positions are filled with the best qualified candidate as determined by the hiring manager.

Learn more about claiming Veteran's Preference

How to Claim Disability Hiring Preference

Applicants that have physical, cognitive and/or mental disabilities may claim an employment preference when applying for positions. If they are qualified to meet the performance standards of the position, with or without a reasonable accommodation, they will receive an interview for the position. The preference does not guarantee an applicant the job, as positions are filled with the best qualified candidate as determined by the hiring manager.

Learn more about claiming Disability Hiring Preference

PLEASE NOTE: The documentation verifying a person's eligibility for use of this preference should not be sent along with other application materials to the hiring agency but should be sent directly to OPS. These documents should be scanned and emailed to , or can be mailed/delivered in person to:

ATTN: Disability Hiring Preference Coordinator
Office of Personnel Services
Docking State Office Building
915 SW Harrison Ave, Suite 260
Topeka, KS 66612

Equal Employment Opportunity

The State of Kansas is an Equal Opportunity Employer. All qualified persons will be considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, political affiliation, disability or any other factor unrelated to the essential functions of the job.

If you wish to identify yourself as a qualified person with a disability under the Americans with Disabilities Act and would like to request an accommodation, please address the request to the agency recruiter.