Ness Digital Engineering - 5 emplois
Ontario, ON
Posté hier
Détails de l'emploi :
Temps plein
Niveau d`entrée
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
- 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
- Create source-to-target data mapping documents
- Establish end-to-end data lineage across systems
- Document transformations and business rules applied during migration
- 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
- 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
- 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
- 4+ years of experience in data analysis, data modeling, or data engineering roles
- 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 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
- Work closely with:
Partager un emploi :
Foire aux questions
The role centers on data discovery and analysis, migration assessment from Netezza to Azure, data mapping and lineage, metadata and documentation, data modeling, and development and implementation of SQL, Python, and data transformations.
Strong expertise in SQL and Python is required, with experience in Netezza and cloud platforms (preferably Azure), and familiarity with data modeling tools and data warehousing for analytical workloads.
Evaluate migration progress from Netezza to Azure, report migrated and pending tables, validate data consistency between environments, and support migration planning through impact analysis.
Develop and maintain a metadata repository and data dictionary, document table- and column-level definitions, establish end-to-end data lineage, and ensure alignment with data governance standards.
Candidates should have 4+ years of experience in data analysis, data modeling, or data engineering roles.
Create conceptual, logical, and physical data models, including domain-based models for retail or business-specific datasets, optimized for analytical workloads and enterprise BI.
This is a full-time position located in Ontario, ON, Canada.
