Engineer 2 - Irvine, United States - Western Alliance Bank

    Default job background
    Description
    Engineer 2 for Western Alliance Bank – Irvine, CA

    Job Description:
    Mentor Business Intelligence Support Engineer in various stages of business intelligence. Provide frameworks training to new hire and work closely to deliver quality outcomes.

    Design, develop and maintain programs, systems and software associated with pricing, best execution, hedging, pooling, valuations, staffing models, operations surveillance, delinquency, servicing and accounting.

    Optimize queries using SQL optimization techniques to improve efficiency and performance.

    Identify potential areas for optimization and performance enhancements, including recommendations for the on-going maintenance and improvement of overall code quality.

    Design, develop and maintain programs and reports associated with, but not limited to, bond pricing, hedging, pooling, valuations, treasury, accounting, servicing, staffing models and operations surveillance.

    Evaluate and advise on technology components such as hardware, software, or networking applications that aid in building systems and applications.

    Design, develop and maintain core databases that support the company. Review development activities and develop the unit test plan for the team.

    Design, develop, and maintain programs associated with communicating data between third-party providers via various protocols such as SFTP and HTTPS.

    Remote work opportunity available for position with full reporting to 17885 Von Karman Avenue, Suite 100, Irvine, CA Orange County).

    Job Requirements:
    Requires Bachelor's or Master's degree in Computer Science, Management Information Systems, Information Systems, Computer Engineering or related field.

    2 years of experience with Bachelor's degree or 0 years of experience with a Master's degree is required, which must include some education or experience in each of the following:
    Object-oriented programming; C#, C++ or Java;

    Relational Databases:

    MS SQL SERVER, Oracle, MySql; Software Development Kit (SDK) / Application Programming Interfaces (API); Reporting tools, including Tableau or Power BI; Agile tools such as JIRA or Github; and Version/Source Control tools, including Git, Subversion, and Team Foundation Server.


    How to apply:
    Mail resume to: Attn: Western Alliance Bank HR, One East Washington, Ste. 1400, Phoenix, AZ Please reference ID #108.

    Salary:
    $121,222.00 to $129,322.00 per year