Data Analyst

2 weeks ago


Ottawa ON, Canada Tundra Technical Solutions Inc. Full time

Requirements Contract Details Expected Start Date June 2024 Expected End Date December 2024 On-Site Requirement Remote Security Clearance Level Requirements: This work will require Reliability statusDescription of ServiceThe marketing department has a need for a data analyst to support the migration of 3rd party data (company and individual level data) and other internal data sources into the Enterprise data platform (data lake) to be leveraged for various marketing analysis.Primary ResponsibilitiesWorking closely with the customer analytics team in marketing, the data analyst would be responsible for analysis of external and internal data sources and mapping to data in the Enterprise Data Platform (EDP). The individual will work closely with marketing analysts, as well as other data roles, such as data architects and data engineers to deep dive into the business rules and data transformation rules requirements, as well as analyze and document new requirements and to be able to help the design of the new data integration stream or update the existing data pipeline.

Specific Project Requirements

  • Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
  • Demonstrated experience in SQL programming is required.
  • Strong knowledge and demonstrated experience in current and future state data mapping.
  • Identify qualified/approved records for system upload.
  • Identify and resolve discrepancies (format, content, values).
  • Work with business team members on resolving quality issues.

SkillsTop Skills Required

  • Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
  • Well-rounded experience in the whole data lifecycle management and hands-on experience in the following data management domains: dimensional and relational data modeling, data quality, SQL programming (minimum 5 years), ETL development, metadata management and master data management, business intelligence and database administration.
  • Experience with reverse engineering the source to target mapping to gain data insights
  • Experience refactoring existing SQL code to new/alternate data sources.

Other Skills Required

  • Experience with Azure Data Platform technologies or other public cloud offerings
  • Experience with Databricks
  • Programming experience: SQL, R, Python
  • Understanding of Denodo platform
  • Excellent verbal and written communication, critical thinking, time management, priority planning and interpersonal skills.
  • Ability to understand and interpret requirements and design documents
  • Ability to write and maintain documentation

Assets

  • Experience working in an Agile environment/team
  • Bilingualism in both official languages (English and French)
  • Greater than 5 years of SQL development and refactoring existing SQL

Job 70307

