Senior SQL and ETL Developer

Transdev; Lombard (IL); On-site; USD 81,000 - 101,000; Full time

Job summary

A leading company in mobility solutions is seeking an SQL & ETL Developer to enhance their corporate financial data ecosystem. This role involves designing ETL processes, automating operations, and integrating with various stakeholders. The ideal candidate will have extensive experience in SQL Server development and ETL tools, contributing to modernizing legacy systems and improving operational efficiency.

Benefits

Vacation: minimum of two (2) weeks

Sick days: 5 days

Holidays: 12 days

401(k) retirement plan

Medical, dental and vision

Life insurance

Short-term disability

Voluntary long-term disability

Qualifications

• 5+ years of hands-on experience with SQL Server development.
• 3+ years of experience with SSIS and other ETL/integration tools.

Responsibilities

• Design, develop, and support ETL workflows using T-SQL and SSIS.
• Manage and maintain a large inventory of custom SQL-based applications.
• Collaborate with cross-functional teams to gather requirements.

Skills

SQL

ETL

T-SQL

SSIS

Data Governance

Troubleshooting

Education

Bachelor’s degree in Computer Science

Tools

SQL Server

Azure Data Factory

Power BI

SSRS

Job description

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 www.TransdevNA.com or watch an overview video .

About the Role: The SQL & ETL Developer will lead the development, maintenance, and enhancement of our corporate financial data ecosystem. This role is responsible for designing and delivering robust ETL processes, automating back-office operations, and supporting integration efforts with internal stakeholders and external partners, including banks, payroll providers (e.g., ADP), and risk management vendors.

Annual Salary Range: $81,000-$101,000 annually

We offer a competitive compensation and benefits package including:

(Benefits may vary depending on location policy.)

• Vacation: minimum of two (2) weeks

-Sick days: 5 days

• Holidays: 12 days; 8 standard and 4 floating

• Other standard benefits: 401(k) retirement plan, medical, dental and vision, life insurance, short-term disability, voluntary long-term disability.

The SQL and ETL Developer plays a key role in modernizing legacy systems and automating financial, billing, and HRIS processes to improve accuracy, efficiency, and scalability. This position also provides technical oversight and hands-on development for a wide range of SQL-based solutions including stored procedures, SSIS packages, and ERP bolt-on applications.

Key Responsibilities:

• Manage and maintain a large inventory of custom SQL-based applications, stored procedures, and SSIS packages.

• Design, develop, and support ETL workflows using T-SQL, SSIS, and other integration tools.

• Lead the design and delivery of automated data exchange processes for internal and external stakeholders.

• Collaborate with cross-functional teams to gather requirements and deliver scalable data-driven solutions.

• Support and maintain financial and operational reporting modules, including custom billing and HR/payroll reports.

• Act as a subject matter expert for database development and ETL best practices.

• Provide support for financial systems integration, including accounting processes and operational KPIs.

• Propose and implement modern alternatives to legacy solutions using current technologies and architecture.

• Identify opportunities for process improvement, automation, and performance optimization.

• Provide off-hours support for critical data load issues and ensure job execution reliability.

• Maintain strict data confidentiality and ensure secure data transformation practices.

• Other duties as required.

Education, Licensing, and Certifications:

Education: Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience).

Experience:

Field and years of experience required:5+ years of hands-on experience with SQL Server development (T-SQL, stored procedures, performance tuning).

Skills and Knowledge Required:

• 3+ years of experience with SSIS and other ETL/integration tools.

• Strong background in financial systems, accounting processes, or HR/payroll data integration (ADP, in-house systems).

• Proven ability to manage multiple projects simultaneously in a fast-paced environment.

• Strong troubleshooting skills and ability to independently resolve technical issues.

• Experience working with third-party vendors and internal stakeholders across multiple departments.

• Familiarity with secure data handling, PII compliance, and data governance standards.

• Basic HTML and XML

• Experience with ERP systems and custom bolt-on development.

• Exposure to modern data platforms and cloud integration tools (Azure Data Factory, etc.).

• Familiarity with reporting platforms (e.g., Power BI, SSRS).

Pre-Employment Requirements:

Drug testing and background check

Testing related to job requirements

Physical Requirements:

• Must be able to work shifts or flexible work schedules as needed.

• 100% of work is accomplished indoors and in air conditioned or well ventilated facilities

• Work is accomplished in an office space equipped with a telephone and computer.

• The employee is generally subjected to long periods spent sitting, typing, or looking at a computer screen.

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, religion, national origin, age, disability, veteran status, genetic data, or religion or other legally protected status.

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.

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.

Version Nov 2014

Job Category: Information Technology (IT)

Job Type: Full Time

Req ID: 5263

Pay Group: NF2

Cost Center: 804

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.