Data and Reporting Analyst

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

Job summary

Kansas Turnpike Authority in Wichita, KS seeks a BI Analyst to design data repositories and reporting tools, converting business requirements into technical specifications for reports and dashboards built from multiple data sources. You will migrate legacy reports to Tableau, compile data from various sources, and ensure performance, validation, and documentation.

The role emphasizes collaboration with staff, adherence to data governance and security, and providing ongoing reporting support to

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

Responsibilities

• Participate in business analysis activities to gather reporting requirements.
• Design data repositories and reporting tools to organize, analyze, and report data.
• Translate business requirements into specifications for reports and dashboards from multiple sources.
• Work with staff to convert legacy reports to Tableau solutions.
• Compile data from multiple data sources.
• Provide support to ensure availability and performance of reports for internal and external users.
• Ensure configuration management and change controls in the reporting environment.
• Analyze SQL queries and reporting for performance, with stakeholder recommendations.
• Validate data to ensure accurate reporting and data integrity.
• Maintain complete documentation of all reports.
• Collaborate with technical teams to satisfy complex reporting deliverables and manage priorities.
• Provide reporting support and guidance to users, promoting re-use and data governance.

Skills

Tableau

SQL

Data governance

Business analysis

Report design

Excel

Communication

Documentation

Education

Bachelor's degree in Computer Science, Information Systems, Technology or related field

Tools

Tableau

SQL Server

Microsoft Excel

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.