The Enterprise Risk Management BI Analyst II performs research, data extraction and analysis, building data and analytical tools, and providing risk modeling to support risk quantification, forecasting, and reporting.

Here's what you can expect from the job and what you need to be successful:

Job duties

• Develop complex financial and risk modeling specific to financial data, enterprise data as well as risk forecasting that supports critical decisions
• Write and execute SQL and/or Python code proficiently to create and produce monthly and quarterly reporting and provide recommendations based on analysis
• Aggregate data from multiple source systems to research and perform root causes analysis
• Angle for greater efficiency across all company data systems to maximize analysis and minimize data extraction
• Design, build, recommend, and implement infrastructure for data extraction, preparation, and loading of data from a variety of sources using SQL and AWS
• Validate data, recognize errors, and make modifications to programs to meet changing needs and recommend changes for approval and implementation
• Maintain the operating procedures' library and SQL and Python code for producing reports and models
• Prepare, deliver and/or present methodology and modeling results for external regulatory reporting, senior leadership, committees, and other business units
• Identify risk metrics to drive the business forward and turn data into valuable insights by leveraging creative solutions and communicating insights to key stakeholders
• Transform Enterprise Risk data using data visualization techniques to convey risk data in a relevant and compelling message

Essential skills

• Minimum 4 years' experience as a BI/Data Analyst, preferably in the financial services industry
• Experience applying and developing analytical methods, including data mining techniques
• Experience auditing code for bugs
• Ability to anticipate needs and prioritize projects in a fast-paced environment with tight deadlines and high-volume peaks while producing high-quality work
• Excellent verbal and written communication skills; able to express ideas concisely and logically to all levels
• Strong analytical and problem-solving skills with attention to detail
• Proficiency with a data visualization/dashboarding tool (such as Tableau)
• Advanced knowledge of analytical/quantitative tools such as Python, R, or SAS
• Excellent SQL skills and understanding of relational databases
• Advanced knowledge of Microsoft Office Suite, particularly Excel and VBA
• Minimum Education: Bachelor's degree in Finance, Statistical, Quantitative or related field is preferred

Location:Hillsboro, OR 97124 (HYBRID)

What makes First Tech different? Click here to learn more!

First Tech is not currently offering Visa sponsorship for this position

#FT123 #LI-EK

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)