Senior Salesforce ETL Developer 1

Scotiabank; Bogotá; Hybrid; COP 120,000,000 - 160,000,000; Full time

Benefits offered by this job

Diversity & Inclusion

Job summary

Scotiabank's ScotiaTech in Bogota seeks a Senior Salesforce ETL Developer to design and implement scalable data workflows, focusing on data ingestion, transformation, and real-time/batch pipelines.

You will collaborate with GBME teams, business partners, and architects to deliver high-performance analytics solutions on the Salesforce platform, using ETL tools like Talend and modern languages.

Qualifications

• 5+ years of experience as a data engineer on large-scale analytics.
• Experience with Salesforce platform data workflows and ETL/ELT.
• Proficient in Python or Java.
• Strong SQL and data modelling knowledge.
• Experience with Talend or similar ETL tools.
• Familiar with GitHub, JIRA, and Agile practices.
• Bachelor’s degree in CS or Engineering.

Responsibilities

• Design and implement data workflows and integration.
• Develop scalable data pipelines for real-time and batch processing.
• Collaborate with architecture on design and integration.
• Maintain and enhance Salesforce data ingestion and transformation.
• Participate in SCRUM and produce production-grade code.

Skills

Data Engineer

Salesforce platform

ETL/ELT

Python/Java

Agile Methodology

SQL/Databases

Education

Bachelor's degree in CS/Engineering

Tools

Talend

GitHub

Jira

Confluence

Jenkins

Job description

Title: Senior Salesforce ETL Developer 1

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

What's in it for you?

• Di versity, 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.