Job Title

Senior Programmer Analyst Req number: R7580 Employment type: Full time Worksite flexibility: Hybrid Who we are 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 rightu2014whatever 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. Job Summary 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. Job Description 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 fullu2011time contract role and is hybrid , requiring onsite work at Chicago headquarters at least two days per week. What Youu2019ll Do u2022 Serve as a senior developer supporting transit systems and Cleverware upgrade initiatives u2022 Design, develop, and optimize Oracle PL/SQL components, including packages, stored procedures, cursors, dynamic SQL, and performance tuning u2022 Design and implement ETL processes to extract, transform, and load data across transit systems u2022 Develop and maintain integrations using SQL Server Integration Services (SSIS) or comparable tools u2022 Support and enhance Clever Devices Cleverware software, including its data structures, APIs, reporting modules, and transit operations data flows u2022 Develop and maintain Unix/Linux shell scripts, including Korn Shell (KSH), to support automation and batch processing u2022 Provide database connectivity and integration support using .NET technologies (C# or VB.NET) u2022 Design and maintain relational data models, ensuring proper normalization and performance u2022 Develop and support Microsoft SQL Server solutions, including Tu2011SQL, stored procedures, and linked servers u2022 Integrate Cleverware data with enterprise data warehouses and BI platforms such as Power BI, SSRS, or Tableau u2022 Work with job scheduling tools such as Autosys, Controlu2011M, or cron to manage data processing workflows u2022 Support REST and SOAP API integrations for data exchange u2022 Work independently in a fastu2011paced, deadlineu2011driven environment while following change, release, and escalation processes What Youu2019ll Need Required: u2022 Strong proficiency in Oracle PL/SQL (packages, stored procedures, cursors, dynamic SQL, performance tuning) u2022 Proven experience designing and implementing ETL processes u2022 Handsu2011on experience with SSIS or comparable integration tools u2022 Experience supporting Clever Devices Cleverware software and transit operations data u2022 Solid Unix/Linux shell scripting experience, particularly Korn Shell (KSH) u2022 Strong understanding of relational database design, normalization, and data modeling u2022 Experience with Microsoft SQL Server (Tu2011SQL, stored procedures, linked servers) u2022 Familiarity with job scheduling tools such as Autosys, Controlu2011M, or cron u2022 Ability to work independently and meet deadlines in a production support environment Preferred: u2022 Working knowledge of .NET (C# or VB.NET) for database integration support u2022 Experience integrating Cleverware data into enterprise data warehouses or BI platforms u2022 Familiarity with transit industry data standards such as GTFS, GTFSu2011RT, or TCIP u2022 Experience working with REST and SOAP APIs u2022 Prior experience supporting transit systems or public sector environments Physical Demands u2022 Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state and local standards u2022 Sedentary work that involves sitting or remaining stationary most of the time u2022 Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor Reasonable accommodation statement If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to or (888) 824 u2013 8111. $110 - $120 per hour The pay range for this position is listed above. Exact compensation may vary based on several factors, including location, experience, and education. Benefit packages include medical, dental, and vision insurance, as well as 401k retirement account access. Employees in this role may also be entitled to paid sick leave and/or other paid time off as provided by applicable law.