Data Analyst - Retail Banking (SUMMER INTERN - JUNE & JULY)

Analyst will be responsible for gathering and defining requirements and creating functional output from various applications and systems for the Retail team. 

This position is responsible for working on assigned projects as well as maintenance items. Preparing technical requirements documentation, writing and documenting code, debugging technical issues, providing QA, and assisting in creating support documentation for applications are examples of tasks you will be performing.

• Collaborate with Retail team to develop requirements and build data dashboards based on data requirements for various data points.
• Partner with Data and Analytics team for training on Power BI and other tools to effectively create materials that meet the specifications.
• Implement strategies for gathering, reviewing and analyzing requirements to prepare source data for effective data visualization and dashboards.

Job Duties Include:

• Assist in collecting and organizing data from various sources, including databases, file shares, and external data sets, ensuring accuracy and completeness for analysis.
• Perform preliminary data analysis to identify trends, patterns, and anomalies within large datasets using statistical tools and software.
• Write and execute queries to retrieve information from databases for specific analysis projects, ensuring data integrity and efficiency.
• Collaborate with cross-functional teams to understand data needs and deliver actionable insights through data analysis.
• Participate in the design and implementation of new data collection and analysis methodologies to improve the quality and efficiency of data-driven decision-making processes.
• Document analytical methodologies, coding procedures, statistical findings and progress reports to ensure transparency and reproducibility of results.
• Support the maintenance and troubleshooting of data analytics tools and software, including performing updates and ensuring compatibility with data sources.

Education:

• Junior or senior year bachelor’s student or graduate student in Computer Science, Mathematics, or related field.

Experience/Skills:

• Innovative problem solving
• Self-starter, proactively seeks direction and asks questions to gain clarity
• Meticulous attention to detail and organization skills
• Strong written and verbal communication skills
• A strong candidate will be familiar with PowerBI, SQL, Data Visualization, Statistical Analysis, Python Programming, ETL practices.

Project Description

Cross sell, wallet share, sales penetration figures

• Our goal for this project would be to be able to present to ELT what our retail networks cross sell ratio is. We currently have no concrete way to track these figures. Utilizing Sales tracker and core data, this project would require utilizing power BI to calculate cross sell ratios based on criteria provided. We are looking to calculate information include cross sell ratio for consumer and business, cross sell ratio by branch, region and banker, cross sell ratio trends over time ad other relevant data calculations.