Data Warehouse ETL Developer Services

3 weeks ago


Greater Ottawa Metropolitan Area, CA Systematix Full time

We are Systematix and we are looking for a Data Warehouse ETL Developer for an upcoming opportunity with a Federal Government department. The ideal candidate must already possess a security clearance at the Reliability level (Level I) or higher. There is a requirement for the resource to work on weekend and holidays (on a rotation) from 9:00AM to 11:00AM and be available on-call during this period for incidents that may arise. The resource must be bilingual in both official languages (English and French).


About the Project

The resource designs, develops, and maintains data warehouse and analytics architecture to meet the client’s enterprise’s business analysis and reporting needs. The resource also provides support to the organization’s business requirements in the application and consumption of information from the Enterprise Data Warehouse (EDW) or from other source systems. The resource works with architects and business partners to fashion out the technical vision for applications in the Data Warehouse. The resource is ensures the functionality, security, availability and accuracy of the information within the Data Warehouse environment.


About the Responsibilities

  • Designs, maintains, and provides support for data warehouse systems and related data marts;
  • Translates business requirements into viable technical solutions;
  • Participates in the testing of developed technical solutions;
  • Participates in the investigation and resolution of complex Data Warehouse issues;
  • Proactively identifies opportunities for process, systems, and other efficiency improvements;
  • Works effectively in the team and contributes to team effectiveness through personal style;
  • Design data integration/ETL jobs using DataStage and its foundation tools in a SQL Server and Windows environment.


About the Qualifications

  • Minimum of eight years of related experience and knowledge;
  • Recent experience working with Cognos Data Manager
  • 5+ years’ experience with IBMs ETL tool, IBM InfoSphere DataStage;
  • Relational data base concepts and design;
  • Technical testing techniques and tools;
  • Logical and physical data modeling;
  • Requirements analysis;
  • Technical design skills;
  • Proficient technical writing skills;
  • Ability to translate business questions and requirements into technical solutions;
  • Demonstrated application of technical problem solving and analytical tools and techniques;
  • Experience with SQL Server;
  • Bilingualism in both official languages (English and French).
  • Experience with IBM Cognos Business Intelligence Technologies (Report Studio, Framework Manager, Transformer and Query Studio).


Candidates must outline in detail how they meet the above requirements.


