Senior Programmer Analyst with PHP, Python and SQL

Senior Programmer Analyst with PHP, Python and SQL

CAD 70,000 - 110,000

Title: 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, writing code, performing testing, debugging, troubleshooting technical issues, and maintaining 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 supporting the following:

• Work with business partners to define their needs.
• Good to have: Perform and develop data ingestion and extract requests from EDL/Data Lake/Data Stage platform or other data sources based on user requests.
• 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 staff to fulfill their assignments.
• May be required to provide off-hour support for the ETL data-related tasks.
• Good knowledge of Incident, Change management process, and Service Requests.

Education and experience:

Must have

• Extensive hands-on experience in PHP, Python, SQL, .Net, IIS, Java, HTML, Power BI, MS Office, and MS Access.
• 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).
• Experience with SQL/NOSQL, scripting, automation, computing in the cloud, and application monitoring technologies.
• Bachelor’s degree in computer science, 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, CI/CD 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.
• 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.
• 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!