About the role
Data Analyst Location: Toronto (Hybrid)
Data Discovery & Analy sisAnalyze all Netezza database tables to identi fy:Business-critical and frequently used tab lesRedundant and unused data ass etsPerform data profiling and quality analysis to understand structure, patterns, and anomal iesAssess data dependencies and relationships across syst emsMigration Assessment (Netezza → Azu re)Evaluate and repo rt:Number of tables already migrated to Az ureTables pending migrat ionValidate data consistency between Netezza and Azure environme ntsSupport migration planning through impact analy sisData Mapping & Line ageCreate source-to-target data mapping docume ntsEstablish end-to-end data lineage across syst emsDocument transformations and business rules applied during migrat ionMetadata & Documentat ionDevelop and mainta in:Metadata repository / definition docume ntsData dictionary / taxonomy (asset libra ry)Table-level and column-level documentat ionEnsure alignment with enterprise data governance standa rdsData Model ingPerform data modeling and mapping activit iesCrea te:Conceptual, logical, and physical data mod elsDomain-based models for retail or business-specific datas etsDesign models optimized f or:Analytical worklo adsEnterprise BI and report ingDevelopment & Implementat ionWrite and optimize SQL queries for data analysis and validat ionDevelop DDL scripts and assist in deploying data models across environme ntsPerform data wrangling and transformation using Python or similar to olsWork with data lakes and structured/unstructured data sour cesExperie nce4+ years of experience in data analysis, data modeling, or data engineering ro lesTechnical Ski llsStrong expertise in:SQL (mandato ry)Python (or other scripting languag es)Experience wi th:Netezza and cloud platforms (preferably Azu re)Data modeling tools (e.g., ERwin, ER/Studio, Azure too ls)Data warehousing and analytical worklo adsSolid understanding of:Data lineage and metadata managem entETL/ELT proces sesData migration strateg iesData Management Ski llsData profiling and analysis techniq uesData mapping and transformation documentat ionMetadata, taxonomy, and data dictionary creat ionCollaboration & Stakeholder Managem entWork closely wi th:Data engine ersBI/reporting te amsData science te amsBusiness stakehold ersGather and translate business requirements into technical data soluti onsSupport downstream data marts, semantic layers, and analytics use ca
ses
Not the right fit? Search for Data Analyst jobs in Toronto, Ontario, Canada
About Gala Solutions
We are happy to talk in detail about our services and how we can assist your business. We specialize in end-to-end solutions for your entire web-related needs. Self-optimizing systems and the need for new ideas powered by intelligent technologies have been a keen interest in meeting the needs of growing customer expectations. We contribute to our client's aspirations by driving real innovation and ideas that transform and grow their organizations.
We offer a wide range of services which include Application Services, Business Consulting, Infrastructure Services, IT Outsourcing Services and System Integration Services, ASIC design services, etc.
We strive to serve our clients by establishing their brand name and developing their portfolio in the market. Continuous profitable growth is a testimony to the confidence of our clients in us. The commitment of our members is to provide exponential growth to shareholders and the best return on their investment.
We systematically rethink how our clients can create an impact on their organizations by analyzing the exceptions of the end customers.
Similar Jobs
About the role
Data Analyst Location: Toronto (Hybrid)
Data Discovery & Analy sisAnalyze all Netezza database tables to identi fy:Business-critical and frequently used tab lesRedundant and unused data ass etsPerform data profiling and quality analysis to understand structure, patterns, and anomal iesAssess data dependencies and relationships across syst emsMigration Assessment (Netezza → Azu re)Evaluate and repo rt:Number of tables already migrated to Az ureTables pending migrat ionValidate data consistency between Netezza and Azure environme ntsSupport migration planning through impact analy sisData Mapping & Line ageCreate source-to-target data mapping docume ntsEstablish end-to-end data lineage across syst emsDocument transformations and business rules applied during migrat ionMetadata & Documentat ionDevelop and mainta in:Metadata repository / definition docume ntsData dictionary / taxonomy (asset libra ry)Table-level and column-level documentat ionEnsure alignment with enterprise data governance standa rdsData Model ingPerform data modeling and mapping activit iesCrea te:Conceptual, logical, and physical data mod elsDomain-based models for retail or business-specific datas etsDesign models optimized f or:Analytical worklo adsEnterprise BI and report ingDevelopment & Implementat ionWrite and optimize SQL queries for data analysis and validat ionDevelop DDL scripts and assist in deploying data models across environme ntsPerform data wrangling and transformation using Python or similar to olsWork with data lakes and structured/unstructured data sour cesExperie nce4+ years of experience in data analysis, data modeling, or data engineering ro lesTechnical Ski llsStrong expertise in:SQL (mandato ry)Python (or other scripting languag es)Experience wi th:Netezza and cloud platforms (preferably Azu re)Data modeling tools (e.g., ERwin, ER/Studio, Azure too ls)Data warehousing and analytical worklo adsSolid understanding of:Data lineage and metadata managem entETL/ELT proces sesData migration strateg iesData Management Ski llsData profiling and analysis techniq uesData mapping and transformation documentat ionMetadata, taxonomy, and data dictionary creat ionCollaboration & Stakeholder Managem entWork closely wi th:Data engine ersBI/reporting te amsData science te amsBusiness stakehold ersGather and translate business requirements into technical data soluti onsSupport downstream data marts, semantic layers, and analytics use ca
ses
Not the right fit? Search for Data Analyst jobs in Toronto, Ontario, Canada
About Gala Solutions
We are happy to talk in detail about our services and how we can assist your business. We specialize in end-to-end solutions for your entire web-related needs. Self-optimizing systems and the need for new ideas powered by intelligent technologies have been a keen interest in meeting the needs of growing customer expectations. We contribute to our client's aspirations by driving real innovation and ideas that transform and grow their organizations.
We offer a wide range of services which include Application Services, Business Consulting, Infrastructure Services, IT Outsourcing Services and System Integration Services, ASIC design services, etc.
We strive to serve our clients by establishing their brand name and developing their portfolio in the market. Continuous profitable growth is a testimony to the confidence of our clients in us. The commitment of our members is to provide exponential growth to shareholders and the best return on their investment.
We systematically rethink how our clients can create an impact on their organizations by analyzing the exceptions of the end customers.