Talent.com
Tek Ninjas
Data AnalystTek Ninjas • Toronto, ON, Canada
Data Analyst

Data Analyst

Tek Ninjas • Toronto, ON, Canada
1 day ago
Job type
  • Full-time
  • Quick Apply
Job description

Role: Data Analyst
Location: Toronto (Hybrid)
Duration: 6-12 Months

Job Description:
Data Discovery & Analysis

  • Analyze all Netezza database tables to identify:
  • Business-critical and frequently used tables
  • Redundant and unused data assets
  • Perform data profiling and quality analysis to understand structure, patterns, and anomalies
  • Assess data dependencies and relationships across systems
  • Migration Assessment (Netezza Azure)

Evaluate and report:

  • Number of tables already migrated to Azure
  • Tables pending migration
  • Validate data consistency between Netezza and Azure environments
  • Support migration planning through impact analysis
  • Data Mapping & Lineage
  • Create source-to-target data mapping documents
  • Establish end-to-end data lineage across systems
  • Document transformations and business rules applied during migration
  • Metadata & Documentation

Develop and maintain:

  • Metadata repository / definition documents
  • Data dictionary / taxonomy (asset library)
  • Table-level and column-level documentation
  • Ensure alignment with enterprise data governance standards
  • Data Modeling
  • Perform data modeling and mapping activities

Create:

  • Conceptual, logical, and physical data models
  • Domain-based models for retail or business-specific datasets

Design models optimized for:

  • Analytical workloads
  • Enterprise BI and reporting
  • Development & Implementation
  • Write and optimize SQL queries for data analysis and validation
  • Develop DDL scripts and assist in deploying data models across environments
  • Perform data wrangling and transformation using Python or similar tools
  • Work with data lakes and structured/unstructured data sources

Experience

  • 4+ years of experience in data analysis, data modeling, or data engineering roles
  • Technical Skills
  • Strong expertise in:
  • SQL (mandatory)
  • Python (or other scripting languages)

Experience with:

  • Netezza and cloud platforms (preferably Azure)
  • Data modeling tools (e.g., ERwin, ER/Studio, Azure tools)
  • Data warehousing and analytical workloads

Solid understanding of:

  • Data lineage and metadata management
  • ETL/ELT processes
  • Data migration strategies
  • Data Management Skills
  • Data profiling and analysis techniques
  • Data mapping and transformation documentation
  • Metadata, taxonomy, and data dictionary creation
  • Collaboration & Stakeholder Management

Work closely with:

  • Data engineers
  • BI/reporting teams
  • Data science teams
  • Business stakeholders
  • Gather and translate business requirements into technical data solutions
  • Support downstream data marts, semantic layers, and analytics use cases

About TekNinjas

TekNinjas is a global IT staffing partner placing skilled professionals with leading enterprises and system integrators across the US, Canada, UK, India, and the EU. We focus on the right fit - not just the fast fill - and stay engaged with our consultants well beyond the start date.

We're the right partners in your success.

TekNinjas is an Equal Opportunity Employer.

Create a job alert for this search

Data Analyst • Toronto, ON, Canada

Similar jobs

Data Analyst

TD BankToronto, ON, CA
Full-time

Nous et certains tiers sélectionnés utilisons des technologies et des outils de suivi (témoins) pour recueillir des renseignements sur votre utilisation de ce site Web.Les témoins essentiels soutie... Show more

 • Promoted

Data Analyst

University Health NetworkToronto, ON, CA
Full-time +1

UHN is Canada’s #1 hospital and the world’s #1 publicly funded hospital.With 10 sites and more than 44,000 TeamUHN members, UHN consists of Toronto General Hospital, Toronto Western Hospital, Princ... Show more

 • Promoted

Lead Data Analyst

Bally's InteractiveToronto, ON, CA
Full-time

Ignite Your Career Where Innovation Leads the Way! Bally’s Interactive is redefining the future of entertainment by powering one of the world’s most dynamic entertainment ecosystems.We believe the ... Show more

 • Promoted

Lead Data Analyst

Compunnel, Inc.Toronto, ON, CA
Full-time

Senior Business Data Analyst Capital Markets Data Architecture.The Lead Data Analyst will play a critical role in bridging business and data teams by gathering and translating business requirements... Show more

 • Promoted

Data Analyst