At Systematix, our core values—excellence, collaboration, respect, and knowledge as a pursuit—underpin our commitment to fostering an inclusive and equitable environment. We encourage everyone to be their authentic selves, and we are committed to ensuring that our employment decisions are entirely based on job requirements and individual qualifications. We welcome applications from qualified candidates of all backgrounds, including but not limited to race, ethnicity, gender identity or expression, sexual orientation, disability, age, and religious beliefs. If our values and the position advertised resonate with you, we encourage you to apply.



  • Greater Ottawa Metropolitan Area, CA Quarry Consulting Full time

    Role: Enterprise DW DataStage ConsultantRemote5+ years in CanadaMUST Have - 8 eight yearsWorking with Cognos Data ManagerExperience designing, maintaining, and providing support for data warehouse systems.Designing data integration/ETL jobs using DataStage and its foundation tools in a SQL Server and Windows environment5+ years’ experience with IBMs ETL...


  • Greater Montreal Metropolitan Area, CA SEG Products Full time

    We are a consumer-packaged goods company located in the heart of downtown Montreal, specializing in manufacturing, developing, designing, and marketing consumer products under license for a major American national brand. Our mission is to provide high-quality products that meet market demand through effective planning and innovation.Position Summary: We are...


  • Greater Ottawa Metropolitan Area, CA LeverageTek Staffing Solutions Full time

    LeverageTek is actively seeking an Enterprise Content Management (ECM) Developer for a 12-month contract with chance at extension with its Ottawa-based customer.Work LocationRemoteKey TasksCleansing the content/records/users in the existing ECM.Support and maintain the existing ECM (Documentum) environment.Developing a migration strategy in conjunction with...


  • Greater Montreal Metropolitan Area, CA HRConnects Full time

    The RoleWe are Looking for an experienced Scala/Java Full Stack Developer with strong experience and proficiency with Java or Scala, Scala-Spark or PySpark. The ideal candidate should possess exceptional communication skills. This permanent full-time position is hybrid and located in Montreal, offering a competitive benefit package.ResponsibilitiesDesigning,...

  • Lead Java Developer

    4 weeks ago


    Greater Montreal Metropolitan Area, CA Presto Recruiting Solutions Full time

    Job Description:We are looking for multiple Java developers with backend or full-stack development experience to join our growing team. This role requires a Java expert capable of working on complex projects, designing scalable systems, and optimizing application performance. If you are passionate about building powerful and reliable applications, we would...


  • Greater Vancouver Metropolitan Area, CA ClearVision Technologies, Inc. Full time

    ClearVision is involved in the design and manufacture of machine vision systems for quality control. Our primary customers are manufacturers in the paper, carton, and corrugated box industries. We assemble industrial cameras, sensors, our own lighting and control systems, industrial PCs, and touchscreen interfaces to create a complete inspection system. We...

  • BIM Modeler

    4 weeks ago


    Greater Ottawa Metropolitan Area, CA Salas O'Brien Full time

    BIM Modeler, OTTAWA, ONAt Salas O’Brien we tell our clients that we’re engineered for impact. This passion for making a difference applies just as much to our team as it does to our projects. That’s why we’re committed to living our values every day: inspiring, achieving, and connecting as shared owners of our success with a focus on a sustainable...


  • Greater Montreal Metropolitan Area, CA HireTalent - Staffing & Recruiting Firm Full time

    Project Manager 12 months contract Montreal, QC (hybrid 3 days onsite) Summary of the Role The Finance project manager will manage a large scope of projects.Main Responsibilities · Regulatory projects: Adapting finance reporting to meet Regulatory requirements for Head office.· Business Projects: Adapting finance systems to handle new products or needs...

  • Warehouse Associate

    4 weeks ago


    Greater Quebec City Metropolitan Area, CA Arrow Workforce Solutions Full time

    Arrow Workforce Solutions embauche actuellement des conducteurs de chariots élévateurs pour rejoindre l'équipe dynamique située à Saint-Augustin-de-Desmaures, QC. Nous offrons des heures à temps plein selon les besoins de l'entreprise et un environnement de travail convivial.Quels sont vos avantages ?40 heures garanties par semaineSalaire...

  • Account Manager

    4 weeks ago


    Greater Montreal Metropolitan Area, CA Quantiphi Full time

    About Us:Quantiphi is an award-winning Applied AI and Big Data software and services company, driven by a deep desire to solve transformational problems at the heart of businesses. Our signature approach combines groundbreaking machine-learning research with disciplined cloud and data-engineering practices to create breakthrough impact at unprecedented...


  • Greater Ottawa Metropolitan Area, CA LeverageTek Staffing Solutions Full time

    LeverageTek is actively seeking a bilingual Project Coordinator for a 6-month contract with its Ottawa-based customerWork LocationThe successful candidate will be required to work 3x/week on-site at the customer headquarters in Ottawa, ON (after 2 weeks training of 5x/week onsite)Key TasksResponsible for supporting and coordinating projects, and executing...

  • Total Rewards Analyst

    3 weeks ago


    Greater Montreal Metropolitan Area, CA Stella-Jones Full time

    Company OverviewStella-Jones is North America's leading producer of industrial pressure-treated wood products. Responding to the vital infrastructure needs of our economy, we manufacture and distribute railway ties, utility poles, residential lumber and industrial wood products across the continent. The Company’s common shares are listed on the Toronto...


  • Greater Quebec City Metropolitan Area, CA Cansel Full time

    About Us: We are a dynamic and innovative company dedicated to enhancing our customers' experiences and driving sales growth. We are looking for a motivated and proactive individual to join our team as a Customer Service Representative. This role is perfect for someone who enjoys interacting with customers, has a knack for sales, and excels in...

  • Chemical Analyst

    3 weeks ago


    Greater Vancouver Metropolitan Area, CA Sixone Labs Full time

    Job Title Chemical AnalystLocation Burnaby, British ColumbiaDuration Full time CompanySixone’s mission is to enable a world where blended plastics products can be circularly recycled back into existing supply chains instead of being sent to landfill. Sixone is a leading technology startup company developing advanced recycling...


  • Greater Montreal Metropolitan Area, CA PARAMOUNT Recruitment Full time

    Commercial Printer Sales Representative, printing equipmentBase Salary $50,000+ commission position is available immediately Our client, a wholesale printer supplies provider, Is looking for a Sales Representative to join their team. In this role, you’ll engage with corporate clients and businesses to find ways to meet their needs through printing...

  • Procurement Advisor

    3 weeks ago


    Greater Ottawa Metropolitan Area, CA Quarry Consulting Full time

    Role: Procurement AdvisorDuration: 6-12 months Location: Hybrid OttawaRequirements:Bachelor's or College diploma 7-8 years of experience in providing advice and support on procurement matters of varying complexity, including experience procuring information technology and related services.Experience procuring information technology and related services....


  • Greater Edmonton Metropolitan Area, CA CMB Insurance Brokers Full time

    GENERAL DESCRIPTIONUnder the direction of the Branch President, the Senior Producer’s primary responsibility will be to build a book of business from leads generated by the BDR team and yourself. In this role, you will work directly with your assigned Producer, BDR, and service team, as a mentor and coach. You will convert leads into customers by...


  • Greater Montreal Metropolitan Area, CA Beiersdorf Full time

    Sr. Analyst, Quality and Regulatory AffairsIt all started with a pharmacist and a dream 140 years ago. Today, Beiersdorf is a global company with iconic brands — Coppertone, Aquaphor, Eucerin, Elastoplast and NIVEA — focused on providing innovative, clinically-proven and safe skin and sun care solutions to more than 500 million consumers in over 200...


  • Greater Ottawa Metropolitan Area, CA N-able Full time

    IT doesn’t get better than this! N-able isn’t just another software company – we’re going places, and we’d love for you to be a part of that journey. With N-ablites in more than 15 countries around the world, you’re adding your unique voice to a diverse team of people who are supporting our customers, and one another. The Way We Work, our hybrid...


  • Greater Vancouver Metropolitan Area, CA MyGreat Recruitment Inc. Full time

    ***Please do not direct message the author of this job advert. Due to the high number of applicants they will be unable to respond***Job Title: Assistant Site SuperintendentLocation: Vancouver, BCSalary Range: $73,499 - $96,899Overview We are looking for an Assistant Superintendent to join our client's team. The successful candidate will support on-site...