Product Control Data Analyst

Bonus Type

Summary

BOK Financial is committed to fostering long-term client relationships by attracting top talent. The company emphasizes innovation, growth, and teamwork, providing a dynamic environment for employees to excel. At BOK Financial, we believe in the power of being one team. Success is achieved through a dedication to high standards, a passion for excellence, and a collaborative spirit that unites us in our mission.

Job Description

As Product Control Analyst, you will work closely with Market Risk, Information Technology, and Middle Office functions to develop a strong understanding of fixed income securities. You will play a key role in ensuring the integrity of financial statements, providing independent control of revenue reporting, performing independent price verification (IPV) for fixed income securities and offering accounting support. This is an excellent opportunity to collaborate with various front and back office support functions to promote robust controls and new business initiatives.

Team Culture

Every day, our team members push the boundaries of what’s possible, striving for excellence with our teams, clients, and business. As a financial institution that breaks the mold, we focus on building relationships through expertise and sound advice, rather than merely promoting products. Join us to build your career, fuel your curiosity, develop lasting relationships, and make a real impact. Even after more than a century, we’re more excited than ever about our future. 

How You'll Spend Your Time

• You will develop complex SQL Server queries for various income analyses.
• You will conduct detailed P&L research using data from multiple trading systems.
• You will collaborate extensively with traders, market risk, and financial reporting teams.
• You will utilize advanced Excel, Visual Basic, and SQL skills to enhance report creation and accuracy.
• You will work closely with trading teams to gain deeper business insights.
• You will assist in portfolio pricing, price challenges, and improving financial reporting processes.

Education & Experience Requirements

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 1 - 5 years of experience within Product Control, Financial Control, Accounting, Market Risk or related area. 

• Strong technical skills using Excel and PowerPoint
• Previous direct Profit & Loss or risk experience is preferred
• Solid understanding of Fixed Income products, including Derivatives, would be advantageous
• Experience with analytics software and relational databases
• 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 trading system
• Knowledge of front office trading systems
• Knowledge of mortgage trading and mortgage trading strategies a plus
• 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.