Lead Data Analyst

Come join us in Firm Analytics, where we strive to unleash the full potential of data and analytics to address business challenges. As a Lead Data Analyst on our team, you will design, develop, and deliver actionable insights and solutions by applying statistical concepts and analytic techniques such as root cause, exploratory, sensitivity and scenario analysis, as well as hypothesis testing and economic modeling.

You will combine data from multiple sources to develop innovative approaches and solutions to business problems. You will collaborate with business leaders and other team members to develop actionable insights and build a cohesive story to inform enterprise decision making and influence strategic planning. If you have a passion for delivering insights, problem solving, and developing solutions that drive action, Firm Analytics may be your next career choice!

• Proactively identify opportunities with medium to broad impact where analytics can inform the business. Provide actionable insights to support business decisions and long-term strategy development, primarily by performing root cause, exploratory, sensitivity, scenario analysis, hypothesis testing, economic modeling, regression, and data visualization to identify patterns/trends/insights on ambiguous business problems.
• Consult with business owners to understand the business problem. Able to independently identify the appropriate analytic approach to solve the problem. Lead others through analytic approach and leverage systems thinking to connect work to other strategic initiatives.
• Merge, cleanse and transform complex data from multiple sources as needed for analysis. Develop advanced logic to structure datasets for analysis.
• Understand and apply intermediate to advanced statistical concepts.
• Apply critical thinking to pressure test and validate logic and outputs against known sources and understanding of business.
• Proactively identify data quality issues and collaborate with other subject matter experts to identify solutions.
• Lead team to generate and incorporate insights into a cohesive story that clearly addresses business questions and influences decision making. Effectively lead the creation and communication of tailored messages to influence senior leaders regarding analytic ideas, approach, key takeaways and actionable insights.
• Serve as a technical and functional data subject matter expert across a wide range of areas and have a solid knowledge on data relationships and flows including product, client, marketing, compliance, branch, etc.
• Educate senior and executive leaders across the firm on analytical concepts and best practices.
• Consult on data and analytic requirements for database development and system changes.
• Actively participate in industry and trade data and analytic communities in order to bring fresh ideas to the organization.
• Maintain a strong understanding of firm results & key business drivers to apply understanding to analytic approach to influence and create key strategies and business performance.
• Maintain a strong understanding of data flows, sources, and data transformations across multiple domains.
• Develop, manage, and utilize business relationships and partnerships with cross-functional business owners, senior and executive leaders across the organization.
• Document, monitor, and proactively recommend improvements to processes and controls related to areas of responsibility.
• Proactively identify efficiency improvements and cost reduction opportunities with moderate to broad impact and visibility, propose solutions to relevant parties and drive implementation of solutions.

• Bachelor's Degree required with an emphasis in finance, business, economics, data science, math or analytics preferred.
• 7+ years related analytical work experience.
• 7+ years experience interacting with various database and file storage systems (DB2, IDMS, Oracle, Hadoop, No
  
  SQL).
• 7+ years experience with data manipulation languages such as SQL, Impala, PL/SQL, Hive, Pig, XML required.
• 7+ years experience using Microsoft Excel, including use of pivot tables, formulas, macros, VBA, charts/graphs.
• Advanced…