• We are seeking a highly skilled Reporting Analyst - Expert to join our Regional Banking, Capacity and Analytics team.
• This role focuses on driving the simplification, automation, and transformation of the BFS AMP (Business Financial Services Analytics and Modeling Platform) to enable seamless business management.
• The successful candidate will leverage their expertise in data analytics, statistical techniques, and advanced programming to enhance data infrastructure, automate processes, and deliver actionable insights.
• This is a critical role within a dynamic team of five, dedicated to supporting commercial banking capacity reporting and analytics.

Department Overview:

• The Regional Banking, Capacity and Analytics team is a close-knit group of five professionals focused on delivering high-impact analytics and reporting solutions for commercial banking operations.
• Our team culture emphasizes collaboration, innovation, and precision, with a commitment to driving efficiency through data-driven insights.
• We work closely with business stakeholders to understand needs, streamline processes, and deliver solutions that empower the business to manage operations independently.

Key Responsibilities:

• A typical day in the life of a Reporting Analyst - Expert involves a blend of technical execution, stakeholder collaboration, and process optimization.

Responsibilities include:

• Process Simplification and Automation: Recommend and implement strategies to simplify and automate the BFS AMP, including enhancements to the data model, infrastructure, and automation processes, enabling a full transition from Technology & Operations (T&O) to business-managed operations.
• ETL Automation: Design and execute the automation of Extract, Transform, Load (ETL) processes for BFS AMP data, migrating from SAS to a modern architecture leveraging Python, DataIku, and Snowflake.
• Data Source Analysis: Evaluate the efficacy and resilience of data sources, validate underlying assumptions, and document end-to-end processes to ensure a smooth handover to the business for Business-As-Usual (BAU) management.
• Stakeholder Engagement: Collaborate with key business stakeholders to gather requirements, understand user needs, and communicate insights effectively.
• Data Visualization and Reporting: Create compelling, high-quality presentations using advanced MS PowerPoint skills to communicate analytical findings to stakeholders.

Project Details:
Project Name:

• BFS AMP (Business Financial Services Analytics and Modeling Platform)

Project Description:

• The BFS AMP project focuses on enhancing the analytics and modeling platform for commercial banking operations.
• The goal is to streamline data processes, automate reporting, and transition the platform to a fully business-managed solution.
• The Reporting Analyst -Expert will play a pivotal role in optimizing the data model, automating ETL processes, and ensuring robust documentation for sustainable business operations.

Essential Skills and Qualifications:
Must-Have:
Experience: 

• 7+ years in data analytics, visualization, and reporting, with hands-on experience applying statistical techniques.

Technical Skills:

• SQL: Advanced proficiency for data querying and analytics.
• SAS: Experience in data processing and analytics within SAS environments.
• Python: Proficiency in Python for data manipulation, automation, and analytics.
• DataIku: Familiarity with DataIku for data preparation and workflow automation.
• MS PowerPoint: Advanced skills in creating professional, visually compelling presentations for stakeholder communication.

Soft Skills:

• Strong ability to gather requirements and understand user needs.
• Exceptional communication skills to engage with business stakeholders effectively.
• Analytical mindset with attention to detail and problem-solving capabilities.

Languages: Proficient in English (written and verbal).

Nice-to-Have:
Education: Bachelor’s Degree in Business, Mathematics, Computer Science, or equivalent experience. CMA candidates or MBA preferred.

Technical Skills:

• Advanced MS Excel skills, including macros, pivot tables, VLOOKUP, and other advanced functionalities.
• Experience with Tableau for data visualization.
• Experience: Prior work in commercial banking or financial services analytics.