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

Data Analyst

Tek Ninjas • Toronto, Ontario, Canada
30+ days ago
Job type
  • Full-time
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. Were the right partners in your success. TekNinjas is an Equal Opportunity Employer.


Employment Type : Full Time
Experience: years
Vacancy: 1
Create a job alert for this search

Data Analyst • Toronto, Ontario, Canada

Similar jobs

Remote Data Analyst for Digital Maps (Freelance)

TELUS Digital AI Data SolutionsToronto, ON, CA
Remote
Full-time

A leading technology solutions provider in Canada is seeking a detail-oriented Online Data Analyst for a freelance opportunity.This role allows you to work from home at your own pace while contribu... Show more

 • Promoted

Data Analyst

MonographToronto, ON, CA
Full-time

Data Science at Stripe is a vibrant community where data analysts, data scientists and engineers learn and grow together.You will work with some of Stripe’s most fundamental and exciting data, and ... Show more

 • Promoted

Data Analyst - Business Intelligence

RewardOpsToronto, ON, CA
Full-time

CAD, depending on experience and qualifications.We are seeking a Lead/Senior Data Scientist to design and deliver advanced analytical solutions that power our global loyalty SaaS platform.This role... Show more

 • Promoted

Data Analyst (Remote)

Chord StrategyToronto, ON, CA
Remote
Full-time

The Battle of Giants exists to answer a simple but important question:.Will a company’s strategy lead to growth?.We do this to help investors and corporate execs assess a company’s growth potential... Show more

 • Promoted

Compensation Data Analyst

Hire Level ConsultingToronto, ON, CA
Full-time

Headquartered in Toronto, Canada, this dynamic organization, operates five manufacturing facilities in Canada, the United Kingdom, and The Netherlands and multiple dedicated R&D centers around the ... 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, Business Intelligence

FloatToronto, ON, CA
Full-time

Float is on a mission to simplify finance for Canadian businesses, empowering them to eliminate complexity and unlock new opportunities.Through our innovative platform, Float enables businesses to ... Show more

 • Promoted

Bilingual Data Analyst Needed with SQL and Python Expertise

FP Inc.Toronto, ON, CA
Full-time

Step into the role of Bilingual Data Analyst utilizing SQL and Python/R skills.Engage with various departments on a contract basis to provide clear, data-driven insights.This position seeks individ... 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

Senior Market Data Analyst - Fidelity Canada

Fidelity CanadaToronto, ON, CA
Full-time

Take on a key role as a Senior Market Data Vendor Analyst at Fidelity Canada.Operate in a dynamic hybrid work environment while managing vendor relationships and ensuring data governance.As part of... Show more

 • Promoted

Senior Data Analyst

Electronic Arts Inc.Toronto, ON, CA
Full-time

Covet Fashion is seeking an inquisitive and experienced Data Analyst to join our Product Management team.Reporting to the Director of Product, you will work with partners to understand player engag... Show more

 • Promoted

Data Analyst, Principal

Dayforce US, Inc.Toronto, ON, CA
Full-time

As a Principal Data Analyst, you are a highly analytical, forward-thinking, and proactive problem solver who thrives on turning data into strategic insight.You will play a pivotal role within the D... Show more

 • Promoted

Data Platform Analyst (Azure)

Amphenol Corporationmarkham, on, Canada
Full-time

Amphenol Communications Solutions (ACS), a division of Amphenol Corporation, is a world leader in interconnect solutions for Communications, Mobile, RF, Optics, and Commercial electronics markets.A... Show more

 • Promoted

Senior Data Analyst

Turotoronto, on, Canada
Full-time

Turo is seeking a Senior Data Analyst to join our growing Toronto team and turbo‑charge Turo’s growth in Canada.The Senior Data Analyst will work across multiple business verticals, collaborating c... 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

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

Online Data Analyst Urdu (CA)

TELUS DigitalToronto, ON, CA
Part-time

Sourcing Analyst @ TELUS Digital AI Data Solutions | Strategic Sourcing, CRM.Are you a detail-oriented individual with a passion for research and a good understanding of national and local geograph... Show more

 • Promoted

IT Business & Data Analyst – Funding and Liquidity Technology

ODAIAToronto, ON, CA
Full-time

FUNDING AND LIQUIDITY DATA ANALYST.The Funding and Liquidity Data Analyst ensures the bank's funding, liquidity, and treasury teams have accurate, reliable data for decision-making.You will manage ... Show more

 • Promoted

Data Analyst

CI FinancialToronto, ON, CA
Full-time

At CI, we see a great place to work as one that is a safe place for everyone to have a voice, where people are empowered to take ownership over meaningful work, where there is an opportunity to gro... Show more

 • Promoted

Data Analyst, Business Intelligence

FloatfinancialToronto, ON, CA
Full-time

We’re redefining the future of business spend and looking for talent with a bias for action and real impact.A diverse group of ambitious, collaborative and mission-driven people.We’re building an A... Show more