Senior Programmer Analyst

We are looking for a motivated Senior Programmer Analyst ready to take us to the next level! If you have experience being responsible for analyzing and resolving multiple problems or events of medium complexity and are looking for your next career move, apply now., We are looking for a Senior Programmer Analyst to support the CAI's client's transit systems application support team, with a primary focus on Clever Devices Cleverware upgrade, integration, and ongoing support. This position is a full-time contract role and is hybrid, requiring onsite work at Chicago headquarters at least two days per week.

What You'll Do

• Serve as a senior developer supporting transit systems and Cleverware upgrade initiatives
• Design, develop, and optimize Oracle PL/SQL components, including packages, stored procedures, cursors, dynamic SQL, and performance tuning
• Design and implement ETL processes to extract, transform, and load data across transit systems
• Develop and maintain integrations using SQL Server Integration Services (SSIS) or comparable tools
• Support and enhance Clever Devices Cleverware software, including its data structures, APIs, reporting modules, and transit operations data flows
• Develop and maintain Unix/Linux shell scripts, including Korn Shell (KSH), to support automation and batch processing
• Provide database connectivity and integration support using .NET technologies (C# or VB.NET)
• Design and maintain relational data models, ensuring proper normalization and performance
• Develop and support Microsoft SQL Server solutions, including T-SQL, stored procedures, and linked servers
• Integrate Cleverware data with enterprise data warehouses and BI platforms such as Power BI, SSRS, or Tableau
• Work with job scheduling tools such as Autosys, Control-M, or cron to manage data processing workflows
• Support REST and SOAP API integrations for data exchange
• Work independently in a fast-paced, deadline-driven environment while following change, release, and escalation processes

• Strong proficiency in Oracle PL/SQL (packages, stored procedures, cursors, dynamic SQL, performance tuning)
• Proven experience designing and implementing ETL processes
• Hands-on experience with SSIS or comparable integration tools
• Experience supporting Clever Devices Cleverware software and transit operations data
• Solid Unix/Linux shell scripting experience, particularly Korn Shell (KSH)
• Strong understanding of relational database design, normalization, and data modeling
• Experience with Microsoft SQL Server (T-SQL, stored procedures, linked servers)
• Familiarity with job scheduling tools such as Autosys, Control-M, or cron
• Ability to work independently and meet deadlines in a production support environment

Preferred:

• Working knowledge of .NET (C# or VB.NET) for database integration support
• Experience integrating Cleverware data into enterprise data warehouses or BI platforms
• Familiarity with transit industry data standards such as GTFS, GTFS-RT, or TCIP
• Experience working with REST and SOAP APIs
• Prior experience supporting transit systems or public sector environments

Physical Demands

• Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state and local standards
• Sedentary work that involves sitting or remaining stationary most of the time
• Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor

$110 - $120 per hour

CAI is a global services firm with over 9,000 associates worldwide and a yearly revenue of $1.3 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right-whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.