Data Warehouse Senior Analyst

1 month ago


Ottawa, Ontario, Canada CMHC Full time
About the Role

CMHC is seeking a highly skilled Data Warehouse Senior Analyst to join our Enterprise Data Office. In this role, you will be responsible for providing support on executing data profiling activities and deriving insights from data analysis. You will also be responsible for developing and maintaining data quality rules and ensuring that testing on the rules is performed, as well as supporting the root cause analysis for data quality issues, the resulting remediation plan, and its execution.

Key Responsibilities
  • Provide scoping assistance in the process of collecting and analyzing information used to establish the effort required to deliver a business use case, initiative, or a project, the risk involved, and the value added to the business.
  • Execute data profiling assessments and provide insights to data stewards and business stakeholders into the quality of the data.
  • Define the data quality rules needed to meet the data quality business requirements to achieve a specific business intended purpose.
  • Develop and maintain data quality standards and ensure they are in alignment with company objectives and industry best practices.
  • Support and provide insights to data stakeholders on displaying data quality metrics and validating their values, and recommend ongoing enhancements to methods and models to lead to insights.
  • Collaborate with IT and business stakeholders to enhance data quality tools and processes.
  • Work closely with business lines, data stewards, project/program managers, and IT teams, including partners, to turn data into critical information and knowledge that can be used to make sound organizational decisions.
