Senior Programmer Analyst

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

What You’ll Need

Required:
• 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