Business Intelligence Analyst I, Operations
Role details
Job location
Tech stack
Job description
As a member of the Client Fee Billing Department, you will be responsible for ensuring the accuracy, timeliness, and efficiency of the firm's fee billing functions, supporting both the U.S. and Canada. Primary responsibilities include the support of branch exception requests & review, weekly oversight and system controls reviews, and data analysis. In addition, these functions include the day to day oversight and verifications of the collections of fees for client accounts, and payments made to external asset managers. What You'll Do: The Business Intelligence Analyst I will partner closely with product teams, leaders, and business areas across the firm to move automation and transformation strategies into execution, helping to design and enhance business processes with simplicity and transparency while creating capacity for our business areas.
Here are a few of the Key Responsibilities:
- Partner with functional leaders to conceptualize and recommend client fee billing solutions for enabling firm policies and strategies.
- Partner with product teams and business areas in the design, development, and implementation of fee billing solutions
- Conduct analysis that facilitates the transformation of complex data/information into actionable insights. Includes advanced financial analysis, forecasting, and financial modeling responsibility
- Frequent verbal & written presentation of analysis, as well as presentation of firm strategic information and analytical insights to firm leaders
- Build strong firm-wide awareness and acumen of the impact of firm strategies and business activities on branch compensation programs through education and ongoing projects
- Participate in and frequently lead cross-functional teams responsible for implementing projects in support of divisional or firm-wide business objectives
- Champion the innovation and evolution of existing processes, controls, and technology in order to meet the changing needs and increasing complexity of the organization
- Proactively identify opportunities with moderate to broad impact and visibility, propose solutions to relevant parties and drive implementation of solutions
- Develop and manage business relationships with leaders and associates across the organization
- Maintain existing PowerBI, Pentaho, and Macro Key reports to ensure accuracy and regulatory compliance
- Maintain existing controls and oversight timely to meet regulatory and audit requirements
- Serve as security coordinator for the department to ensure appropriate access is controlled, monitored, and applied as appropriate
Requirements
Do you have experience in VBA?, Do you have a Bachelor's degree?, * Bachelor's degree with an emphasis in a business discipline such as accounting, finance, economics, data science or analytics (or relevant work experience).
- FINRA Series 7 license & SIE required
- Financial analysis, forecasting, and financial modeling skills
- A proficiency using BI/visualization software including PowerBI & Pentaho
- Advanced Microsoft Excel, Word and PowerPoint skills required including working ability to utilize pivot tables, VBA, advanced charting, advanced formulas, conditional formatting.
- Ability to (or ability to learn to ) manipulate large data sets with SQL, BI tools
- Basic understanding of accounting processes and financial statements
- Ability to independently and collaboratively manage multiple priorities, adapting quickly to changing demand
What Could Set You Apart:
- Working understanding of agile product management
- A proficiency in using Business Intelligence and data extractions tools such as SQL or Power Query
- Experience with or knowledge of financial business processes with incentive compensation experience
- 4+ years of relevant work experience
- MBA or Master's degree in relevant field preferred
Benefits & conditions
Pulled from the full job description
- AD&D insurance
- 401(k)
- Health insurance
- Vision insurance
- Health savings account
- Dental insurance
- Flexible spending account