Lane Transit District, named Best Mid-Sized Transit System in North America for 2014, is one of the most successful and highly regarded public transit systems in the nation; has received numerous national, state, and local awards for service to the community; and, for transit districts its size, is consistently ranked among the nation's leaders in the successful implementation of Bus Rapid Transit, bus ridership, and service efficiency.  LTD is committed to the values of working together, taking initiative, being professional, and practicing safety.

This is an excellent career opportunity with a progressive and innovative transit organization that offers an attractive starting salary, an excellent benefit package, and equal opportunity.  Lane Transit District values diversity at all levels of its workforce ' women and minority applicants, including members of the LGBTQ community, are encouraged to apply.

Job Summary: Under general direction, this position is largely responsible for providing business intelligence in the form of reports, analysis, and information streams from the various data sources maintained by or available to the District.  This position will sustain an existing system of reporting processes in addition to improving the quality of information available to staff and partners for use in data-based decision support tasks.  It will require the commitment of a highly competent and highly motivated individual paired with that of other District personnel to sustain the business and operational functions of the organization. 

This position requires a service oriented mentality, high sense of ownership of the requests and problems assigned, focus on managing and resolving issues in alignment within committed timelines, establishing and maintaining communication with technology customers to keep them updated with status of their requests, initiating and performing changes on production systems and proactively escalating any issues that cannot be resolved within established timeframes.

Essential Job Functions:

• Writing SQL to extract data from different sources and presenting that data in an easily understood way to both technical and non-technical people
• Soliciting business requirements and presenting the appropriate information in the most effective format (e.g. textual, graphical, GIS).
• Own, track and resolve report/analysis requests and incidents.
• Fulfill requests and resolve incidents within established timelines.
• Maintain knowledge and documentation of the District's various data sources.
• Assist District staff with access to data sets appropriate for analysis tasks.
• Review logs of production data collection/processing systems on a daily basis to ensure service related issues are identified and resolved.
• Administer the District's databases (backup and recovery, index maintenance, security, storage allocation).
• Work with IT staff to come up with strategic solutions to recurring problems.
• Create and maintain knowledgebase articles within the IT system about BIA procedures and processes to ensure continuity, cross-training, and redundancy of knowledge.

Knowledge, Skills and Abilities:

The ability to work as an effective team member and establish and maintain effective working relationships with those contacted in the course of work; meet position attendance requirements; work safely; perform job functions in a timely and accurate manner; communicate effectively with other employees and the general public using courtesy, tact, and good judgment, and act as a positive representative of the District.

Qualifications:

Any equivalent combination of education and experience which provides the knowledge, skills, and abilities required to perform the job are acceptable, which typically include:

• A bachelor's degree in computer science, management information systems, or a related field from a recognized college or university; or equivalent experience
• A minimum of five years of progressive SQL experience in an Analyst, DBA, Developer or similar role.
• High degree of competency working with all aspects of SQL Server (2008 and higher).
• High degree of competency working with Crystal Reports and SSRS (2008R2 and higher).
• High degree of competency working with SSIS and ETL tools.
• Experience implementing operational automation using scripts.
• Experience with data modeling and data warehousing
• Experience with statistics.
• Good communication and documentation skills.

Preferred, but not required:

• Experience with C#, VB.NET, GIS, Access, FoxPro, Python, Source Control (TFS)
• SSAS cube or tabular model development
• Prior Public Transit or government experience

Compensation and Work Schedule:

This position is a full-time, exempt position, eligible for the regular administrative benefits package.  The pay range is between $74,142.00 and $98,856.00 annually. Work is mainly performed in an office environment during business hours and often includes evening, weekend, and 24-hour on-call duties. 

How to apply:

Visit our website: http://ltdjobs.applicantpool.com/jobs/.  Submit your resume and complete the required application and assessments. This position will remain posted until filled, with the first review of applications beginning on Monday, July 3, 2017. For additional information call (541) 682-6100.

The Lane Transit District is an Affirmative Action/ Equal Employment Opportunity Employer.