BI Analytics Solutions- Associate

Are you a skilled data professional with a passion to transform raw data into actionable insights, and a demonstrated history of learning and implementing new technologies The Finance Data & Insights Team is an agile product team responsible for the development, production, and transformation of Financial data and reporting across CCB. Our vision is to improve the lives of our people and increase value to the firm by leveraging the power of our data and the best tools to analyze data, generate insights, save time, improve processes & control, and lead the organization in developing skills of the future.

As an Analytical Solutions Associate within the Consumer and Community Banking Finance Data & Insights Team, you will join an agile product team responsible for the development, production, and transformation of financial data and reporting across Consumer and Community Banking.

Job Responsibilities:

• Develop data visualization solutions utilizing ThoughtSpot/Tableau that provides intuitive insights to our key stakeholders
• Develop and enhance Alteryx workflows, collecting data from disparate data sources and summarizing the data as defined in requirements gathering with the stakeholders. Follow best practices to ensure that data is sourced from authoritative data sources
• Conduct thorough control testing of each component of the intelligence solution providing evidence that all data and visualization are providing accurate insights and evidence in the control process
• Seek to understand the stakeholder use cases empowering you to anticipate stakeholders requirements, questions, and objections
• Become a subject matter expert in these responsibilities and support team members in becoming more proficient themselves
• Lead intelligence solution requirements gathering sessions with varying levels of leadership, complete detailed project planning utilizing JIRA to record planned project execution steps

Required qualifications, capabilities, and skills

• Bachelor's degree in MIS or Computer Science, Mathematics, Engineering, Statistics or other quantitative or financial subject areas
• Experience with business intelligence analytic and data wrangling tools such as Alteryx, SAS, or Python
• Experience with relational databases optimizing SQL to pull and summarize large datasets, report creation and ad-hoc analyses
• Experience in reporting development and testing, and ability to interpret unstructured data and draw objective inferences given known limitations of the data
• Demonstrated ability to think beyond raw data and to understand the underlying business context and sense business opportunities hidden in data
• Strong written and oral communication skills ability to communicate effectively with all levels of management and partners from a variety of business functions

Preferred qualifications, capabilities, and skills

• Experience with Hive, Spark SQL, Impala or other big-data query tools. Experience with ThoughtSpot or similar tools empowering stakeholders to better understand their data.
• Highly motivated, self-directed, curious to learn new technologies. AWS, Databricks, Snowflake, or other Cloud Data Warehouse experience
• Minimum 5 years experience developing advanced data visualization and presentations preferably with Tableau
• Minimum of 8 years experience working with data analytics projects, preferably related to financial services domain