Technical Analyst

ScotiaTech; Bogotá; Presencial; COP 115.017.444 - 172.526.166; Jornada completa

Descripción de la vacante

A technology and banking company in Bogotá is seeking a Technical Analyst to contribute to the Global Technology & Engineering Platform Services. The role involves analyzing vulnerability data, managing SQL Server Reporting databases, and developing ETL processes using MS SQL and SSIS. Candidates should have a Bachelor's Degree in Computer Science or a related field and 1-3 years of experience in database administration. This is a full-time position with a focus on Information Technology.

Formación

• Superior English written and verbal communication skills.
• 1-3 years of experience in database administration or similar roles.
• Experience with performance optimization and data security.

Responsabilidades

• Analyze and create vulnerability reporting dashboards.
• Monitor SQL Server Database health and performance.
• Develop ETL processes using MS SQL and SSIS.

Conocimientos

Database administration

Scripting language (e.g., Python)

Vulnerability Management

SQL

Advanced Excel Skills

Power BI

Educación

Bachelor’s Degree in Computer Science or related field

Herramientas

SQL Server

ServiceNow

Tenable

Descripción del empleo

ScotiaTech Bogota, D.C., Capital District, Colombia

Technical Analyst

Contributes to the overall success of the Global Technology & Engineering Platform Services in Canada and globally ensuring specific individual goals, plans, initiatives are executed / delivered in support of the team’s business strategies and objectives. Ensures that all activities conducted are in compliance with governing regulations, internal policies and procedures.

Accountabilities

• Champions a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge.
• Oversight of Vulnerabilities and Patching cadences for Infrastructure and Application servers.
• Collection and Analysis of Critical Application Assets remediation efforts.
• Analyzing Vulnerability and remediation data and creates reporting dashboards.
• Manage Vulnerability SQL Server Reporting databases.
• Configure and maintain Vulnerability Reporting database servers and processes.
• Monitor SQL Server Reporting database health and performance, ensuring high levels of performance, availability, sustainability and security.
• Analyzing, solving and correcting SQL Server Reporting databases issues. Providing suggestions for solutions.
• Develop ETL process using MS SQL and SSIS, refining and automating regular processes, tracking issues, and documenting changes.
• Contribute to and be a part of a collaborative team environment.
• Review performance reports, assist with the weekly, monthly reporting and ensure timely resolution of issues.

Education / Experience

• Superior English written and verbal communications with good presentation skills and collaborative orientation skillset B2.
• Bachelor’s Degree in Computer Science, Information Technology or a related field.
• 1-3 years of experience in database administration or in a similar role.
• Experience in database backup, disaster recovery planning, performance optimization and data security.
• Ability to use a scripting language (like Python or Peri) to automate database administration tasks.
• Advanced Excel Skills, PowerPoint and Power BI.
• Advanced ability to analyze data and assess vulnerabilities in infrastructure (software, hardware, networks).
• Highly familiar with Network and Operational System version and protocols (all O/S) Technical Background.
• Highly familiar with or experienced in Vulnerability Management/Cybersecurity & Server compliance.
• Experience in Vulnerability Management Tool sets (Tenable) equating to a strong working knowledge of information security principles and security operations.
• Strong ServiceNow knowledge [ticketing tools].
• Exacting in following procedural documents.
• Experience with SQL.

Working Conditions

• Work in a standard office-based environment; non-standard hours are a common occurrence.
• You would be a part of a vibrant, dynamic, decisive, top performing cohesive and respected team. Learning and using skills that will take you anywhere with confidence. Your efforts would be realized by top levels at BNS as part of the contribution arm to upstream reporting mechanisms. You will not be left in a box. You’d be part of a team that drives and motivates each other to exceed expectations. A rewarding and self-satisfying role. You'll be proud to work with us.

Seniority level

Not Applicable

Employment type

Full-time

Job function

Information Technology

Industries

Banking

Referrals increase your chances of interviewing at ScotiaTech by 2x