Data Analyst

emergiTEL Inc.; Toronto; On-site; CAD 70,000 - 85,000; Full time

Job summary

A dynamic data engineering company in Toronto seeks a detail-oriented Data Analyst with 3–4 years of experience. This role involves analyzing data flows, developing documentation, conducting data quality checks, and generating insightful reports using tools like Power BI and Tableau. The ideal candidate holds a Bachelor's degree in a relevant field and possesses strong SQL and analytical skills. The position offers valuable collaboration opportunities across technical and business teams, contributing to the growth of high-quality data pipelines.

Qualifications

• 3–4 years of experience in a data analyst or similar role.
• Experience with data mapping, documentation, and reporting.
• Familiar with data modeling concepts and documentation standards.

Responsibilities

• Analyze and document data flows from various source systems.
• Develop, update, and maintain data dictionaries.
• Prepare and maintain detailed documentation of data models.
• Perform data quality analysis and report findings.
• Gather business requirements and translate into technical specifications.
• Develop and deliver reports and dashboards.
• Assist in the implementation of data governance policies.

Skills

SQL proficiency

Data visualization tools (Power BI, Tableau, Databricks)

Excel skills

Analytical and problem-solving skills

Communication abilities

Education

Bachelor’s degree in Data Science, Information Systems, Business Analytics, Computer Science, or related field

Tools

Power BI

Tableau

Databricks

Oracle

SQL MI

MongoDB

Job description

Position Overview

We are seeking a detail-oriented Data Analyst with 3–4 years of experience to join our dynamic Data Engineering team. The successful candidate will play a key role in the documentation, mapping, and analysis of data assets, supporting the development and maintenance of high-quality data pipelines and reporting solutions. This role is essential for ensuring data accuracy, usability, and compliance across the organization.

Key Responsibilities

• Data Mapping: Analyze and document data flows from source systems (Oracle, SQL MI, MongoDB, file feeds) to reporting environments. Create and maintain comprehensive data mapping documents to support pipeline development and data integration.
• Data Dictionary Development: Develop, update, and maintain data dictionaries for all critical datasets, ensuring clear definitions, descriptions, and business context for data elements.
• Documentation: Prepare and maintain detailed documentation of data models, business rules, transformation logic, and reporting structures. Ensure documentation is up-to-date and accessible to technical and business stakeholders.
• Data Quality Analysis: Perform data profiling, validation, and quality checks to identify anomalies and inconsistencies. Collaborate with engineers to resolve data issues and improve data reliability.
• Business Requirements Gathering: Work closely with business users and data engineers to understand reporting and analytics requirements. Translate business needs into technical specifications and data requirements.
• Reporting & Insights: Develop and deliver reports, dashboards, and ad hoc analyses using tools such as Power BI, Tableau, or Databricks. Provide actionable insights to support business decision-making.
• Collaboration: Act as a bridge between data engineering and business teams, ensuring alignment on data definitions, usage, and reporting standards.
• Data Governance Support: Assist in the implementation of data governance policies and procedures, including metadata management and data lineage documentation.

Education

Bachelor’s degree in Data Science, Information Systems, Business Analytics, Computer Science, or related field.

Experience

3–4 years in a data analyst or similar role, with hands-on experience in data mapping, documentation, and reporting.

Technical Skills

• Proficiency in SQL for data analysis and querying
• Experience with data visualization/reporting tools (Power BI, Tableau, Databricks)
• Familiarity with data modeling concepts and documentation standards
• Knowledge of relational and non-relational databases (Oracle, SQL MI, MongoDB)
• Strong Excel skills; familiarity with Python or R is a plus

Preferred

• Exposure to cloud platforms (Azure preferred)
• Experience with data governance and metadata management tools
• Understanding of Medallion architecture and data pipeline concepts

Core Competencies

• Strong analytical and problem-solving skills
• Excellent attention to detail and accuracy
• Effective communication and documentation abilities
• Ability to collaborate across technical and business teams
• Adaptability and eagerness to learn new tools and methodologies