Analytics Consultant

• Consult with business line and enterprise functions on less complex research
• Use functional knowledge to assist in non-model quantitative tools that support strategic decision making
• Perform analysis of findings and trends using statistical analysis and document process
• Present recommendations to increase revenue, reduce expense, maximize operational efficiency, quality, and compliance
• Identify and define business requirements and translate data and business needs into research and recommendations to improve efficiency
• Participate in all group technology efforts including design and implementation of database structures, analytics software, storage, and processing
• Develop customized reports and ad hoc analyses to make recommendations and provide guidance to less experienced staff
• Understand compliance and risk management requirements for supported area
• Ensure adherence to data management or data governance regulations and policies
• Participate in company initiatives or processes to assist in meeting risk and capital objectives and other strategic goals
• Collaborate and consult with more experienced consultants and with partners in technology and other business groups
• Develop and refine business intelligence and data visualizations using Power BI
• Perform strategic adhoc data analyses to support key business decisions
• Sourcing data from across multiple systems using a variety of database reporting applications (ORACLE, Teradata, SQL)
• Provide support/generate and distribute existing management information systems (MIS) reports in an accurate and timely manner
• Maintain reference data that supports the entire insights & reporting processes
• Develops MIS documentation to allow for smooth operations and easy system maintenance
• Support to automate reports by identifying the opportunities on existing process and reports
• Perform data analysis for generating reports on a periodic basis
• Create best-practice reports based on data mining, analysis, and visualization
• Identify trends and opportunities for growth through analysis of complex data sets
• Provide strong and timely financial and business analytic decision support to business partners and stakeholders
• Provide feedback and present ideas for improving or implementing processes and tools within the Analytics group
• Monitoring/quantifying success of business opportunities, sales campaigns and initiatives, and tracking progress towards revenue and profitability goals and targets
• Responsible for maintaining partnerships, ensuring high quality team deliveries and SLAs
• Designing and solving complex business problems by using analytical techniques and tools
• Works with large data sets, both structured and unstructured, and from multiple sources
• Will be involved directly in the technical build-out and/or support of databases, query tools, reporting tools, BI tools, dashboards, etc. that enable analysis, data visualization and/or advance analytics

2+ years of Analytics experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education

• Degree in quantitative fields such as applied math, Accounting, engineering, finance, economics, econometrics, computer sciences, or business/social and behavioral sciences with a quantitative emphasis
• 2+ years of experience in an environment that utilizes large relational databases such as SQL Server, Oracle, DB2, & Teradata
• 2+ years of experience developing complex SQL quires and other coding environments
• 2+ years of experience developing Alteryx solutions, Power BI, Tableau reports & other structured visualization solutions and automation tools
• Experience in Maintaining & creating efficient data solutions in order to support the Insights & reporting
• Experience in Treasury Management Products or Commercial Banking
• Partner Management experience with ability to effectively drive results, provide feedback/direction, and manage and build relationships with leaders and team members in a geographically dispersed team environment
• Excellent verbal, written and interpersonal communication skills
• Strong analytical skills with high attention to detail and accuracy