Data Analytics

3 weeks ago

Ottawa, Canada CB Canada Full time

ETL Developer – Data Analytics

Job Description:

The Data Analytics team is receiving an unprecedented number of requests for work packages. These requests require Impact Analysis and estimates for both Tower and CPC requests which require dedicated resources to work with the business, understand requirements, and delve into the code and database design. You will be learning Canada Post business areas while improving our ability to deliver project solutions.

Primary Responsibilities:

  • Load target databases using complex transformations from our source systems ensuring best practices and standards are followed.
  • Work with the Data Architects to understand the business requirements and technical specifications and translate them into ETL code.
  • Participate in design review sessions, code reviews, and our Agile team meetings
  • Develop test scenarios and perform in-depth unit tests, including end-user reviews
  • Define ETL job sequence and dependencies including error logging and restart processes as well as develop ETL run books
  • Work on technical debt projects and with the Assessment team, using our estimating template to ensure all intakes for ERP, NGTT, and Towers are completed in a timely manner so that funding can be secured, and the Product Teams on Data Analytics have visibility into the resources and timelines for the intakes.

Must Have:

  • 3 to 5 years of relevant ETL/DI experience.
  • 3+ year experience in IBM infosphere tool suite (DataStage & QualityStage).
  • 3+ year development with database technologies. 1+ year experience with data warehousing methodologies.
  • Teradata experience

Nice to have:

  • Cloud Technologies (Azure, AWS…)
  • Familiarity with Agile methodology
  • Familiarity with JIRA

Duration:

9 Months

Location:

