Data Warehouse Administrator

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., * 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.

• 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., * 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.

Pulled from the full job description

• Paid training
• On-the-job training
• Tuition reimbursement
• Health insurance
• Employee discount
• Health savings account
• Dental insurance, * 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 o 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!

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.