Shire Jobs

Job Title: Treasury Analyst - Treasury Data Management Location: CityScape What you'll do: The Treasury Analyst (Treasury Data Management) will assist with coordinating and structuring all relevant data for Corporate Treasury in support of Asset Liability Management ("ALM"), Liquidity management/Stress testing, ("LPST"), Capital Management/stress testing ("CPST"), and other treasury data analytics needs as the WAL moves towards LFI. This includes assisting with implementing a Treasury Data Mart framework, building advance and efficient reports, presentations, and related analytics for Corporate Treasury. What we are looking for: Assist in coordinating data for the Treasury Data Mart in SQL Server/Azure environment to support the information required for ALM, LPST and CPST efforts related to LFI (e.g. 2052a, CCAR). Organize and document all data sources, key attributes, assumptions, relational data/hierarchies, and related aspects, for treasury managers, relevant committees, and external reporting. Execute any refinements to Treasury's data needs to meet the bank's strategic direction, changing business and market environments, new business initiatives, regulatory and audit requirements. Position is key to supporting the evolving data needs for corporate treasury to assist with ALM, liquidity and capital management decisions. Assist with the governance and documentation over all key information necessary to support corporate treasury data management needs particularly as it relates to LFI workstreams such as 2052a and CCAR. Assist analytics that provides insights to bank products, various key metrics, and how they affect bank's earnings, liquidity, and capital. Assist with any second line and third line of reviews to close and address any findings and observations relevant to treasury data management. Write quality SQL queries to achieve data analytic and reporting tasks and improve efficiency. Qualifications Bachelor of Science/Art in Finance, Mathematics, Engineering, Business Administration, or Economics; 2+ years of previous related work experience may be substituted for educational requirements. MS/MA degree or MBA preferred. Strong knowledge of relational databases, SQL/Python, business intelligence tools (Microsoft BI, Tableau), MS Office and Advanced Excel preferred. Strong analytical and problem-solving skills A team player with strong communication and interpersonal skills and a bias for action. Working knowledge of banking business, balance sheet, and income statement Benefits you'll love: We offer all the important things you'd want - like competitive salaries, an ownership stake in the company, medical and dental insurance, time off, a great 401k matching program, tuition assistance program, an employee volunteer program, and a wellness program. In addition, you'll have the opportunity to bolster your business knowledge, learning the ins and outs of how successful companies operate and manage their finances, giving you invaluable hands-on experience to help grow your career! About the company: Western Alliance Bank is a wholly owned subsidiary of Western Alliance Bancorporation. Alliance Bank of Arizona, Alliance Association Bank, Bank of Nevada, Bridge Bank, First Independent Bank, and Torrey Pines Bank are divisions of Western Alliance Bank; Member FDIC. AmeriHome Mortgage is a Western Alliance Bank company. Western Alliance Bancorporation is committed to equal employment and will consider all qualified applicants without regard to race, sex, color, religion, age, nation origin, marital status, disability, protected veteran status, sexual orientation, gender identity or genetic information. Western Alliance Bancorporation is committed to working with and providing reasonable accommodations for individuals with disabilities. If you are an individual with a disabi