Dart Data Analyst Intern in Des Moines, Iowa
This job will remain open until filled.
Collect, organize, and maintain data sets; under direction, conducts quantitative analysis and research to evaluate and report transit system performance; enables, supports, and encourages use of data and analysis in support of decision-making; ensures work efforts and products are in alignment with industry best practices.
ESSENTIAL JOB FUNCTIONS (OTHER DUTIES MAY BE ASSIGNED AS NEEDED)
Organization: Monitor work processes and report progress toward goals. Support organizational change.
Analysis: Under direction, conduct quantitative analysis and research to evaluate and report performance in support of decision-making. Document and maintain analysis, methods, processes and systems. Engagement and advocacy:Enable, support, and encourage use of data in decision-making. Seek opportunities to increase the use of data through improved access. Engage internal and external partners in the development, use and integration of data. Use data to support presentations and guidance to internal and external groups.
Data: collect, organize, and maintain data sets using best practices, including but not limited to designing data tables, applying data validation, and implementing procedures to support data needs. Assess data for accuracy, anomalies and completeness. As issues arise, determine and propose solutions, with supervisor input as needed.
MINIMUM EDUCATION AND/OR EXPERIENCE
High School Diploma or equivalent with at least 3rd year status in a relevant degree program.
Knowledge of analyzing and querying data in a relational database environment (Oracle, SQL etc.)
- Interest in the transportation industry.
KNOWLEDGE, SKILLS AND ABILITIES
Qualification to enter this position requires knowledge of the following:
Data and Analysis
Software applications including word processing, spreadsheets and databases.
Principles and methods for analysis, research and evaluation; including statistical analysis techniques.
Best practices related to data collection, processing, modeling, management, analysis, stewardship and reporting; including relational database theory.
Developing, managing and using data and data systems.
Conducting studies by applying the principles and methods of data analysis, research and evaluation.
Consistently analyzing a variety of techniques and selecting the most appropriate, taking into account the goals, potential payback, resource requirements and possible drawbacks. Effectively communicating the justification for choosing specific techniques and how the technique will accomplish the desired goals.
Compiling, processing, analyzing, and reporting various types of data to inform decision making.
Ensuring that data, analysis, and research are organized, documented, and communicated in a way that they can be understood, interpreted, and acted upon effectively.
Communicating complex technical information effectively using verbal, written and visual communication skills including public speaking. Adapting communication style to various audiences.
The use of computers and a variety of software including Excel, Word, Outlook and SQL.
Gaining the support of others through persuasiveness, credibility and expertise. Inspiring others to collaborate voluntarily.
Communicating effectively within interdepartmental teams; including sharing accurate and pertinent information in a timely manner.
Consistently building and maintaining positive working relationships internally and externally, even in times of stress and conflict.
Participating in, facilitating, and supporting conflict resolution; exchanging feedback in an open, constructive, and professional manner.
Leading efforts to collaboratively make decisions, establish and meet timelines and deliver results that meet customer needs.
Improving work processes and efficiency.
Problem-solving and strategic judgment
Organizing and prioritizing work despite tight deadlines, multiple customers, and competing priorities; monitoring and reporting progress towards goals.
Exhibiting situational awareness and strategic judgment. Recognizing when sources of information and/or partners should be consulted and when to apply past experiences.
Using intelligence, logical thinking, common sense, hard work and tenacity to solve difficult and complex challenges.
Identifying opportunities for creative problem solving while staying within the parameters of good practice.
Proficient Performance Requirements for Knowledge and Skills
Qualification to fulfill the full range of this position’s duties requires the following knowledge, which may be gained or further developed after entering the job:
Software applications including business intelligence tools and geographic information systems.
Public transit planning and operation principles and specific terms and programs including the National Transit Database (NTD).
Transit technology as a data source for transit planning analysis and research.
Community Transit planning, marketing, and operations.
The use of software applications including ArcGIS.
On a normal work day, this position requires:
Prolonged periods of sitting
Extensive use of hands, fingers and arms in operations requiring constant handling of paper documents, computing and entering data using a keyboard and ten key calculator
Clarity of vision at 20 inches or less to read and enter numerical data
The ability to hear normal verbal conversation with or without corrective devices to communicate with co-workers and customers
The ability to speak and read the English language clearly and concisely
- Primary work location is in a general office environment, heated during the winter and cooled in the summer. Job is not subject to significant occupational or environmental hazards.