Technical Support Analyst jobs in United States
cer-icon
Apply on Employer Site
company-logo

CAI · 22 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
check
Work & Life Balance
check
H1B Sponsor Likelynote

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

PL/SQL DevelopmentSQL DevelopmentFinancial Applications SupportData ModelingTroubleshooting SkillsReport DevelopmentETL Tools ExperienceData AnalyticsVendor Support InteractionAd-hoc ReportingUtilities DevelopmentEnterprise Scheduling ToolsDocumentation Skills

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 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 Stage

Leadership Team

leader-logo
Tom Salvaggio
President and CEO
linkedin
leader-logo
Tony Salvaggio
Founder and CEO
linkedin
Company data provided by crunchbase