Systems Architect - Business Intelligence

The City of Overland Park has a full-time Systems Architect - Business Intelligence position available in the Information Technology Department.

Responsibilities:

Develop BI reports using Power BI, SSRS, or other reporting tools, use ad-hoc reporting to present technical business information, analyze data to provide business solutions, such as increasing productivity or cutting costs, evaluate and enhance current ETL processes, provide database support by scripting or modifying SQL queries, prepare systems for deployment. Configure, monitor, administer, and troubleshoot commercial off the shelf information systems. Coordinates and manages projects as assigned and works with users to develop requirements and specifications for configuration changes to off the shelf information systems. Writes, tests and maintains custom reports using standard business intelligence and report writing tools. Develops training materials and trains users in the use of off the shelf information systems.

Requirements:

• Bachelor's degree in computer science, or a related field, or an equivalent combination of formal education and work experience.

• Access to the Kansas Criminal Justice Information System (KCJIS) may be required, so the following KCJIS requirements apply: must be at least 18 years of age; must not have been convicted of a felony; must not have been convicted of a serious misdemeanor; and must not have an arrest history the nature and severity of which warrant disqualification.

• Seven to ten years of experience in data warehouse modeling or BI data management.

• Five years experience with SQL database queries.

No City residency requirement.

Must successfully pass a background check, drug screen, physical exam and essential functions test.

Normal Work Hours: 8:00 a.m.-5:00 p.m., Mon.-Fri.

Salary Range Grade K: $97,289.93 - $136,205.08

Application Deadline: Open until filled

Benefits: Full-time

To view the full job description, please go to the City of Overland Park's Job Description page and search by title: Systems Architect, BI.

EO/M/F/D/V