Know ATS Score
CV/Résumé Score
  • Expertini Resume Scoring: Our Semantic Matching Algorithm evaluates your CV/Résumé before you apply for this job role: Data Engineering Applications Specialist ETL.
Colombia Jobs Expertini

Urgent! Data Engineering Applications Specialist ETL Job Opening In Bogota – Now Hiring Scotiabank

Data Engineering Applications Specialist ETL



Job description

Data Engineering Applications Specialist ETL



Requisition ID: 235898



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.



**Purpose**



The ETL Developer will contribute to the overall success of the Global Enterprise Technology – Corporate Security globally by designing and implementing end to end ETL solutions from data analysis, data modeling to ETL.



**Accountabilities**



+ Champions a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge.

+ Build best in class ETL solutions, and will be working closely with Product Owners, Developers, Scrum Masters, Project Management and Stakeholders.

+ Analyze highly complex business rules and logic and translating those into technical implementations

+ Perform data wrangling to merge disjointed data sources and implement complex data transformation

+ Develop ETL process using MS SQL Server BI stack, SQL Server Integration Services and MS Azure Data Factory to ingest, transform, cleanse and load data into on-prem SQL Server 2017, 2019 and/or Azure SQL DB

+ Conduct source data analysis and profiling to complete source to target mapping

+ Logical and physical data modeling to develop highly optimized data infrastructure for fast querying of large volume of data • Assure data quality, security, and compliance requirements are met

+ Provide proactive support and maintenance to the existent ETL solutions to keep them at its best of quality

+ Take ownership of bugs, defects, enhancements or any assignment end to end

+ Understand how the Bank’s risk appetite and risk culture should be incorporate into in day-to-day activities and decisions.

+ Actively pursues effective and efficient operations of his/her 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.



**Education / Experience / Other Information**



+ Bachelor's degree in a technical field such as computer science, computer engineering or related field required

+ 3 years of experience in designing, developing, and deployment of large-scale data warehouse projects from end to end

+ Expert knowledge and hands on experience with SQL Scripting: 3 years

+ Expert knowledge working with SQL Server SSIS, Integration Services Catalog and project deployment and Azure Suite – 3 years

+ Experience working with Agile methodology – 3 years

+ Experience working with BitBucket or TFS, and creating DevOps pipeline (preferred)

+ Working knowledge of dimensional data modeling methodology

+ Strong English verbal and written communication skills

+ Nice to have Skills:

+ Experience working with data warehouse within Google Cloud Platform Degrees or certifications

+ Experience in Splunk (SPL)

+ Power BI

+ B1+ level of English.



**Working Conditions**



Work in a standard office-based environment; non-standard hours are a common occurrence.



#LI-Hybrid



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.


Required Skill Profession

Other General



Your Complete Job Search Toolkit

✨ Smart • Intelligent • Private • Secure

Start Using Our Tools

Join thousands of professionals who've advanced their careers with our platform

