SQL Developer

We are looking for a SQL Developer! Reach out if you are interested and feel free to refer friends/colleagues!

Brief Description on Duties:

Typical Day in Role

• Working with BA and project managers and essentially implementing the relationships data base objects
• Take technical descriptions and create procedures, functions, manuals, etc.
• Work with senior management, technical and client teams in order to determine data requirements, business data implementation approaches, best practices for advanced data manipulation, storage and analysis strategies
• Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions
• Design, implement, automate and maintain large scale enterprise data ETL processes
• Modify existing databases and database management systems and/or direct programmers and analysts to make changes
• Test programs or databases, correct errors and make necessary modifications

Candidate Requirements/Must Have Skills:

• 8+ years of experience of SQL development – preferably within a bank or similar FI
• 3+ years of experience with Oracle RDBMS and Oracle SQL*Plus
• Recent experience with all of ServiceNow, JIRA, and Confluence is required

Nice-To-Have Skills:

• Experience with UNIX shell scripting
• Backend development (Python, C#, C++, Java, all acceptable) experience is highly preferred
• AML/ATF experience is an asset
• Spanish speaking is an asset, but not critical to success

Soft Skills

• Strong communication skills both written and verbal
• This is a very technical role, communication is not the most important aspect
• Candidate must be a team player, that does not need to be micromanaged – wants someone who can get up and hit the ground running everyone morning without necessarily being told what to do
• Ability to manage assigned tasks and expectations without direct instruction or oversight
• Fast, adaptable learner who can hit the ground running
• Ability to work well under pressure while demonstrating strong professionalism
• Must be able to collaborate closely with a team at times, while also being capable of holding themselves accountable to meet individual deadlines without hand holding

Best vs Average: Top two must-have skills are central to this role. Top profiles will have previous AML and/or Scotiabank experience, and a familiarity with internal processes. Good fits for this role are coming from roles such as: Database developers (non-administrative), Oracle developers, etc. and have a strong capacity to write database code.

Degrees or certifications:

• Bachelor’s degree or equivalent in a technical field such as computer science, computer engineering or related field required
• Any Oracle Database certifications are preferred