Data Analyst

2 weeks ago


Ottawa, Canada Tundra Technical Solutions Inc. Full time
RequirementsContract DetailsExpected Start DateJune 2024Expected End DateDecember 2024On-Site RequirementRemoteSecurity Clearance LevelRequirements: 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
  • 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...

  • 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...

  • Junior Data Analyst

    5 days ago


    Ottawa, Canada Colliers Project Leaders Full time

    Overview: We deliver capital project solutions to fulfill our clients’ needs across the built environment. The work we do makes a difference in communities and for the people who live there. We have a passion for it. Our commitment to realizing our clients' vision inspires us to look beyond the immediate - to the _possibilities_ of what we can achieve...

  • Data Analyst

    4 days ago


    Ottawa, Canada R.W. Tomlinson Limited Full time

    **Data Analyst - AI Specialist**: **RESPONSIBILITIES**: - Gather requirements from internal stakeholders to understand business needs - Collect, clean, and transform large datasets to be used for machine learning models - Develop and maintain data models that can be used by AI systems - Develop machine learning models using various programming languages and...

  • Data Analyst

    2 weeks ago


    Ottawa, Canada Tundra Technical Solutions Inc. Full time

    RequirementsContract DetailsExpected Start DateJune 2024Expected End DateDecember 2024On-Site RequirementRemoteSecurity Clearance LevelRequirements: 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...

  • Data Analyst

    5 days ago


    Ottawa, Canada Canadian Tire Corporation, Ltd. Full time

    Data Analyst Job types - part time Daily Income Assist with online Operation Overtime is available Age limit :20 above No Experience required (training provided) The job is: - Star rating of tourist attractions - Increasing visibility and popularity search - Giving consumers a better choice (Training provided ) **Job Type**: Part-time **Salary**:...


  • 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, Canada Nanometrics Inc Full time

    **Working Title**:Data Analyst **Reports to**:Manager, Data Centre Operations **Based in**:Ottawa, ON **Term**: 12 months **About Us** **About You** You are passionate about processing data in a collaborative environment! You are eager to understand the data’s story by connecting all the intricacies the data is telling us. You don’t shy away from a...

  • Data Analyst

    4 weeks ago


    Ottawa, 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

    3 weeks ago


    Ottawa, 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

    3 weeks ago


    Ottawa, 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...