Int Data Analyst to Develop, code, validate and deliver complex applications and reports (VBA,PYTHON) for a large financial bank 45072

Details
# of positions: 1
Location: Remote for now but will be required to go back onsite once COVID restrictions are lifted (hybrid environment: 1 – 2 days per week)
 King Street West
Start Date: asap
Duration: 6 months from the start date
Extension possible: Yes 
Conversion Possible: Yes




SUMMARY OF DAY TO DAY RESPONSIBILITIES:

Department Overview:

• The Process Improvement Technology and Transformation (PITT) team is a business facing department that designs, tests and implements straight through processing applications to support the Canadian Personal Banking space. Canadian Personal Banking (CPB) Operations is responsible for end to end Money Out & Money In operation functions and capabilities across Canadian Personal Banking (CPB) and Business Banking (BB) products. We collaborate closely with business partners to deliver a legendary experience to distribution teams and customers.
• Channels & Partners Supported: Real Estate Secured Lending, Personal Lending, Credit Cards, Business Banking, Everyday Banking, Wealth and Personal Savings & Investments.
• Our team Autonetics is under the PITT and is responsible for automated solutions using various tools such as VBA, SQL, Java and Python. We have designed over a 100 small, medium and large applications that also include Canadian and US credit cards.

Job Description / Accountabilities

• Reporting to the Manager of Autonetics the primary accountabilities of the Senior Data Analyst role are:
• Multiple years of data experience (Tableau Visualization SQL, Python and VBA)
• Develop, code, validate and deliver complex applications and reports that serve our business partners
• Requires dedicated management and accountability for the delivery of required data pulls and reporting to help the program in product development and launch of new digital capabilities.
• Lead and drive strategic projects within the team and partner with key Stakeholders
• Assist with delivery of new business metrics and operational efficiencies
• Provide consultation for Business Units regarding application criteria and process flows
• Support new team members through skills and knowledge transfer
• Participate fully as a member of the team, participate/assist in departmental committees providing insight and recommendations, and contribute to a positive work environment
• Actively seek to broaden and increase knowledge of new reporting tools and systems

Qualifications / Skills / Experience:
• 2+ years of reporting experience (VBA, SAS, JCL, ISPF) and/or using SAS Enterprise Guide (SAS, SQL)
• Strong understanding of CPB and/ or Credit Card lines of businesses supported (including but not limited to Retail Products, Credit Cards, Risk Management etc.) an asset
• Knowledge of host applications including CIF and/ or TS2 technical environments and applications supported is an asset
• Experience with data warehouse and Business BINS
• Demonstrated proficiency with Microsoft Word, Excel, PowerPoint, Access, Project, Visio
• Experience with SharePoint development is an asset
• Ability to quickly understand, acquire and apply new technical skills
• Excellent analytical and problem-solving skills
• Innovative and conceptual thinker, results oriented
• Superior time management skills: be able to manage multiple assignments with competing priorities successfully
• Observed leadership abilities and desire to assume responsibility for deliverables
• Flexibility to adapt and manage within a dynamic and fast paced environment
• Ability to work independently and as part of a larger team
• Ability to analyze scenarios to reach acceptable compromises between technology impacts and customer service
- Standup meeting every morning
- Business Operations Department that builds technology builds
o Technically the business side but works closely with IT teams
- Work on 1 or 2 applications
- End to end micro projects (durations of about 1-2 months)
- Build things that are net new
-Looking for someone with VBA on a designer level as opposed to a maintenance level


MUST HAVE:

• VBA/Excel Coding Experience – 2 years (most important skill)
• Strong MS Access – 2 years
• Strong communication skills (verbal and written)
• Analytical Mindset

NICE TO HAVE:

• Tableau Visualization – 2 years (most important skill)
• Programming background (python, HTML or java)
• Previous banking experience