Salary : $60,112.00 Annually
Location : Tucson, AZ
Job Type: Full Time
Job Number: 2023-00925
Department: Transportation
Division: TR MOBINNOVTECH
Opening Date: 06/09/2023
Closing Date: 6/23/2023 11:59 PM Arizona
FLSA: Exempt
Position Description
Salary Grade: 62
Pima County’s Department of Transportation is looking for a skilled, motivated professional to join their Mobility, Innovation, and Technology Division. The team is responsible for implementing and managing technology for the department from a functional perspective in support of Transportation System Management and Operations (TSMO). TSMO is an integrated approach to optimize the performance of existing infrastructure by implementing multi-modal systems, services, and projects. TSMO strategies improve system efficiency, enhance public safety and security, reduce traffic delays for road users, and improve access to information for travelers. The emphasis of TSMO is an outcome-driven, performance-based system. Strategies include but are not limited to traffic safety, traffic incident management, travel information services, roadway weather information, connected and automated vehicles, traffic signal systems, and new technologies that are rapidly evolving. The ideal candidate will demonstrate the ability to prioritize tasks and meet deadlines while emphasizing accuracy and attention to detail. This is a unique opportunity for a self-motivated, enthusiastic, dependable, and innovative individual to make a meaningful impact in the field. If you’re ready to take your career to the next level, this dynamic and challenging role is for you!
Duties/Responsibilities
(Work assignments may vary depending on the department’s needs and will be communicated to the applicant or incumbent by the supervisor.)
Acts as the subject matter expert on reporting tools and data analysis, makes recommendations on process changes;
Provides data analysis and reporting solutions support for assigned departments;
Works on data analysis tasks within one or more functional areas independently or as part of a team;
Works with internal and external customers and Analytics and Data Governance partners to gather and validate requirements;
Develops and writes business requirements for identified data analysis and reporting solutions;
Creates and maintains a variety of reports, data queries, scripts, workflow and automated tasks using structured query language and various database management tools;
May identify and analyze commonly used queries and reports to determine if currently available solutions are applicable;
Researches department reporting problems and assists in the creation of models to help analyze department reporting needs;
Develops, executes, and documents user test plans;
Coordinates and performs quality control testing of new or updated software and processes, helps resolve issues based on test results;
Verifies the collected data is within required quality standards;
May maintain the quality of metadata repository/data dictionary by adding, modifying, and deleting data;
Creates data quality tickets and ensures they are resolved in a timely manner;
Assists in the development and presentation of end-user training materials;
May train and assist clients in the use of the business intelligence solutions.
KNOWLEDGE & SKILLS:
Knowledge of:
- software development and applications programming;
- principles and techniques of systems analysis and design;
- development and maintenance of data communications, security and privacy measures;
- principles of database design, data warehousing, data modeling and data mining;
- reporting tools such as Crystal Reports, Web Intelligence or SSRS;
- effective teamwork behaviors.
Skill in:
- working within the Agile sprint methodology;
- using Microsoft Excel (lookups, formulas, pivots, macros);
- writing SQL statements to analyze data: joining, filtering, aggregating;
- writing procedures and work instructions;
- communicating with internal and external customers through written, verbal, interpersonal and management presentation;
- operating as an effective member of a team;
- employing quality skill sets and diagnostic tools;
- problem solving and resolution techniques;
- employing diagnostic, analytical and conceptual skills with detailed orientation;
- gathering requirements, analyzing business problems, automating business processes and implementing application solutions;
- visual design using SAP Lumira, Tableau or Power BI.
Minimum Qualifications
A Bachelor’s degree from an accredited college, university or technical trade school with a major in computer science, computer engineering, management information systems (MIS), or a closely related field as determined by the appointing authority at the time of recruitment.
(Relevant experience and/or education from an accredited college, university or technical trade school may be substituted.)
Qualifying education and experience must be clearly documented in the “Education” and “Work Experience” sections of the application. Do not substitute a resume for your application or write “see resume” on your application.
Preferred Qualifications: (Be specific in describing your experience in your application. Ensure the descriptions provided illustrate your competencies, specifically addressing the required and preferred qualifications.):
- Minimum one (1) year experience analyzing business processes to maximize and prioritize efficiencies.
- Experience with asset management applications or GIS software, such as ESRI’s ArcGISPro; or general database concepts of GIS software manipulation and analysis of system outputs.
- Minimum one (1) year experience as a subject matter expert in one or more areas of a business enterprise system.
- Experience working with large data sets, data mining, data analysis, or reconciling multiple systems.
- Experience using Python, SQL, or other industry-standard programming languages.
- Experience gathering information from subject matter experts to develop, organize, and write procedure manuals, technical specifications, or process documentation.
Selection Procedure:
Pima County Human Resources Department reserves the right to admit to the selection process only those candidates that meet the minimum/desired qualifications. All applications will be assessed based on an evaluation of the listed education and experience. Candidates meeting the minimum/desired qualifications may be further evaluated/scored against any advertised Preferred Qualifications. The hiring authority will interview and select the successful candidate from a referral list provided by Human Resources. Additional assessments/testing may be required as part of the selection process.
Supplemental Information
Licenses and Certificates: Valid driver license is required at time of application. ValidAZ driver license is required at time of appointment. The successful applicant will be subject to a 39-month DOT Motor Vehicle Record review to determine applicant’s suitability to operate county vehicles in accordance with Pima County administrative procedures. Failure to obtain and maintain the required licenses and certifications shall be grounds for termination. Any offer of employment resulting from this recruitment is contingent upon Fleet Services’ review and approval of the candidate’s driving record.
Special Notice Items: The County requires pre-employment background checks. Successful candidates will receive a post-offer, pre-employment background screening to include verification of work history, education and criminal conviction history. A prior criminal conviction will not automatically disqualify a candidate from employment with the County. Some positions may require satisfactory completion of a personal background investigation, polygraph examination and/or pre-/post-appointment drug-testing by law enforcement agencies due to the need for access to law enforcement, corrections or court facilities, property and associated confidential and sensitive information, documents, communications and data base systems.
Physical/Sensory Requirements: Physical and sensory abilities will be determined by position.
EEO Information: Pima County Government is an Equal Employment Opportunity employer. We are committed to an inclusive and diverse workforce and will not discriminate in employment opportunities or practices on the basis of race, color, religion, national origin, age, disability, gender, sexual orientation, kinship, political interest, or any other characteristic protected by law.
Pima County provides access to high-quality, affordable healthcare for eligible employees and has an award-winning wellness program. Our plan is designed to ensure a high level of coverage and financial protection. Read more about our benefits program by