Data Analyst Specialist

Scotiabank; Bogotá; Presencial; COP 60.000.000 - 90.000.000; Jornada completa

Descripción de la vacante

ScotiaTech in Bogota, Colombia, is seeking a Data Analyst Specialist to help the Data Engineering team uncover, explore, and interpret data for International Banking. You will locate data, assess quality, and explain findings to engineers, SMEs, and stakeholders, supporting the move to Harbour and Azure Databricks.

Reporting to the Senior Data Engineer, you will map data across systems, contribute to medallion architecture from Bronze to Gold, and develop simple Power BI dashboards to share

Formación

• Bachelor’s degree in a relevant field; master’s is a plus.
• Cloud/data certifications are advantageous.
• Experience with SQL, BI tools, and data governance.

Responsabilidades

• Discover and explore data to understand datasets, locations, and usage.
• Explain data meaning and context to engineers and stakeholders.
• Map data across systems, documenting key connections to Databricks.
• Check data quality and help clean and prepare data for use.
• Profile raw data in Bronze, support Silver quality, ensure Gold is accurate.
• Collaborate with SMEs to write clear data requirements for engineers.
• Build simple Power BI reports and dashboards for insights.
• Track data availability by country, source, and owner.
• Document data sources and add information to the data catalog (Unity Catalog).
• Apply governance, security, and quality guidelines and seek guidance when needed.

Conocimientos

SQL

Data analysis

Stakeholder engagement

Communication skills

Agile / Scrum

Data governance

Educación

Bachelor’s degree in Computer Science / Data Engineering / IT

Master’s degree (asset)

Azure/Databricks cloud certifications (asset)

Herramientas

Power BI

Tableau

Azure Databricks

Unity Catalog

BigQuery

Descripción del empleo

Requisition ID: 271655

Employee Referral Program – Potential Reward: $200.00

We are committed to investing in our employees and helping you continue your career at ScotiaTech.

Purpose

The Data Analyst Specialist helps the Data Engineering team discover, explore, and make sense of data for International Banking. In this hands‑on role, you will find and understand the data we have, check its quality, and clearly explain what it means to engineers, business experts (SMEs), and other stakeholders. You will also help map how data connects across systems so the team can build reliable data products. Reporting to the Senior Data Engineer, you play a key role in helping the team navigate and understand our data—including as we modernize our platforms and move data into Harbour (Azure Databricks).

Accountabilities

• Discover and explore data: Find, review, and explore datasets to understand what data we have, where it lives, and how it is used, spotting useful patterns and any issues.
• Understand and explain data: Learn what the data means and clearly explain its content, structure, and business context to engineers, SMEs, and stakeholders in simple terms.
• Map data across systems: Help map how data connects from one system to another—including from legacy and GCP sources to the new Databricks platform—documenting the key details the team needs.
• Check data quality: Review data for quality issues (missing values, duplicates, errors), and help clean and prepare it so it is ready to use.
• Work within the medallion architecture: Help profile and explore raw data in the Bronze layer, support data quality and cleansing toward the Silver layer, and work with SMEs to make sure Gold (business-ready) data is accurate and clearly understood.
• Work with the experts (SMEs): Talk to business experts to understand their needs and the meaning of the data, and write down clear requirements for the engineering team.
• Build reports and dashboards: Create simple reports and dashboards (for example in Power BI) to share insights and progress with the team and stakeholders.
• Track data availability: Help keep a clear view of what data is available, pending, or missing—by country, source, and owner—so the team can act quickly.
• Document your work: Keep clear notes on data sources, meaning, and steps, and help add this information to the data catalog (Unity Catalog) so others can find and trust it.
• Follow good practices: Apply data governance, security, and quality guidelines, and ask for guidance when unsure.

Education / Experience / Other Information

Education

• Bachelor’s degree in Computer Science, Data Engineering, Information Technology, or a related field.
• A Master’s degree is considered an asset.
• Any cloud or data certification (Azure, Databricks) is a plus.

Experience

• 3 -5 years of experience in data analysis, with a focus on data discovery and stakeholder engagement.
• Experience exploring data and working with business users or SMEs to understand data needs.
• Experience with cloud-based data platforms (e.g., AWS, Azure, Google Cloud).
• Comfortable working with data in cloud platforms; experience with Azure Databricks or GCP (e.g., BigQuery) is helpful but not required.
• Some exposure to data mapping, data cleanup, or moving data between systems is a plus.
• Willingness to learn about data governance, data quality, and cataloguing tools such as Unity Catalog.
• Comfortable working in a team and in Agile / Scrum ways of working.

Technical Skills

• Proficiency in SQL for querying and manipulating large datasets.
• Some experience with Python (or a similar language) for basic data analysis is a plus.
• Familiarity with BI tools (e.g., Tableau, Power BI) for reporting and dashboard creation.
• Knowledge of data warehousing concepts and ETL processes.

Soft Skills

• Exceptional communication and interpersonal skills to engage with non‑technical SMEs.
• Strong problem‑solving skills and attention to detail.
• Ability to manage multiple priorities and deliver results in a fast‑paced environment.
• Curiosity and a willingness to ask questions and learn.

Preferred Qualifications

• Exposure to Azure Databricks, Delta Lake, or Unity Catalog.
• Experience supporting a data migration or cloud project.
• Interest in AI/BI tools (such as Databricks Genie) and how good data makes them work well.

Working Conditions

• Work in a standard office-based environment, with standard hours.

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.