Department/DivisionAdministrative Services / Information Systems
Supervision Received FromInformation Systems Manager, Chief Information Officer (CIO)
The primary responsibility of this position is to design, develop, deploy and maintain database structures used to link data between disparate systems and functional areas to provide an integrated, standardized data environment to facilitate the consumption of data for the agency.
This position is responsible for developing and maintaining data integrations tasks through advanced extract, load and transformation procedures, due to the variety of internal and external data sets using various data formats, using Microsoft SQL Server Integration Services (SSIS), complex stored procedures and Structure Query Language (SQL). This includes extracting, loading and transforming data between various business applications. This requires obtaining and interpreting business requirements, modeling and developing database structures such as schemas, tables and fields, and developing and testing complex SQL scripts.
Subject areas that will be represented by potential Data Warehouse will include: vehicle and trip data, trip planning data, staff and position information including salary/payroll data, financial data including expenditure, and revenue and budget information. Managing the data structures used across these functional areas requires not only advanced database skills such as creating tables, fields, functions and SQL design and query development but also a detailed understanding of the business.
- System performance and reliability principles;
- Microsoft Office applications (Word, Excel, Access, PowerPoint, Outlook);
- Microsoft Visio;
- Applicable operating systems;
- Applicable hardware devices and drivers.
- Applicable Microsoft certification;
- Knowledge in relational database management and troubleshooting;
- Defining problems, collecting data, establishing facts, drawing conclusions, and making appropriate recommendations;
- Administering database servers;
- Operating computers and related software applications;
- Providing excellent customer service;
- Preparing reports;
- Establishing and maintaining effective working relations with others;
- Strong communication and interpersonal skills.
Washington Driver's License or the ability to respond in a timely manner to issues arising throughout the Intercity Transit service area on a 24-7 basis.
One or more of the following is preferred:
- MCSA SQL Certification;
- ORACLE Certification;
- Other industry recognized certifications.
Must submit to criminal background check the results of which must meet hiring criteria for the role.
Positions in this class typically require: stooping, kneeling, crouching, crawling, reaching, standing, walking, pushing, pulling, lifting, fingering, grasping, feeling, talking, hearing, seeing and repetitive motions.
Incumbents may be subjected to moving mechanical parts, workspace restrictions, and travel.
Medium Work: Exerting up to 50 pounds of force occasionally, and/or up to 20 pounds of force frequently, and/or up to 10 pounds of force constantly to move objects.
Training and Experience:
Associate’s Degree and four years of progressively responsible database administration, business intelligence, or data management/analytics experience; or an equivalent combination of education and experience sufficient to successfully perform the essential duties of the job such as those listed above.
The above job description is intended to represent only the key areas of responsibilities; specific position assignments will vary depending on the business needs of the department.