CAI · 6 hours ago
Technical Support Analyst
CAI is a global technology services firm with over 8,500 associates worldwide. They are seeking a Technical Support Analyst to develop and maintain complex IBM Cognos reports and Oracle PL/SQL queries, support a Loan Application and its interfaces, and consult with business users.
ConsultingSoftware
Responsibilities
Develop, maintain, and modify complex reports, queries, and data extracts using IBM Cognos and Oracle PL/SQL
Support and maintain the Loan Application and its associated interfaces, ensuring smooth functionality and integration
Consult with business users to address application functionality questions and provide technical guidance
Troubleshoot and resolve issues at the server, client, and interface levels, including working with vendors for support and upgrades
Create ad-hoc reports and data extracts for regulatory, IT, and business needs, leveraging strong SQL and data modeling skills
Qualification
Required
PL/SQL and SQL Development/ Development Support
Minimum of 5 years applications support and/or development experience in the financial domain
Strong Financial Applications Background, preferably supporting a loan or deposit type system – e.g. LoanIQ
Strong Data Modeling and SQL skills that can be applied to interface development, ad-hoc data extracts and scheduled report writing
Experience working with and supporting interfaces for a data warehouse – e.g. OFSA
Excellent troubleshooting skills – at server, client and interface level
Excellent Data Analytics skills
Proven ability to work with a vendor regarding support issues, enhancements and upgrades
Ability to quickly develop ad-hoc reports on the fly for regulatory and IT purposes
Ability to document business requirements and present comprehensive, logical solutions to business users
Oracle 10g/11, Microsoft SQL Server, PL/SQL programming, Schemas, Views, Stored Procedures, Triggers experience
Report development experience
Enterprise Scheduling Tools (e.g. Cybermation, AutoSys) experience
ETL Tools (e.g. SSIS, DTS, Informatica) experience
Utilities development (batch scripting, ftp scripting) experience
Data Modeling Tools (e.g. Erwin) experience
Benefits
Medical, dental, and vision insurance
401k retirement account access
Paid time off
Paid sick leave
Company
CAI
CAI is a global services firm with over 9,000 associates worldwide and a yearly revenue of $1.3 billion+.
H1B Sponsorship
CAI has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (24)
2024 (28)
2023 (24)
2022 (30)
2021 (41)
2020 (48)
Funding
Current Stage
Late StageRecent News
Computer Aid, Inc. (CAI)
2025-09-19
Company data provided by crunchbase