Apply now »

Please be advised that our Careers site will be unavailable from November 28 at 12am ET to November 29 12am ET for scheduled system maintenance.

Title:  Data Analyst Specialist

 

 

 

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


Job Segment: Database, Data Analyst, Data Conversion, Data Warehouse, Computer Science, Technology, Data

Apply now »