Lead Data Analyst
Ontario, Canada, Canada
CAD 120K-161K (estimate) Senior-level Full Time
Tasks
- Analyze Netezza database tables
- Assess data dependencies and relationships
- Create conceptual, logical, and physical data models
- Create data dictionary and taxonomy
- Create source to target data mapping documents
- Deploy data models across environments
- Develop DDL scripts for data models
- Develop metadata repository and definition documents
- Document transformations and business rules
- Establish end to end data lineage
- Evaluate Netezza to Azure migration impact
- Maintain table level and column level documentation
- Optimize models for analytical workloads
- Perform data modeling and mapping
- Perform data profiling and quality analysis
- Perform data wrangling and transformations with Python
- Support migration planning through impact analysis
- Validate data consistency between environments
- Work with data lakes and structured unstructured sources
- Write and optimize SQL queries
Perks/Benefits
- N/A
Skills/Tech-stack
Azure | Data Dictionary | Data Lineage | Data Mapping | Data Migration | Data Modeling | Data Quality | Data Warehousing | Data profiling | ELT | ETL | Metadata Management | Netezza | Python | SQL
Education
N/A
Roles
Analyst | Data Analyst | Lead | Lead Data | Lead Data Analyst
Related jobs
-
Senior Analyst, Strategic Analytics USD 129K-185KApache Airflow | COGS Analysis | Contribution Margin | Cost modeling | DBT401k contribution | Fully remote | Health insurance | Paid time offSenior-level Full TimeCanada - Remote; United States - … R19h ago
-
DAX | DAX Studio | Data Modeling | Data Quality | Power BIEmployee assistance program | Flexible schedule | Hybrid work mode | Paid time off | Retirement savings planMid-level Full TimeLaval, Quebec, Canada20h ago
-
AI Savvy Data Analyst (English version) CAD 110K-140KAnomaly Detection | BigQuery | Cloud APIs | Colab | Data GovernanceAdditional day off | Birthday day off | Flex days paid | Flexible work hours | Montreal transit pass discountMid-level Full TimeMontréal, QC, Canada R21h ago
-
APIs | DAX | Data Modeling | Data Warehouse | ETLMid-level Full TimeMarkham, Ontario, Canada22h ago
-
Senior Data Analytics Consultant CAD 90K-105KCapital modeling | Catastrophe modeling | Data Architecture | Data Governance | Data QualitySenior-level Full TimeCA- CN62 -Toronto-66 Wellingto, Canada1d ago
-
Data Analyst CAD 80K-128KAWS | Business Intelligence | CRM | Data Modeling | Data QueryingFlexible benefits | Global learning access | Hybrid work | Paid time off | Pension planSenior-level Full TimeSun Life Toronto One York, Canada1d ago
-
Data Analyst CAD 80K-128KAWS | Data Governance | Data Modeling | Data Quality | Data WarehousingFlexible benefits | Hybrid work environment | Pension plan | Professional development | Savings programsSenior-level Full TimeSun Life Toronto One York, Canada1d ago
-
Consultant, Data and AI Analytics CAD 75K-95KAzure Databricks | C Sharp | Copilot Studio | Data analytics | GenAICareer development opportunities | Employee share purchase plan | Hybrid work arrangement | Paid growth day | Paid time offMid-level Full TimeToronto-81 Bay, 15th Floor, Canada1d ago
-
Senior Data Analyst, Financial & Workforce Planning CAD 113K-163KAzure Databricks | Budget analysis | Business Intelligence | Capacity Planning | Data AnalysisFlexible work environment | Paid time off | Well-being and inclusionSenior-level Full TimeCAN, Ontario, Toronto, 200 Bloor Street …1d ago
-
Senior-level Full TimeOntario, Canada2d ago
-
Dashboard Development | Data Pulls | Data Quality | Data Quality Management | Data VisualizationDeloitte Days closure | Flexible spending account | Flexible work arrangements | Learning and development days | Mental health support benefitsMid-level Full TimeToronto, ON, CA, M5H 0A93d ago
-
Senior Analyst, Advanced Analytics CAD 98K-120KA/B | A/B Testing | B testing | Data Analysis | Data ModelingContinuous learning culture | Mentorship opportunities | Remote work flexibilitySenior-level Full TimeToronto, Halifax, Calgary, Vancouver, Ottawa, Kitchener, … R3d ago
-
Senior Operations Data Analyst (Hybrid) CAD 90K-125KDashboarding | Data Architecture | Data Governance | Data Quality | Dynamics 365Family building support | Fertility drug coverage | Hybrid work arrangement | Learning Support | Medical, dental coverageSenior-level Full TimeBurnaby, BC, V5J 0B6, CAN R3d ago
-
Data and Analytics Lead CAD 87K-135KData Architecture | Data Flow | Data Flow Mapping | Data Governance | Data ManagementEmployee assistance program | Family assistance program | Flexible health benefits | Growth opportunities | Gym membershipsSenior-level Full TimeDieppe, NB, Canada3d ago
-
Quantitative Analytics Lead CAD 145K-205KCloud Computing | Credit Risk | Credit Risk Management | Data Science | Fraud DetectionESPP | Flexible spending wallets | Remote work | Time offSenior-level Full TimeRemote Canada R3d ago
-
AI Observability | AWS | Azure | CI/CD | Cost ControlCareer advancement | Fully remote work | Professional development opportunities | Work-life balanceSenior-level Full TimeCanada R4d ago
-
Business Intelligence | Dashboard Development | Data Analysis | Data Governance | Data StorytellingAccident insurance | Dental insurance | Flexible work arrangements | Health insurance | Learning and developmentSenior-level Full TimeCanada4d ago
-
Jr. CDE and Analytics Coordinator CAD 65K-75KACC | API Integration | Autodesk Forma | Common Data Environment | Data QualityEmployee resource groups | Paid training programs | Tuition reimbursementEntry-level Full TimeHamilton, ON, CA4d ago
-
Mars Canada Business Analytics Analyst Co-op CAD 74K-106KApache Spark | Azure | DAX | Data Modeling | ELTAccess to in house training program | Learning and development supportMid-level Full TimeBOL-Mars Canada Inc.4d ago
-
Data Analyst, Circular Material Innovations CAD 53K-88KAzure | Business Intelligence | Data Automation | Data Modeling | Data QualityFlex benefits program | Mental health benefits | Profit sharing | Retirement savings | Store discountsMid-level Full Time20 Eglinton West, Canada4d ago
-
Senior Data Governance Analyst CAD 113K-163KAccess Controls | Access Management | Azure | Cause analysis | Cloud Data Governance and CatalogDental insurance | Disability insurance | Health insurance | Hybrid work | Life insuranceSenior-level Full TimeCAN, Ontario, Waterloo, 500 King Street …4d ago
-
Data Governance | Data Mining | Data Modeling | Data Visualization | ETLSenior-level Contract Full TimeVancouver, British Columbia, Canada; Remote, British … R4d ago
-
Data Analyst CAD 75K-90KDAX | Data Modeling | Excel | Power BI | Power QueryBus pass reimbursement | Employee discount | Free onsite parking | Health insurance | RRSPMid-level Full TimeCoquitlam, BC, V3K 7B5, CA4d ago
-
Agent-based | Agent-based systems | Amazon SageMaker | Azure ML | Cloud Machine LearningDental insurance | Flexible sick leave | Flexible vacation | Health insurance | Home-office equipmentSenior-level Full TimeCanada5d ago
-
Data Governance | Data Modeling | Data Preparation | Data Quality | ETLFlexible work environment | TeleworkMid-level Full TimeSherbrooke, Canada R5d ago