Requirements
  • An undergraduate degree in computer science or another related field.
  • A minimum of 3 years of experience working in the field of data.
  • A demonstrated experience of data governance and management (data classification, data profiling, data inventory, data catalog and data lineage (including mapping).
  • An experience with Data Governance, Data Management, Data Quality, and/or Data Analysis tools.
  • An understanding of data governance principles and data management processes (including data management lifecycle).
  • Bilingualism (English and French).
  • Well-developed qualitative and quantitative analysis skills.
  • The ability to take initiative and work independently on individual projects.
Our Commitment to Diversity, Equity, and Inclusion

CMHC is an inclusive workplace where diversity of thought – and of people – are recognized, valued, and considered essential to achieving our mission. We're committed to employment equity and encourage women, Indigenous Peoples, persons with disabilities, veterans and persons of all races, ethnicities, religions, abilities, sexual orientations, and gender identities and expressions to apply.


  • Data Analyst

    4 weeks ago


    Ottawa, Ontario, Canada SEAMS DATA Full time

    At SEAMS DATA, we are seeking a skilled Database Specialist to join our team. As a key member of our data team, you will be responsible for designing and developing databases, operating database management systems to analyze data, and developing and implementing data administration policy, standards, and models.The ideal candidate will have a strong...

  • Data Analyst

    4 weeks ago


    Ottawa, Ontario, Canada SEAMS DATA Full time

    At SEAMS DATA, we are seeking a skilled Database Specialist to join our team. As a key member of our data management team, you will be responsible for designing and developing databases, operating database management systems to analyze data, and developing and implementing data administration policy, standards, and models.The ideal candidate will have a...

  • Senior Data Analyst

    4 weeks ago


    Ottawa, Ontario, Canada Assent Full time

    Job Title: Senior Data AnalystJob Summary:We are seeking a highly skilled Senior Data Analyst to join our team at Assent. As a Senior Data Analyst, you will play a pivotal role in advancing data capabilities to drive growth in our B2B SaaS business. You will lead efforts to streamline data processes, develop robust models and dashboards, and deliver...


  • Ottawa, Ontario, Canada CMHC Full time

    About the RoleCMHC is seeking a highly skilled Bilingual Data Quality Analyst to join the Enterprise Data Office. In this senior role, you will be responsible for providing support on executing data profiling activities and deriving insights on the data based on analysis. You will also be responsible for developing and maintaining data quality rules and...

  • Senior Data Analyst

    4 weeks ago


    Ottawa, Ontario, Canada Assent Full time

    Senior Data Analyst Job DescriptionAssent is seeking a highly skilled Senior Data Analyst to play a pivotal role in advancing data capabilities and driving growth in our B2B SaaS business. This individual will lead efforts to streamline data processes, develop robust models and dashboards, and deliver actionable insights that shape strategic decisions across...

  • Senior Data Analyst

    4 weeks ago


    Ottawa, Ontario, Canada Assent Full time

    Senior Data AnalystAssent is seeking a highly skilled Senior Data Analyst to play a pivotal role in advancing data capabilities and driving growth in our B2B SaaS business. This individual will lead efforts to streamline data processes, develop robust models and dashboards, and deliver actionable insights that shape strategic decisions across...

  • Senior Data Analyst

    4 weeks ago


    Ottawa, Ontario, Canada Canadian Institute for Health Information Full time

    About the RoleThe Senior Analyst, Canadian Joint Replacement Registry, is a key member of an interdisciplinary team responsible for leading analyses related to joint replacements. This includes producing annual reports, conducting data quality analyses, supporting data collection activities, and leading data requests. The Senior Analyst will also provide...

  • Senior Data Analyst

    4 weeks ago


    Ottawa, Ontario, Canada Canadian Institute for Health Information Full time

    About the RoleThe Senior Analyst, Canadian Joint Replacement Registry, plays a critical role in leading analyses related to joint replacements. This includes producing annual reports, conducting data quality analyses, supporting data collection activities, and leading data requests. The Senior Analyst will also provide analytical leadership on new analyses...

  • Senior Data Analyst

    3 weeks ago


    Ottawa, Ontario, Canada Canadian Institute for Health Information Full time

    Job Title: Senior Data Analyst - Business InsightsAbout the Role: As a Senior Data Analyst, you will be responsible for analyzing and interpreting complex data sets to inform business decisions.Key Responsibilities:Analyze and interpret large data sets to identify trends and insightsDevelop and maintain data visualization tools to communicate findings to...

  • Data Architect

    2 weeks ago


    Ottawa, Ontario, Canada SEAMS DATA Full time

    At SEAMS DATA, we are looking for a talented Data Architect to join our team. The ideal candidate will have a strong background in database design and development, with experience in operating database management systems to analyze data. Key responsibilities include designing and developing databases, developing and implementing data administration policy,...


  • Ottawa, Ontario, Canada NTT DATA Full time

    About the RoleWe are seeking an experienced Senior Business Analyst to join our team in Canada. The successful candidate will have a strong background in business analysis, process improvement, and project management.Key ResponsibilitiesDevelop and maintain operational processes for information creation, storage, access, management, sharing, and...

  • Data Analyst

    3 weeks ago


    Ottawa, Ontario, Canada Canadian Institute for Health Information Full time

    About This RoleSenior Analyst, Data Request Services at Canadian Institute for Health InformationJoin Our TeamCome and contribute your expertise to our Data Request Services team at the Canadian Institute for Health Information (CIHI)!Key ResponsibilitiesAs a Senior Analyst, Data Request Services, you willRespond to custom data requests from clients;Conduct...

  • Senior Data Analyst

    1 month ago


    Ottawa, Ontario, Canada Canadian Institute for Health Information Full time

    About the RoleAt the Canadian Institute for Health Information, we're committed to making a positive impact on the health care system. As a Senior Analyst, Data Request Services, you'll play a key role in helping us achieve this goal.Key ResponsibilitiesRespond to customized data requests from internal and external clients, ensuring timely and accurate...


  • Ottawa, Ontario, Canada Geofirma Engineering Ltd Full time

    Job Title: Environmental Data AnalystAt Geofirma Engineering Ltd, we are seeking a highly skilled Environmental Data Analyst to join our team. As an Environmental Data Analyst, you will play a key role in conducting studies of groundwater flow and contamination, developing models and applied software for the analysis and interpretation of data, and ensuring...


  • Ottawa, Ontario, Canada SEAMS DATA Full time

    At SEAMS DATA, we are seeking a skilled Data Systems Specialist to join our team. The ideal candidate will have a strong background in database design and development, as well as experience with database management systems.Key ResponsibilitiesDesign and develop databases to meet business needsOperate database management systems to analyze data and ensure...


  • Ottawa, Ontario, Canada SEAMS DATA Full time

    About the RoleWe are seeking a skilled Data Systems Specialist to join our team at SEAMS DATA.Job DescriptionThe ideal candidate will have a strong background in database development and management, with experience in designing and implementing data systems.This is a permanent position, working 40 hours per week. The salary for this role is estimated to be...


  • Ottawa, Ontario, Canada Black Pen Recruitment Full time

    Job Title: Senior Data Solutions ArchitectWe are seeking an experienced Senior Data Solutions Architect to join our team at Black Pen Recruitment. As a Senior Data Solutions Architect, you will be responsible for designing, implementing, and delivering large-scale data platforms, data lakes, data warehouses, and data analytics solutions using Azure cloud...


  • Ottawa, Ontario, Canada Nexus Systems Group Inc. Full time

    AWS Data Architect Senior Developer OpportunityNexus Systems Group Inc. is seeking a highly skilled AWS Data Architect Senior Developer to join our team. As a key member of our Data Analytics team, you will be responsible for designing, implementing, and maintaining AWS data pipelines, databases, and data warehousing solutions.Key Responsibilities:Design and...


  • Ottawa, Ontario, Canada CMHC - SCHL Full time

    About the RoleCMHC - SCHL is seeking a highly skilled Senior Data Quality Analyst to join their team. As a key member of the Enterprise Data Office, you will be responsible for providing support in executing data profiling activities and deriving insights on the data based on analysis.Key ResponsibilitiesProvide scoping assistance in the process of...


  • Ottawa, Ontario, Canada CMHC - SCHL Full time

    About the RoleWe are seeking a highly skilled Senior Data Quality Analyst to join our team at CMHC - SCHL. In this role, you will be responsible for providing support on executing data profiling activities and deriving insights on the data based on the analysis.Key ResponsibilitiesProvide scoping assistance in the process of collecting and analysing...