BOK Financial Looking for PnL Data Analyst at Oklahoma City, OK  Full Time

We’ve built a culture at BOK Financial where amazing people (like you) can bring their best, be their best, and work for the best. You’ve come to the right place to grow your career.

The PnL Data Analyst manages the data aggregation and analysis process for the PnL Department. This position requires an intermediate to advanced skill level in data extraction, analysis and reporting. In addition, a familiarity with accounting principles that will be used to reconcile and explain differences between the various trading desks and general ledger is needed.

Our team is small but dynamic! While independent work is essential in our group, we welcome cohesion to ensure a job is well done. Managers focus on developing skills and empowering employees to be the best they can in their careers.

• You will develop and maintain Power BI analytical and executive dashboards
• You will develop sophisticated Microsoft SQL Server data queries to support multiple income analyses
• You will perform in-depth income research on trades utilizing data from Bloomberg Toms (Trade Order Management system), Impact (back office system) and Ion (front office trading system)
• You will analyze differences between general ledger system and front office income calculations to determine the root cause(s) and determine appropriate resolution
• You will serve as a liaison between internal IT support and the business unit to coordinate Power BI implementations and other income research / analytical projects
• You will serve as a liaison between Risk Management Group and the business unit to research and resolve income anomalies
• You will leverage advanced Excel, Visual Basic and SQL knowledge to create new management reports and improve efficiency and accuracy of preparation of existing reports
• You will work with internal business process robotics / automation group to identify and implement robotics to improve the dependability and efficiency of business processes
• You will assist in the preparation and administration of 3rd party portfolio pricing and price challenge process
• You will collaborate with senior team members, assist with the development and implementation of robust analytical models that provide independent valuation and riskassessments of securities and derivatives to support business line decision making, risk management and financial reporting
• You will develop financial reporting systems in other areas of the bank dealer and broker dealer to generate accurate financial / income reports on a daily basis.

This level of knowledge is normally acquired through completion of a Bachelor’s Degree in MIS, Business, Finance, Accounting or related field of study and 3-5 years of directly related experience and/or 8 years of combined education and experience.Masters or MBA preferred.

Ability to manage and analyze large volumes of data utilizing Excel and / or Visual Basic
Experience building / maintaining Power BI executive and analytical dashboards
Ability to develop and maintain SQL queries of moderate complexity
Knowledge of back office derivative financial systems (Broadrige Impact experience a plus)
Knowledge of front office derivative financial systems (Ion system experience a plus)
Knowledge of mortgage trading and mortgage trading strategies a plus Self-motivation, discipline, task focus, and a proven record of delivering high quality results within strict deadlines
Intellectual curiosity; superior problem-solving abilities and attention to detail; and prompt follow-through
Ability to aggregate and synthesize complex data from multiple sources
Developing oral and written communication skills to effectively represent self and BOKF, as well as ability to present complex information and issues in a clear and concise manner
Experience in data structuring and analysis to support management decision making
Experience with Microsoft Power BI dashboards and Power BI Pro / server implementations
Experience with Microsoft SQL Server reporting and data queries
Experience building complex Microsoft Excel spreadsheets
Demonstrated ability to build and review complex mathematical / data transformations to support the analysis of derivatives securities transactions