Senior Salesforce ETL Developer 1

Requisition ID: 275025

Thanks for your interest in ScotiaTech, Scotiabank's new and innovative Technology hub in Bogota.

Join a purpose driven winning team that promotes creativity and innovation in a fast-paced environment, where we’re always committed to results, in an inclusive, diverse, and high-performing culture.

The Team

Global Banking and Markets Engineering (GBME) is the fast-moving, award-winning technology engine that powers Scotiabank’s Corporate, Investment Banking and Capital Markets businesses.

The Role

GBME is searching for Software Engineers who are continuous learners and are eager to boost capabilities of capital markets products and analytics platforms.

The successful candidate will have a strong technical and engineering mindset. You will work closely with business teams and cross functional engineering leaders to develop and implement market leading solutions for the various projects within GBME.

About the Job

Do you thrive when faced with challenges? Like using fresh technologies to solve problems? Looking to work in various projects across the organization, collaborating with great teams and inspiring leaders? Then this is the right team for you! In this exciting role, you’ll apply your analytical skills to design and develop applications that deliver excellence, effectiveness, and value to our business partners and customers.

In partnership with peer engineers, business partners, and the various GBME teams, you will:

• Work closely with Business Analysts and Technical Analysts team to understand business needs and solution and implement Data workflows and integration
• Partner with Architecture on the design and integration
• Participate in data engineering and transformation design to ensure highly scalable, extensible, and performant solutions.
• Contribute to existing data ingestion, transformation and extraction solutions in Salesforce Platform
• Build/Maintain scalable data pipelines for both real time and batch using best practices in data modeling, ETL/ELT processes utilising various technologies.
• Create impact analysis document, User stories, Design workflows for implementation
• Deliver and enhance new and current solutions and multi-system integration
• Be involved in the full life cycle of a project, responsible for producing actionable and complete specifications, writing production quality code, and implementation
• Understand existing database schema, identify gaps and recommend solutions
• Design test sets and automate where possible (if needed)
• Write deployment scripts and leverage tools such as the Accelerator pipeline to promote code
• Support the solution in production (as and when required)
• Improve the end user experience by finding scalable solutions and addressing complex ad hoc queries.
• Effectively communicate with technical and non-technical audiences
• Able to work with and refactor legacy implementations
• Coach and train end users (as needed).
• Participate and run SCRUM Meetings (as needed).
• You are passionate about developing applications that are reusable, efficient, and scalable, working in an innovated cross functional team environment.

• Technical Qualifications

• 5+ years’ of industry experience designing, developing, deploying, and maintaining large scale applications with complex integration as Data Engineer.
• 5+ years’ of industry experience Design, implement and operate large-scale, high-volume, high-performance data structures for analytics
• Experience Data engineering in Salesforce platform
• Experience with 2 or more modern development languages in academic or recent work projects (Python, Java, etc.)
• Excellent understanding of database and data management concepts and technologies
• 4+ years of Experience on working with Talend or similar ETL (Extract-Transform-Load) tools
• Working experience with GitHub, JIRA, Confluence,DevOps, Jenkins pipelines, and code promotion
• Experience with UNIX Shell scripting in Sun Solaris/Linux environments
• Experience working in an Agile environment, with experience and understanding of Test-Driven Development methodology.
• Bachelor’s degree in computer science, Engineering or relevant experience.

• Soft Skills

• Excellent communication and presentation skills.
• Work as a contributing member of a team.
• Values quality, while still managing expectations and deliverables.
• Open to ideas and gives and receives feedback well.
• Wants to understand financial market.

• Preferred Qualifications

• Experience with some automated deployment.
• Understanding of networking protocols and security principles
• Capital Markets product knowledge
• Cloud, Kubernetes experience

• 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.

Location(s): Colombia : Bogota : Bogota

ScotiaTech is a business unit within ScotiaGBS, a Scotiabank Group company located in Bogota, Colombia. The ScotiaTech hub was created to support different technology systems and processes of the Bank. We offer an inclusive, positive work environment, and competitive benefits.

At ScotiaTech, we value the unique skills and experiences each individual brings and are committed to creating and maintaining an inclusive and accessible environment for everyone. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at ScotiaTech; however, only those candidates who are selected for an interview will be contacted.

Note: All postings in me@Scotiabank will remain live for a minimum of 5 days.