JAE Consulting Inc.Toronto, ON, CA
Full-time

Our client is a well-established, privately held Canadian organization operating across multiple business entities in industrial, manufacturing, and diversified services sectors.The company is inve... Show more

 • Promoted

Data Analyst

Rakuten Kobo Inc.Toronto
Full-time

Our employees rank us highly in terms of commitment to work/life balance.We realize that for our people to be innovative, creative and passionate they need to feel valued and supported.We believe i... Show more

 • Promoted

Capital Markets Data Analyst - 6mo Contract, SQL/Azure

Recruit Action inc.Toronto, ON, CA
Permanent

A recruitment agency is seeking a Business Data Analyst for a hybrid role in Toronto.This position involves leading data-driven initiatives within the insurance and wealth management sector.Candida... Show more

 • Promoted

Senior Data Analyst

Super.comToronto, ON, CA
Full-time

For our employees, our promise is that Super.We are more than a fast‑paced, high‑growth tech company; we care about our people and take career progression seriously.This is your career and our aim ... Show more

 • Promoted

Data Analyst

StripeToronto, ON, CA
Full-time

Stripe is a financial infrastructure platform for businesses.Millions of companies—from the world’s largest enterprises to the most ambitious startups—use Stripe to accept payments, grow their reve... Show more

 • Promoted

Lead Data Analyst

Tripledot StudiosToronto, ON, CA
Full-time

We are a multi-award-winning organisation, with a global 2,500+ strong team across 12 studios.Our expanded portfolio includes some of the biggest titles in mobile gaming, collectively reaching top ... Show more

 • Promoted

BI Developer / Data Analyst

Kensington ToursToronto, ON, CA
Full-time

Kensington delivers the world’s most personal travel experiences.We bring to life each client’s desire to travel in a way that’s tailored specifically for them, in the company of local private guid... Show more

 • Promoted

Data Analyst

University of TorontoToronto, ON, CA
Full-time

Working under the general direction of the Director, Academic Programs, Planning and Quality Assurance, the Coordinator, Academic Programs and Data Analyst is responsible for supporting a wide-rang... Show more

 • Promoted

Compliance Data and Business Intelligence Analyst

Resource Productivity and Recovery AuthorityToronto, ON, Canada
Full-time +1

Are you passionate about protecting the environment? Do you go out of your way to reduce, reuse, and recycle? Do you envision a waste-free future?.If you answered yes to those questions, then we’d ... Show more

 • Promoted

Data Analyst

ZyngaToronto, ON, CA
Full-time

Level Up Your Career with Zynga! At Zynga, we bring people together through the power of play.As a global leader in interactive entertainment and a proud label of Take-Two Interactive, our games ha... Show more

 • Promoted

Community Data Analyst

Standing on GiantsToronto, ON, CA
Full-time

Standing on Giants is the world’s first agency for businesses that want to build a brand‑owned, online community.We empower businesses to build thriving online communities that put their customers ... Show more

 • Promoted

Data Analyst

TechMatrix IncToronto, ON, CA
Full-time

I specialize in turning data into actionable insights with a strong foundation in data analysis, visualization, and domain knowledge.Proficient in Tableau and Excel for building interactive dashboa... Show more

 • Promoted

Online Data Analyst - French (CA) - TELUS Digital AI Data Solutions

TELUS Digital AI Data Solutionsnewmarket, on, ca
Part-time

Are you a detail-oriented individual with a passion for research and a good understanding of national and local geography? This freelance opportunity allows you to work at your own pace and from th... Show more

 • Promoted

Data Analyst

DelpathToronto, ON, CA
Full-time

Contract Duration: 1 year with extension.Global Banking and Markets (GBM).To support Client Insight & Analytics' day-to-day activities, to support Capital Analytics project.Assist in the processing... Show more

 • Promoted

Data Analyst 2.0 (Operations & Performance)

TEKsystemsToronto, ON, CA
Permanent

Our client is looking for a skilled and driven Operations Analyst to support data-driven decision-making and operational performance across a complex, high-volume environment.This position is ideal... Show more

 • Promoted

Data Analyst

Acquird.ioToronto, ON, CA
Full-time

A profitable, family-run, growing group of companies in the Industrial Packaging and Distribution space.Proudly Canadian and entrepreneurial, with multiple divisions.We serve customers across North... Show more