Data Analyst -Contract

Product & Engineering · Ottawa, Ontario
Department Product & Engineering
Employment Type Contractor
Minimum Experience Mid-level

Who Is Assent?

At Assent, your work helps bring transparency, sustainability, and fairness to the global community.  Our software enables responsible stewardship to improve corporate decision making. We do this by providing a window into an organization’s global supply chain and the factories in which their products are manufactured, to reduce compliance risks, environmental waste, and prevent human rights abuse. 

We’re one of the fastest-growing technology companies - from $5 million to $50 million ARR in under five years!  As the global leader in supply chain data management, we provide transparency into the supply chains of some of the world's largest and most successful companies, including 75 percent of Fortune 500 companies.  In our most recent funding round, we raised $350 Million USD in funding led by Vista Equity Partners. This is among one of the largest raises in Canadian software company history. This funding will allow us to scale with purpose, and add exceptional talent to our already remarkable team.

Follow us here

Position Summary

Reporting to the Manager, Data Services, we are looking for a tenured Data Analyst to join our team on a 6 month contract! The ideal candidate will be responsible for importing client data into the ACP and the building of packages to load data into the clients ACP. The ideal candidate is highly organized, impeccable attention to detail, excellent interpersonal skills and most importantly a great team player! Although you will be working remotely, by no means will you be left to your own devices; we will provide you with all the tools, training, and support you could ever need to succeed - and we want nothing more than for you to be as successful as possible! 


Key Requirements and Responsibilities 

  • Build the appropriate SSIS package to load the data to the client database
  • Provide reporting to CS Team as required either using office tools or SSRS
  • Provide support to migration of data between client systems and the Assent Master database 
  • Analyze and cleanse incoming and existing data 
  • Provide data support to other divisions of Assent including Sales, Marketing and Professional Services 
  • Follow guidance set out by corporate security policies and standards 

Your Knowledge, Skills & Abilities 

  • Excellent oral and written communication skills in English - you communicate clearly, concisely and with tact;
  • University/ College and/ or Post Graduate Certificate in Computer Science or Engineering (preferred)
  • 3+ years of experience in analyzing data with strong database SQL/ Procedural SQL development 
  • 3+ years of experience with Microsoft SQL Server and SSIS (SQL Server Integration Services) as well as data migration/ conversion and ETL experience
  • Experience creating reports with SSRS (SQL Server Reporting Services)
  • Experience with various data formats: XML, CSV, RDBMS and other apps such as CRM and public databases 
  • You are proficient in the use of MS Office Suite and Google applications and other Office Productivity tools
  • You are a strong team player and always willing to lend a helping hand and share your knowledge 
  • You are diligent and detail oriented as well as a strong critical thinker who can suggest, implement and find ways to do things differently and more efficiently 

Reasonable Accommodations Statement: To perform this job successfully, an individual must be able to perform the aforementioned duties and responsibilities satisfactorily. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform these essential functions.

Thank You

Your application was submitted successfully.

  • Location
    Ottawa, Ontario
  • Department
    Product & Engineering
  • Employment Type
  • Minimum Experience