Rate or Report This Job
If you feel this job is inaccurate or spam kindly report to us using below form.
Please Note: This is NOT a job application form.


    Unlock Your Data Engineering Potential: Insight & Career Growth Guide


  • Real-time Data Engineering Jobs Trends in Bogota, Colombia (Graphical Representation)

    Explore profound insights with Expertini's real-time, in-depth analysis, showcased through the graph below. This graph displays the job market trends for Data Engineering in Bogota, Colombia using a bar chart to represent the number of jobs available and a trend line to illustrate the trend over time. Specifically, the graph shows 21769 jobs in Colombia and 131 jobs in Bogota. This comprehensive analysis highlights market share and opportunities for professionals in Data Engineering roles. These dynamic trends provide a better understanding of the job market landscape in these regions.

  • Are You Looking for Data Engineering Applications Specialist ETL Job?

    Great news! is currently hiring and seeking a Data Engineering Applications Specialist ETL to join their team. Feel free to download the job details.

    Wait no longer! Are you also interested in exploring similar jobs? Search now: .

  • The Work Culture

    An organization's rules and standards set how people should be treated in the office and how different situations should be handled. The work culture at Scotiabank adheres to the cultural norms as outlined by Expertini.

    The fundamental ethical values are:
    • 1. Independence
    • 2. Loyalty
    • 3. Impartiality
    • 4. Integrity
    • 5. Accountability
    • 6. Respect for human rights
    • 7. Obeying Colombia laws and regulations
  • What Is the Average Salary Range for Data Engineering Applications Specialist ETL Positions?

    The average salary range for a varies, but the pay scale is rated "Standard" in Bogota. Salary levels may vary depending on your industry, experience, and skills. It's essential to research and negotiate effectively. We advise reading the full job specification before proceeding with the application to understand the salary package.

  • What Are the Key Qualifications for Data Engineering Applications Specialist ETL?

    Key qualifications for Data Engineering Applications Specialist ETL typically include Other General and a list of qualifications and expertise as mentioned in the job specification. Be sure to check the specific job listing for detailed requirements and qualifications.

  • How Can I Improve My Chances of Getting Hired for Data Engineering Applications Specialist ETL?

    To improve your chances of getting hired for Data Engineering Applications Specialist ETL, consider enhancing your skills. Check your CV/Résumé Score with our free Tool. We have an in-built Resume Scoring tool that gives you the matching score for each job based on your CV/Résumé once it is uploaded. This can help you align your CV/Résumé according to the job requirements and enhance your skills if needed.

  • Interview Tips for Data Engineering Applications Specialist ETL Job Success
    Scotiabank interview tips for Data Engineering Applications Specialist ETL

    Here are some tips to help you prepare for and ace your job interview:

    Before the Interview:
    • Research: Learn about the Scotiabank's mission, values, products, and the specific job requirements and get further information about
    • Other Openings
    • Practice: Prepare answers to common interview questions and rehearse using the STAR method (Situation, Task, Action, Result) to showcase your skills and experiences.
    • Dress Professionally: Choose attire appropriate for the company culture.
    • Prepare Questions: Show your interest by having thoughtful questions for the interviewer.
    • Plan Your Commute: Allow ample time to arrive on time and avoid feeling rushed.
    During the Interview:
    • Be Punctual: Arrive on time to demonstrate professionalism and respect.
    • Make a Great First Impression: Greet the interviewer with a handshake, smile, and eye contact.
    • Confidence and Enthusiasm: Project a positive attitude and show your genuine interest in the opportunity.
    • Answer Thoughtfully: Listen carefully, take a moment to formulate clear and concise responses. Highlight relevant skills and experiences using the STAR method.
    • Ask Prepared Questions: Demonstrate curiosity and engagement with the role and company.
    • Follow Up: Send a thank-you email to the interviewer within 24 hours.
    Additional Tips:
    • Be Yourself: Let your personality shine through while maintaining professionalism.
    • Be Honest: Don't exaggerate your skills or experience.
    • Be Positive: Focus on your strengths and accomplishments.
    • Body Language: Maintain good posture, avoid fidgeting, and make eye contact.
    • Turn Off Phone: Avoid distractions during the interview.
    Final Thought:

    To prepare for your Data Engineering Applications Specialist ETL interview at Scotiabank, research the company, understand the job requirements, and practice common interview questions.

    Highlight your leadership skills, achievements, and strategic thinking abilities. Be prepared to discuss your experience with HR, including your approach to meeting targets as a team player. Additionally, review the Scotiabank's products or services and be prepared to discuss how you can contribute to their success.

    By following these tips, you can increase your chances of making a positive impression and landing the job!

  • How to Set Up Job Alerts for Data Engineering Applications Specialist ETL Positions

    Setting up job alerts for Data Engineering Applications Specialist ETL is easy with Colombia Jobs Expertini. Simply visit our job alerts page here, enter your preferred job title and location, and choose how often you want to receive notifications. You'll get the latest job openings sent directly to your email for FREE!