Talent.com
Ness Digital Engineering
Lead Data AnalystNess Digital Engineering • Ontario, Canada, CA
No longer accepting applications
Lead Data Analyst

Lead Data Analyst

Ness Digital Engineering • Ontario, Canada, CA
7 days ago
Job type
  • Full-time
Job description

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

Create a job alert for this search

Lead Data Analyst • Ontario, Canada, CA

Similar jobs

Senior Manager, Data Engineering & Delivery (Pod Lead)

Definity Financial CorporationSouthwestern Ontario, ON, CA
Full-time

We are seeking a dynamic and experienced Senior Manager to lead our Data Engineering efforts, specifically focusing on the end-to-end delivery of critical data products within dedicated Data Pods.A... Show more

 • Promoted

Lead Data Scientist

Manulife Financial CorporationSouthwestern Ontario, ON, CA
Full-time

Our Canadian Advanced Analytics (AA) team is searching for a dedicated data scientist to work on innovative initiatives.Our team is dedicated to building solutions that increase efficiency, improve... Show more

 • Promoted

Senior Business Analyst - Process & BI Lead (6-mo)

Ontario Teachers Insurance PlanSouthwestern Ontario, ON, CA
Temporary

A leading insurance provider in Ontario seeks a Senior Business Analyst for a 6-month contract to support the development of its Dental Practice Initiative.The ideal candidate will engage with stak... Show more

 • Promoted

Business Data Analyst

RideCo On-Demand TransitSouthwestern Ontario, ON, CA
Full-time

This is an opportunity in the exciting and fast-growing transportation technology industry.Public transit is being transformed from a system of static, scheduled fixed-routes, to a dynamic on-deman... Show more

 • Promoted

Senior Architect for Data Solutions

Stantec Consulting International Ltd.Southwestern Ontario, ON, CA
Full-time

Elevate your career as a Senior Data Architect, focusing on data strategy and integration within Oracle environments.Innovate processes that enhance collaboration and data efficiency.This senior ro... Show more

 • Promoted

AI and Data - Data Architect (Snowflake)

EYSouthwestern Ontario, ON, CA
Full-time

At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you.And we’re counting on your u... Show more

 • Promoted

Lead Data Modelling Engineer

OpenTextSouthwestern Ontario, ON, CA
Full-time

Lead Data Modelling Engineer – OpenText.Join OpenText as a Lead Data Modelling Engineer, where AI powers innovation and you will lead data architecture and software development.A Development role a... Show more

 • Promoted

Lead Financial Analyst

OpenTextSouthwestern Ontario, ON, CA
Full-time

Opentext - The Information Company.OpenText is a global leader in information management, where innovation, creativity, and collaboration are the key components of our corporate culture.As a member... Show more

 • Promoted

Senior Retention Analytics Lead

McAfeeSouthwestern Ontario, ON, CA
Full-time

A leading cybersecurity firm located in Southwestern Ontario is seeking a hands-on analytics professional to lead Retention Analytics.The successful candidate will provide data-driven insights into... Show more

 • Promoted

Top Customer Solutions Developer, Data Analytics, Google Cloud

GoogleSouthwestern Ontario, ON, CA
Full-time

The Google Cloud Platform team helps customers transform and build what's next for their business — all with technology built in the cloud.Our High Touch Support Solutions Developers own our large ... Show more

 • Promoted

Lead Pricing Analyst

OpenTextSouthwestern Ontario, ON, CA
Full-time

The Lead Pricing Analyst is responsible for the evaluation, development and implementation of pricing & packaging strategies based on the current business and competitive environment.In this role y... Show more

 • Promoted

Subscriber Retention Data Analyst Role

McAfeeSouthwestern Ontario, ON, CA
Full-time

Join McAfee as a Data Retention Analyst and play a crucial role in optimizing subscriber engagement.This hybrid position focuses on delivering retention analytics and insights across the full subsc... Show more

 • Promoted

Senior Data Architect: Oracle EBS & Cloud Integrations

Stantec Consulting International Ltd.Southwestern Ontario, ON, CA
Full-time

A global consulting firm is seeking a Senior Data Architect to oversee the design and implementation of a comprehensive data architecture strategy.This role involves enhancing integration with Orac... Show more

 • Promoted

Lead Data Modeling Engineer — AI & SaaS

OpenTextSouthwestern Ontario, ON, CA
Full-time

A leading technology company in Canada seeks a Lead Data Modelling Engineer to lead the design of SaaS products and implement scalable data systems.The role requires 8+ years of software developmen... Show more

 • Promoted

Senior Snowflake Data Architect for AI & Analytics

EYSouthwestern Ontario, ON, CA
Full-time

A global consulting firm is seeking experienced Snowflake Data Architects to join their AI & Data practice team.The successful candidate will lead solution architecture, design secure and scalable ... Show more

 • Promoted

Analyst, Retention Analytics

McAfeeSouthwestern Ontario, ON, CA
Full-time

We are hiring an Analyst, Retention Analytics to support the Engagement & Retention team by delivering end‑to‑end retention analytics across the subscriber lifecycle.The analyst will analyze churn ... Show more

 • Promoted

OpenText Lead Pricing Analyst Position

OpenTextSouthwestern Ontario, ON, CA
Full-time

Shape pricing strategies as a Lead Pricing Analyst at OpenText, where your analysis and insights drive decision-making.This position requires collaboration with multiple teams to optimize pricing.A... Show more

 • Promoted

Senior Business Analyst: Process Improvement & BI Leader

Ontario Teachers Insurance PlanSouthwestern Ontario, ON, CA
Full-time

A financial services organization in Ontario seeks a seasoned Business Analyst to lead business process improvements and enhance stakeholder collaboration.The ideal candidate should have strong pro... Show more

 • Promoted

Cloud Data Analytics Solutions Engineer

GoogleSouthwestern Ontario, ON, CA
Full-time

A leading technology company is seeking a Top Customer Solutions Developer in Southwestern Ontario to provide high-touch support to critical customers migrating to Google Cloud.You will troubleshoo... Show more

 • Promoted

Insurance BI Analyst — DW/BI & Data Quality

Avance Consulting ServicesSouthwestern Ontario, ON, CA
Full-time

A global IT consulting firm is seeking a Business Analyst with an insurance background to engage with users, document information needs, and support BI projects.The ideal candidate should be degree... Show more