Data and Reporting Analyst

Kansas Turnpike Authority; Wichita (KS); On-site; USD 65,000 - 95,000; Full time

Job summary

Kansas Turnpike Authority is seeking a BI Analyst to develop and maintain enterprise-scale reports and Tableau dashboards. You will translate business requirements into technical solutions, integrate data from multiple sources, and ensure accuracy, performance, and governance across reporting tools.

The role emphasizes collaboration with IT and business teams, data validation, and documentation to support internal users and stakeholders in a fast-paced government-adjacent environment.

Qualifications

• Ability to develop and implement enterprise-scale reports and dashboards.
• Understanding of business principles and objectives.
• Working experience with business intelligence platforms, preferably Tableau.
• Ability to translate business requirements into technical solutions.
• Familiarly with database architecture and design.
• Working knowledge of databases and data retrieval methods.
• Knowledge of relational databases.

Responsibilities

• Participate in business analysis activities to gather required reporting and dashboard requirements.
• Designs appropriate data repository and reporting tools that will be used to organize, analyze, and report data.
• Translate business requirements into specifications that will be used to implement the required reports and dashboards, created from potentially multiple data sources.
• Work with other employees to convert legacy reports to Tableau solutions.
• Compiles data and other information from multiple data sources.
• Provide support as required to ensure the availability and performance of developed reports and dashboards for both external and internal users.
• Ensure proper configuration management and change controls are implemented within the reporting environment.

Skills

Tableau

SQL queries

Dashboard design

Data visualization

Data governance

Documentation

Communication

Education

Bachelor's degree in Computer Science or Information Systems

Tools

SQL

Relational databases

Job description

Definition and Examples of Work

• Participate in business analysis activities to gather required reporting and dashboard requirements.


• Designs appropriate data repository and reporting tools that will be used to organize, analyze, and report data.


• Translate business requirements into specifications that will be used to implement the required reports and dashboards, created from potentially multiple data sources.


• Work with other employees to convert legacy reports to Tableau solutions.


• Compiles data and other information from multiple data sources.


• Provide support as required to ensure the availability and performance of developed reports and dashboards for both external and internal users.


• Ensure proper configuration management and change controls are implemented within the reporting environment.


• Ensure all SQL queries and reporting are analyzed for performance, with recommendations being presented to relevant stakeholders.


• Responsible for data validation to ensure reporting results are accurate and support continuous integrity.


• Maintain complete documentation of all reports.


• Works with technical members of the organization to satisfy complex reporting deliverables and manages priority of such requests.


• Provide reporting support and guidance to other users, promoting re-usability and adherence to data governance and security.

Latitude and Impact of Position

This position works daily to obtain and research information, provide input, and problem solve as part of a team. Most work projects are assigned, then the employee arranges his/her work tasks for completion within established timeframes. Decision making and problem solving is usually done in conjunction with more experienced professionals or manager. All purchase requests require supervisory approval. Successful completion of job tasks impacts internal systems, processes and procedures, internal customer satisfaction, and external relationships.

Work Environment

The work environment described here is representative of the general work environment for the position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Primarily works in a general office environment using computers, electronic devices, phones, and related office equipment.

QUALIFICATION

Required Knowledge, Skills, and Abilities

• Ability to develop and implement enterprise-scale reports and dashboards.


• Understanding of business principles and objectives.


• Working experience with business intelligence platforms, preferably Tableau.


• Ability to translate business requirements into technical solutions.


• Familiarly with database architecture and design.


• Working knowledge of databases and data retrieval methods.


• Knowledge of relational databases.


• Excellent planning, organizational, and time management skills.


• Excellent interpersonal communications, both written and oral.


• Willingness to learn new technologies and expand skills.


• Proficient use of computers.


• Ability to document technical and non-technical processes and procedures.

Preferred Knowledge, Skills, and Abilities

• Experience with Microsoft Office software, including Outlook, Word, and Excel.

Preferred Education and Experience

• Bachelor's degree in computer science, information systems, technology or comparable work experience developing business applications.

Physical requirements

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Ability to sit (or stand) for long periods of time while visualizing a computer screen (continuous)


• Must be able to speak with and hear others (frequent)


• Uses hands to touch, handle, feel, grip, grasp, pinch or squeeze (frequent)


• Must be able to see up close and identify and distinguish colors and/or shapes (continuous)


• Must be able to adjust focus, use peripheral vision (frequently)


• Occasionally uses depth perception and must see at a distance.


• Must occasionally distinguish between sound tones.


• Must lift up to 25 pounds occasionally.

Other Requirements

• Occasional hours beyond normal business hours may be required to meet deadlines.