#J-18808-Ljbffr

  • London, ON, Canada Abs Data Full time

    Install Coordinator/Data Analyst/Data Entry Clerk/Part Time Install Coordinator/Data Analyst/Data Entry Clerk/Part Time be responsible for analyzing and interpreting large datasets to provide valuable insights and recommendations to the business. They will work closely with cross-functional teams to gather and analyze data, develop reports, and provide...

  • Virtual data analyst

    3 weeks ago


    London, ON, Canada Abs Data Full time

    Virtual Data Analyst/Virtual Data Entry Clerk Part Time The Data Analyst will be responsible for analyzing and interpreting large datasets to provide valuable insights and recommendations to the business. They will work closely with cross-functional teams to gather and analyze data, develop reports, and provide customized solutions to help the organization...

  • Office admin

    3 weeks ago


    London, ON, Canada Abs Data Full time

    Office Admin/Data Analyst/Data Entry Clerk/Part Time Job description : Summary: Office Admin/Data Analyst/Data Entry Clerk/Part Time will be responsible for analyzing and interpreting large datasets to provide valuable insights and recommendations to the business. They will work closely with cross-functional teams to gather and analyze data, develop...


  • Ottawa, ON, Canada Systematix group Full time

    We are Systematix and we are looking for Data Analyst Services for an upcoming opportunity with a Federal Government department. About the Project The services of an experienced Data Analyst Services are required to support work for transformation of current data processes for IFRS9 models to a modernized and governed IT environment. About the...

  • Data Analyst

    4 weeks ago


    Ottawa, ON, Canada Talasoft Full time

    We are seeking a skilled Data Analyst to join our team and contribute to our mission of leveraging data to drive informed decisions and achieve business objectives. If you have a passion for working with data and uncovering valuable insights, we encourage you to apply and be a part of our exciting journey. Responsibilities may encompass, but are not...

  • Data Analyst

    4 weeks ago


    Ottawa, Canada vTech Solution Full time

    **Job Title: Data Analyst (Intermediate/Senior)** **Location: Nepean, Ottawa, ON** **Duration: 12+ months (with possible extension)** The Data Analyst should have the following experience and qualifications: - Completed an undergraduate degree in Business Administration, Computer Science, Management Information Systems, Engineering or in a related...

  • Data Analyst

    4 weeks ago


    Ottawa, Canada Canadian Wildlife Federation Full time

    **_Your Connection to Wildlife_**: - As one of Canada’s largest not for profit leaders in wildlife conservation, research, and advocacy, we are seeking to fill the following position _ **Data Analyst** **Who we are**: The Canadian Wildlife Federation (CWF) is a national not-for-profit charitable organization dedicated to ensuring an appreciation of our...


  • Ottawa, Canada Systematix group Full time

    We are Systematix and we are looking forData Analyst Servicesfor an upcoming opportunity with a Federal Government department.About the ProjectThe services of an experienced Data Analyst Services are required to support work for transformation of current data processes for IFRS9 models to a modernized and governed IT environment.About the ResponsibilitiesThe...


  • Ottawa, Canada Systematix group Full time

    We are Systematix and we are looking forData Analyst Servicesfor an upcoming opportunity with a Federal Government department.About the ProjectThe services of an experienced Data Analyst Services are required to support work for transformation of current data processes for IFRS9 models to a modernized and governed IT environment.About the ResponsibilitiesThe...


  • Ottawa, Canada Systematix group Full time

    We are Systematix and we are looking forData Analyst Servicesfor an upcoming opportunity with a Federal Government department.About the ProjectThe services of an experienced Data Analyst Services are required to support work for transformation of current data processes for IFRS9 models to a modernized and governed IT environment.About the ResponsibilitiesThe...


  • Ottawa, Canada Systematix Full time

    We are Systematix and we are looking for  Data Analyst Services  for an upcoming opportunity with a Federal Government department. About the Project The services of an experienced Data Analyst Services are required to support work for transformation of current data processes for IFRS9 models to a modernized and governed IT environment. About...


  • Ottawa, ON, Canada Englobe Full time

    Your Employer Dare to join Englobe At nearly 3,000 people, Englobe is one of Canada's premier firms specializing in professional engineering services, environmental sciences, and soil and biomass treatment. With offices located across Canada, the United Kingdom and France, we are conveniently located to support large- and small-scale projects,...

  • Data Analyst

    4 weeks ago


    Ottawa, Canada Hydro Ottawa Full time

    By generating and distributing power, each person at Hydro Ottawa is part of empowering the lives of people in the communities we serve. Our work means all the activities that make up our lives - at home, at work, at play - are there when we need them. That purpose unites us and fuels our work. And if joining us in this essential work energizes you too, we...

  • Senior Data Analyst

    4 weeks ago


    Ottawa, Ontario, Canada Definity Careers Full time

    The Senior Data Analyst is an innovative and experienced analytics professional with hands-on expertise in all facets of data product development and a driving passion for turning business challenges and needs into game-changing data products.Reporting to the Director, Data Leadership, the Senior Data Analyst will be an integral part of an innovative and...

  • Data Analyst

    4 weeks ago


    Ottawa, Canada Quarry Consulting Full time

    Title: Data Analyst Location: Fully remote (location is Ottawa)Duration: 1-year contract (start in June)*** MUST have Reliability clearance or have live in Canada for 5-consecutive years***Top Skills Required:Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail...

  • Data Analyst

    4 days ago


    Ottawa, Canada Kinaxis Full time

    **About Kinaxis**: **Data Analyst**: **Job location**:our office in_ _Ottawa, Canada. We work in a hybrid model where the expectation is to work a minimum of 3 days in the office. **About the team**: The Data Analyst proactively partners with stakeholders to understand business objectives and identifies areas where efficiency and productivity could be...

  • Data Analyst

    4 days ago


    Ottawa, Canada Kinaxis Full time

    **About Kinaxis**: **Data Analyst**: **Job location**:our office in_ _Ottawa, Canada. We work in a hybrid model where the expectation is to work a minimum of 3 days in the office. **About the team**: The Data Analyst proactively partners with stakeholders to understand business objectives and identifies areas where efficiency and productivity could be...


  • Ottawa, ON, Canada GSI environement Incorporé d'Filial Englobe Full time

    Your Employer Dareto joinEnglobe At nearly 3,000 people, Englobe is one of Canada’s premier firms specializing in professional engineering services, environmental sciences, and soil and biomass treatment. With offices located across Canada, the United Kingdom and France, we are conveniently located to support large- and small-scale projects, through...

  • Data Analyst

    4 weeks ago


    Toronto, ON, Canada Opencloudco Full time

    Roles and Responsibilities: Analyze and interpret data to identify trends, patterns, and insights. Develop and maintain dashboards and reports to track key performance indicators and metrics. Design and execute A/B tests and experiments to measure the impact of changes and improvements. Collaborate with cross-functional teams to identify business...

  • Research Analyst

    3 weeks ago


    Toronto, ON, Canada ICES: Data, Discovery, Better Health Full time

    Data. Better Health. ICES is a world-leading health research and analytics institute. With a wealth of data and analytic expertise, we create trusted evidence that has changed health policy and practice and helps ensure better health for all.  Flexible remote work arrangements anywhere in Ontario HOOPP Pension Plan (Defined Pension) Holiday Closure ...