Ottawa/Toronto – remote/hybrid environment

  • Data Engineer

    2 days ago

    Ottawa, Canada Tiger Analytics Full time

    Tiger Analytics is a fast-growing advanced analytics consulting firm. Our consultants bring deep expertise in Data Science, Machine Learning and AI. We are the trusted analytics partner for multiple Fortune 500 companies, enabling them to generate business value from data. Our business value and leadership has been recognized by various market research...

  • Data Engineer

    3 weeks ago

    Ottawa, Canada Tiger Analytics Full time

    Tiger Analytics is a fast-growing advanced analytics consulting firm. Our consultants bring deep expertise in Data Science, Machine Learning and AI. We are the trusted analytics partner for multiple Fortune 500 companies, enabling them to generate business value from data. Our business value and leadership has been recognized by various market research...

  • Specialist, Data Analytics

    2 weeks ago

    Ottawa, Canada Canada Post Full time

    Job Description The Specialist, Data Analytics is responsible for the delivery of leading-edge analytical solutions. This key role will work closely with the Marketing team to understand the data needs of different customer segments and craft solutions to support information-based decisions. Leveraging knowledge in Business Intelligence (BI),...

  • Lead, Data Systems and Analytics

    3 days ago

    Ottawa, Canada CADTH Full time

    **Status**: Full time, indefinite **Location**: Ottawa, Ontario (hybrid) **Closing date**: April 30, 2024 **Salary range**: $ 97,000 to 121,000 per year CADTH is Canada’s drug and health technology agency. We are an independent, not-for-profit organization headquartered in Ottawa, with a satellite office in Toronto. Funded by Canada’s federal,...

  • Analytics Engineer

    3 weeks ago

    Ottawa, Canada Definity Full time

    Job Description The Analytics Engineer spearheads the development and delivery of innovative analytical solutions in collaboration with business stakeholders and technical teams across the organization.  The Analytics Engineer reports to the Director, Data Leadership as a key member of a high-performing Data and Analytics team...

  • Data Analytics

    4 weeks ago

    Ottawa, Canada 2i Solutions, Inc Full time

    There is a 15 months contract opportunity for a Data Analytics & Report Developer in Ottawa.Reliability level security clearance is mandatory.Must have Experience in developing Reports, SQL Query and Data Base Administration.Experience in creating reports using PowerBI and/or Tableau and writing and reading SQL on intermediate to complex queries.Experience...

  • Data Analytics

    3 weeks ago

    Ottawa, Canada 2i Solutions, Inc Full time

    There is a 15 months contract opportunity for a Data Analytics & Report Developer in Ottawa.Reliability level security clearance is mandatory.Must have Experience in developing Reports, SQL Query and Data Base Administration.Experience in creating reports using PowerBI and/or Tableau and writing and reading SQL on intermediate to complex queries.Experience...

  • Data Analytics

    3 weeks ago

    Ottawa, Canada 2i Solutions, Inc Full time

    There is a 15 months contract opportunity for a Data Analytics & Report Developer in Ottawa.Reliability level security clearance is mandatory.Must have Experience in developing Reports, SQL Query and Data Base Administration.Experience in creating reports using PowerBI and/or Tableau and writing and reading SQL on intermediate to complex queries.Experience...

  • Data Analytics

    34 minutes ago

    Ottawa, Canada 2i Solutions, Inc Full time

    There is a 15 months contract opportunity for a Data Analytics & Report Developer in Ottawa.Reliability level security clearance is mandatory.Must have Experience in developing Reports, SQL Query and Data Base Administration.Experience in creating reports using PowerBI and/or Tableau and writing and reading SQL on intermediate to complex queries.Experience...

  • Data Analytics

    4 weeks ago

    Ottawa, ON, Canada 2i Solutions, Inc Full time

    There is a 15 months contract opportunity for a Data Analytics & Report Developer in Ottawa. Reliability level security clearance is mandatory. Must have Experience in developing Reports, SQL Query and Data Base Administration. Experience in creating reports using PowerBI and/or Tableau and writing and reading SQL on intermediate to complex queries. ...

  • Program Lead, Analytical Data Management

    7 days ago

    Ottawa, Canada Canadian Institute for Health Information Full time

    **Category** - Professional **City** - Ottawa, Toronto, Ontario, Canada - Program Lead, Analytical Data Management - Who we are - We are an organization comprised of industry thought leaders who are passionate about health data and want to make a difference in the health care field. We are an independent, not-for-profit organization and together with our...

  • Data Analytics

    2 weeks ago

    Ottawa, Canada Fortinet Full time

    Job Description: Fortinet is seeking a data analytics and insight specialist to join the Customer Success Operations team. The Customer Success Operations team is responsible for generating key insights into the performance of Fortinet's CS organisation. In this role, you will be responsible for conducting regular reporting and analysis of CS team...

  • Data Analytics

    2 weeks ago

    Ottawa, Canada Fortinet Full time

    Job Description: Fortinet is seeking a data analytics and insight specialist to join the Customer Success Operations team. The Customer Success Operations team is responsible for generating key insights into the performance of Fortinet's CS organisation. In this role, you will be responsible for conducting regular reporting and analysis of CS team...

  • Data Analytics

    2 weeks ago

    Ottawa, Canada Fortinet Full time

    Job Description: Fortinet is seeking a data analytics and insight specialist to join the Customer Success Operations team. The Customer Success Operations team is responsible for generating key insights into the performance of Fortinet's CS organisation. In this role, you will be responsible for conducting regular reporting and analysis of CS team...

  • Data Analytics

    3 weeks ago

    Ottawa, Canada Fortinet Full time

    Fortinet is seeking a data analytics and insight specialist to join the Customer Success Operations team. The Customer Success Operations team is responsible for generating key insights into the performance of Fortinet's CS organisation. In this role, you will be responsible for conducting regular reporting and analysis of CS team performance including...

  • Analytics Engineer

    3 weeks ago

    Ottawa, Ontario, Canada Definity Careers Full time

    The Analytics Engineer spearheads the development and delivery of innovative analytical solutions in collaboration with business stakeholders and technical teams across the organization. The Analytics Engineer reports to the Director, Data Leadership as a key member of a high-performing Data and Analytics team focused on delivering impactful insights and...

  • Data Analytics

    1 week ago

    Ottawa, Canada Fortinet Full time

    Fortinet is seeking a data analytics and insight specialist to join the Customer Success Operations team. The Customer Success Operations team is responsible for generating key insights into the performance of Fortinet’s CS organisation. In this role, you will be responsible for conducting regular reporting and analysis of CS team performance including...

  • Analytics Architect

    1 day ago

    Ottawa, Canada CMHC - SCHL Full time

     Job Requisition ID: 10180  Position Status: Permanent Full Time Position Type: Hybrid   Office Location: Ottawa (ON); Montreal (QC); Toronto (ON)Travel Requirement: Limited Language Designation: English Essential Language Skill Levels (Read/Write/Speak): ZZZ Salary: Our salaries generally range from $ 99646.37 to $ 124557.97 and are...

  • Analyst, Reporting and Data Analytics for Cloud Financial Management

    1 day ago

    Ottawa, Canada Parliament of Canada Full time

    Job Description The House of Commons Digital Services and Real Property is currently looking to staff the Analyst, Reporting and Data Analytics Cloud Financial Management position. Join our team as the Analyst, Reporting and Data Analytics for Cloud Financial Management! In this role, you will be responsible for monitoring, analyzing, and reporting on...

  • Data Analytics

    2 weeks ago

    Ottawa, ON, Canada Fortinet Full time

    Job Description: Fortinet is seeking a data analytics and insight specialist to join the Customer Success Operations team. The Customer Success Operations team is responsible for generating key insights into the performance of Fortinet's CS organisation. In this role, you will be responsible for conducting regular reporting and analysis of CS team...