CAREERS - Applications Support Analyst (temp to hire)

Corporate Office - Costa Mesa
Technology Center - Garden Grove
Los Angeles Office
Sacramento Office

  • Bachelors Degree in computer science or related field preferred
  • SQL and MS .NET Certifications preferred
  • High School Diploma or equivalent required
  • Use technology such as SQL Server and T-SQL to extract and analyze raw data from multiple large and complex SQL databases and create integrated analyses
  • Use trace analysis, debug skills, SQL skills, and other proprietary tools, to analyze problems and develop solutions to meet customer needs; this may involve writing code.
  • Monitor application systems platforms and processes and use tools to troubleshoot and isolate issues
  • Monitor event processes, message queues and workflow processing software involving web.
  • Enter new trouble tickets, escalate existing tickets and keep users informed.
  • Troubleshoot, manage and resolve production systems, platforms and processes.
  • Identify system and service issues separately from software source code errors.
  • Create and monitor application check lists, uptime report, and event root cause investigation as necessary.
  • Document procedures and troubleshooting steps, and train lower level Application Support Analysts on identifying issues
  • Work with vendor partners to troubleshoot issues, document software issues, application and system issues
  • Support all of the custom product/processes and software
  • Communicate with internal users, Technical Account Representatives and vendors concerning case status, prioritization, and resolution plans
  • Ensure software problems are effectively managed and communicated to resolution
  • Keep current the status/resolution plan for critical issues and communicate to proper stakeholders (e.g. Technical Account Representatives, Customer Service).
  • Establish a close working relationship across multiple departments.
  • 2nd and 3rd Tier support for application issues
  • Gather data and assess users’ information, reporting, and systems’ needs
  • Reviews and monitors system capabilities and department needs to design effective support processing programs
  • SQL Server: scripting, TSQL, stored procedures, queries, etc.
  • ERP experience required
  • Experience interfacing with multiple divisions and departments
  • Strong experience with troubleshooting and application support
  • Great Plains nice to have
  • SharePoint experience strongly preferred
  • InfoPath experience strongly preferred
  • Experience with SQL, T-SQL, Queries, XML, Application Troubleshooting, Problem Solving, Client interfacing, Software Support
  • Must be a highly motivated individual with a high-level of initiative, attitude and willingness
  • Strong verbal and written communication skills; excellent interpersonal skills with the ability to maintain cooperative working relationships
  • Must be able to effectively prioritize tasks and meet requirements for timeliness and accuracy
  • Strong analytical and problem-solving skills
  • Ability to assist and train others
  • Strong SQL skills a must (T-SQL preferred) - including writing stored procedures, triggers, and very complex queries

For consideration, please click here to submit your resume or mail to HR, Insight Investments, 7th Floor, 611 Anton Blvd., Costa Mesa, CA 92626, or fax to (714) 939-8609.

We are an Equal Opportunity Employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, veteran status, or any other characteristic protected by law.