Brokerage Strategy Analyst

Scottrade, Inc., a financial services firm, partners with more than three million retail clients to provide the trading services and investment solutions they need to overcome barriers to financial success. Founded in 1980, Scottrade pairs its large nationwide branch network with advanced online products and services to help clients gain insight into the market and react quickly to trading opportunities.

The main purpose of this position is to gain insights through data analysis for both tactical and strategic business initiatives. This position will support the Brokerage Strategy and Product team and will be instrumental in helping to maintain data integrity and to drive results.

* Drive an analytical project from start to finish by gathering requirements, analyzing data, soliciting feedback and presenting findings to management. * Utilize Microsoft SQL Server Management Studio, Oracle Business Intelligence and standard data warehouse tools and techniques to mine large data sets. * Analyze large volumes of data using Microsoft Excel and/or Tableau to identify business opportunities and efficiencies using statistical analysis * Build Microsoft PowerPoints to share insights with Brokerage Strategy Manager and management. * Assist Brokerage Strategy Manager on key projects. * Create and deliver routine reports on key performance indicators (KPI’s) on a weekly, monthly or quarterly basis. * Identify and implement best practices to streamline data requests and reports. * Collaborate with business partners to create and analyze ad-hoc reports on business initiatives. * Complete special projects and other duties as assigned.

**Knowledge, Skills And Abilities Required:** * Demonstrated initiative to work independently and effectively without supervision. * Proven analytical and problem solving abilities. * Ability to grasp complex information quickly and accurately. * Strong technical abilities with a desire and eagerness to acquire new skills. * Ability to craft reports from varying systems, analyze and interpret data with strong attention to detail. * Ability to design charts and graphs and effectively present information analyzed from systems. * Capable of working in a fast-paced environment with strong organizational skills. * Advanced level proficiency with Microsoft Excel and PowerPoint. * Foster company success through a professional appearance, being courteous to customers and all Scottrade associates and by having a positive attitude **Physical Activites & Requirements, Visual Acuity, Working Conditions And Noise Level:** * While performing the duties of this job, the employee is required to sit, talk, hear, and use hands to finger, handle or feel objects, tools or controls. * The physical requirements of this position are considered to be sedentary work (Exerting up to 10 pounds of force occasionally and/or negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects. Sedentary work involves sitting most of the time.). * While performing the duties of this job, the employee is required to have close vision (clear vision at 20 inches or less in order to view a computer screen) and color vision (ability to distinguish colors). * The noise level in the work environment is considered moderate (business office with co-workers, copiers, shredders, printers, etc.). **Contacts With Others:** Contacts with other persons within the department on routine matters as well as regular contact with other departments, or outside the organization furnishing or obtaining factual data requiring ordinary courtesy and tact. May need to regularly utilize specialized communication skills in order to maintain goodwill with internal and external contacts. **Minimum Education & Experience:** * Bachelor’s degree in Finance, Business, Computer Science, Information Technology, Statistics, or Mathematics, or equivalent combination of education and experience required. * 2+ years of data analysis and experience extracting data into usable formats (Excel, Powerpoint, etc.) * Experience with data warehouse tools and techniques; SQL skills preferred.