Senior Programmer Analyst with PHP, Python and SQL

Requisition ID: 218707

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.

Purpose

Contributes to the overall success of the Back Office Applications/CCA (Caribbean and central America) Technology, International Banking in Canada (Supporting CCA region) ensuring specific individual goals, plans, initiatives are executed / delivered in support of the team's business strategies and objectives. Ensures all activities conducted are in compliance with governing regulations, internal policies and procedures.

Accountabilities

• Champions a client centric culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge.
• Creating design procedures, write codes, perform testing, debug, trouble shoot technical issues and maintain source code of computer programs to support daily operations of back-office applications.
• Assist in creating technical documentation, objectives, and deliverables required to support technical troubleshooting and incident management.
• Assist with technical analysis based on business requirements, create test cases, and perform testing to support delivery of technical solutions.
• Understands how the Bank's risk appetite and risk culture should be considered in day-to-day activities and decisions.
• Actively pursues effective and efficient operations of their respective areas in accordance with Scotiabank's Values, its Code of Conduct and the Global Sales Principles, while ensuring the adequacy, adherence to and effectiveness of day-to-day business controls to meet obligations with respect to operational, compliance, AML/ATF/sanctions and conduct risk.
• Champions a high-performance environment and contributes to an inclusive work environment.

Dynamics specific to the role

• Countries / regions/business units supported/ Back Office Applications (Canada & CCA region)
• Financial dimensions (e.g., capital budget, annual project cost, operating budget, etc.)
• Regulatory bodies and special requirements/ Comply with Scotiabank's IT Risk standards.

The incumbent is responsible for the supporting the following:

• Work with business partners to define their needs
• Good to have: Perform and develop data ingestion and extract request from EDL/Data Lake/Data Stage platform or other data source based on user request.
• Interpret data, analyze results using statistical techniques and provide ongoing support.
• Responsible for the solutioning & development of data related initiatives.
• Identify, analyze and interpret trends or patterns in complex data sets
• Filter and "clean" data
• Assist junior staffs to fulfil their assignment.
• May be required to provide off hour support for the ETL data related tasks.
• Good knowledge of Incident, Change management process and Service Requests, etc.

Education and experience:

Must have

• Extensive hands-on experience in PHP, Python, SQL, .Net, IIS, Java, HTML, Power BI, MS Office and MS Access etc.
• Hands on experience with Application support that requires knowledge and experience with bitbucket, JIRA and confluence (Agile methodologies)
• Experience of working in technology projects / supporting systems like ETL process (SSIS),

• Hands on Technology projects / supporting systems like ETL process (SSIS)
• Experience with SQL/NOSQL, scripting, automation, computing in the cloud, and application monitoring technologies.
• Working knowledge of at least one or more programming languages (JavaScript, Java, .NET, Python, Perl, Python, PHP, Bash, XML, HTML, C/C++/C#, RegEx, etc.)
• Bachelor's degree in computer science or mathematics or Statistics.
• Adept at queries, report writing and presenting findings

Asset to have

• Proven working experience as a data analyst or related education.
• Technical expertise regarding data models, data mining, segmentation techniques, and Machine learning. Willing to learn or a fast learner
• Working knowledge of and experience with reporting packages (tableau, Power BI or Cognos)
• Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel).
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
• Experience with the usage of GitHub (or Git version control systems).

• Experience working in an agile development environment (Confluence, Jira, CiAD pipeline, Scrum/Kanban).

• Experience working with Sterling File Gateway is an asset.

What's in it for you?

• Diversity, Equity, Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential, respected for who they are, and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employee to learn, grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities, ethnicity, race, age, ability & veterans.
• Accessibility and Workplace Accommodations - We value the unique skills and experiences everyone brings to the Bank and are committed to creating and maintaining an inclusive and accessible environment for everyone. Scotiabank continues to locate, remove, and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements.
• Remote-friendly work environment will provide you with the flexibility to perform at your best.
• Upskilling through online courses, cross-functional development opportunities, and tuition assistance.
• Competitive Rewards program including bonus, flexible vacation, personal, sick days and benefits will start on day one.
• Community Engagement - no matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs such as hackathons, contests, cooking with friends, Humans of Digital and much more!

#Li-Hybrid

#PHP

#Python

#SQL

Location(s): Canada : Ontario : Scarborough

Scotiabank is a leading bank in the Americas. Guided by our purpose: "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capital markets.

At Scotiabank, we value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our Recruitment team know. If you require technical assistance, please click here. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.