About Transdev: Cities, counties, airports, companies, and universities across the U.S. contract with Transdev to operate their transportation systems, maintain their vehicle and fleets, and deliver on mobility solutions. Transdev U.S. employs a team of 32,000 across 400 locations while maintaining more than 17,000 vehicles

Transdev North America is the largest private sector operator of multiple modes of transit in North America, providing bus, rail, paratransit, shuttle, sedan and taxi services. We manage over 200 transportation contracts for cities, transit authorities and airports, providing safe and sustainable mobility solutions. Our mission is to improve public transportation, to enhance quality of life and combat global warming. https://www.transdevna.com

Overview of Position:

The Transdev Business Solutions Team is a diverse cross-functional teamof IT and transit operational professionals. The team designs, develops, implements, supports, and optimizes the commercial and proprietary business technology solutions for Transdev operations. Focused on innovation and customer service we support the platforms and users that drive continued improvement in Transdev’s operations.

Reporting to the Director of Business Solutions this position plays a key role in supporting Transdev’s proprietary dispatch, scheduling, and timekeeping system (VDS). This position will combine strong technical SQL ability, strong logic skills, good communication, curiosity and coachability.

Salary Range: $125,000-$140,000 annually

We offer

• Medical/Dental/Vision health benefits - Blue Cross Blue Shield*

• 401(K) retirement plan

• Paid time off and holidays

• Ability to advance your career

Key Responsibilities:

Operational Support

• Prioritize workflow based on operational need and financial impact.

• Program rule revisions and corrections using SQL logical, SQL queries, and stored procedures.

• Provide assistance and support to Business Solutions and operational staff for testing and validating code changes and end results. This may include creating test databases, migrating and/or updating stored procedures, programming, and developing SQL scripts, tables, views, stored procedures, functions, constraints etc.…

Operational Improvement and Development

• Work with the Director of Business Solutions to migrate the legacy payroll rule coding for legacy databases to the new SQL / variable based rule set.

• Assist Transdev management by providing relevant data through SQL queries.

• Work in collaboration with team members to find creative solutions that improve performance through a continuous incremental improvement process.

Operational Effectiveness

• Work on special ETL and integration projects at the direction of the Business Solutions Director.

• Effectively balances and prioritizes workloads among project work development, support maintenance, and operations (including on-call rotation).

• Document changes, corrections, and improvements to ensure the sustainability and supportability of the development.

• Other duties as assigned.

Education, Licensing, and Certifications:

• Bachelor’s degree or equivalent direct job experience

Experience:

• Minimum of three (3)years of experience with Microsoft SQL scripting and programming

Skills and Knowledge Required:

• Experience with MS SQL Server 2016+

• Experience with Windows Server OS

• Solid understanding of Microsoft SQL

• Experience with SQL development and stored procedures

• Understanding and experience with SQL Server Integration Services (SSIS)

• Experience withETL processes

• MS Tools (Excel, Outlook, Word, Teams, etc.).

• Good knowledge of various Data Structures and Optimization techniques

Skills and Knowledge Preferred:

• Experience with payroll systems and management

• Experience with SQL Server Reporting services

• Experience with .net

Travel outside of immediate area of up to 10%

Pre-Employment Requirements:

Drug testing and background check

Testing related to job requirements

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. 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 upon request.

Transdev is an Equal Employment Opportunity (EEO) employer and welcomes all qualified applicants. Applicants will receive fair and impartial consideration without regard to race, sex, color, national origin, age, disability, veteran status, genetic data, gender identity, sexual orientation, religion or other legally protected status.

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 upon request.

California applicants: Please Click Here for CA Employee Privacy Policy.

Version Sep 2021

Job Category: Information Technology (IT)

Req ID: 2169

Pay Group: NF2

Cost Center: 834

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified.

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 upon request.

Transdev is an Equal Employment Opportunity (EEO) employer and welcomes all qualified applicants. Applicants will receive fair and impartial consideration without regard to race, sex, color, national origin, age, disability, veteran status, genetic data, gender identity, sexual orientation, religion or other legally protected status, or any other classification protected by federal, state, or local law.

Drug-free workplace

If based in the United States, applicants must be eligible to work in U.S. without restrictions for any employer at any time; be able to pass a drug screen and background check.

California applicants: Please Click Here for CA Employee Privacy Policy.

About Transdev

Cities, counties, airports, companies, and universities across the U.S. contract with Transdev to operate their transportation systems, maintain their vehicle and fleets, and deliver on mobility solutions. Transdev U.S. employs a team of 32,000 across 400 locations while maintaining more than 17,000 vehicles.

Part of a global company, Transdev is a leader in mobility with operations in 19 countries, proudly operated by 110,000 team members from around the world. As an operator and global integrator of mobility, we are driven by our purpose. Transdev – the mobility company – empowers the freedom to move every day thank to safe, reliable, and innovative solutions that serve the common good. Find out more at http://www.TransdevNA.com or watch an overview video.