Data and Reporting Analyst

Kansas Turnpike Authority•Wichita, KS

22h

About The Position

The Data and Reporting Analyst participates in business analysis to gather requirements for reports and dashboards, designs data repositories and reporting tools, and translates business needs into technical specifications. The role compiles information from multiple data sources and works with employees to convert legacy reports to Tableau solutions. The analyst supports the availability and performance of reports and dashboards for internal and external users, implements configuration management and change controls, and reviews SQL queries and reports for performance. The role validates data for accuracy and integrity, maintains documentation, collaborates with technical staff on complex deliverables, and prioritizes requests. It also provides reporting guidance to users, promoting reuse and adherence to data governance and security. Work is performed primarily in a general office environment using computers, electronic devices, phones, and related office equipment. Projects are generally assigned, with the employee organizing tasks to meet established timeframes. Decision-making and problem-solving are usually done with more experienced professionals or a manager; purchase requests require supervisory approval. Occasional hours beyond normal business hours may be required to meet deadlines.

Requirements

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.
Familiarity 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 written and oral interpersonal communication skills.
Willingness to learn new technologies and expand skills.
Proficient use of computers.
Ability to document technical and non-technical processes and procedures.
Bachelor's degree in computer science, information systems, technology, or comparable work experience developing business applications.

Nice To Haves

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

Responsibilities

Gather business requirements for reports and dashboards.
Design data repositories and reporting tools to organize, analyze, and report data.
Translate business requirements into specifications for reports and dashboards, including those using multiple data sources.
Work with employees to convert legacy reports to Tableau solutions.
Compile data and other information from multiple data sources.
Support the availability and performance of reports and dashboards for internal and external users.
Implement configuration management and change controls in the reporting environment.
Analyze SQL queries and reports for performance and present recommendations to relevant stakeholders.
Validate data to ensure reporting accuracy and ongoing integrity.
Maintain complete documentation of reports.
Collaborate with technical staff to deliver complex reporting requirements and manage request priorities.
Provide reporting support and guidance to users, encouraging reuse and adherence to data governance and security.