Data Analyst Client Data Integration

Job description

Company Description

Assent is the leading solution for supply chain sustainability tailored for the world’s top-tier, sustainability-driven manufacturers.

Hidden risks riddle supply chains, many of which weren't built with sustainability in mind.

That's where we step in.

With insights from experts, Assent is the tool manufacturers trust for comprehensive sustainability.

We are proud to announce that Assent has crossed the US$100M ARR milestone, granting us Centaur Status.

This accomplishment, reached just 8 years following our Series A, makes us the first and only Certified B Corporation in North America's SaaS sustainability industry to celebrate this milestone.

Our journey from $5 million to US$100M ARR in just eight years has been marked by significant growth and achievements.

With our $350 million US funding led by Vista Equity Partners, we're poised for even greater expansion and are on the lookout for outstanding team members to join our mission.

Hybrid Work Model

At Assent, we proudly embrace a remote-first work model, valuing the flexibility and autonomy it provides our team.

We also acknowledge the intangible benefits of occasional in-person workdays.

For team members situated within 50 kms/31 miles of our five global offices in Ottawa, Eldoret, Penang, Columbus, Pune and Amsterdam, you can expect to come into the office at least one day a week.

Similarly, those near our co-working spaces in Nairobi and Toronto are encouraged to work onsite once a month.

Job Description

The Data Analyst plays a critical role in supporting Assent’s data operations by importing, analyzing, and migrating customer and operational data into the system.

This position requires strong technical skills in data analysis, SQL, and SSIS, along with the ability to provide reporting and data support across departments.

The Data Analyst contributes to key product functionality, client services, and operational efficiency across the organization.

Key Requirements & Responsibilities

Develop and maintain SSIS packages to efficiently load client data into the database.

Assist in data migration and conversion between client systems and Assent’s master database.

Clean, restructure, and analyze client datasets using SQL, Excel, and SSIS to ensure accuracy and usability.

Write complex queries and apply advanced Excel functions (e.g., Power Query, pivot tables, formulas) to troubleshoot and process data at scale.

Collaborate with stakeholders across departments to understand data requirements, communicate insights, and ensure data is accurate, usable, and supports decision-making.

Act as a power user of Assent’s platform and internal tools (e.g., JIRA, Salesforce Service Cloud, MS Office, Google Suite) to support data operations and cross-team collaboration

Be familiar with corporate security policies and follow the guidance set out by processes and procedures of Assent

Take ownership of tasks and responsibilities, with flexibility to adapt to business needs over time.

Qualifications

3+ years of experience in data analysis with advanced SQL development skills (procedural and transactional).

3+ years of experience with Microsoft SQL Server and SSIS.

Experience with data migration, conversion, and ETL processes.

Proficient in SQL and Excel, with experience writing complex queries and using advanced Excel functions such as Power Query and pivot tables.

Python is an asset.

Familiarity with data integration workflows, including APIs and ERP systems (e.g., SAP, Oracle, PTC) is considered an asset.

Strong attention to detail in monitoring data accuracy, completeness, and formatting in production environments.

Familiarity with Snowflake is an asset.

Experience with various data formats (e.g., XML, CSV) and applications (e.g., CRM systems, public databases).

Strong forward/reverse engineering and database refactoring skills.

Excellent communication skills in English, both written and verbal.

Strong interpersonal skills and ability to collaborate across teams and functions.

Additional Information

Life at Assent

Wellness: We believe that you and your family’s well being is important.

As a result, we offer vacation time that increases with tenure, comprehensive benefits packages (details vary by country), life leave days and more.

Financial Benefits: It’s not all about the money – well, it’s a little about the money.

We understand that financial health is important and we offer a competitive base salary, a corporate bonus program, retirement savings options and more.

Life at Assent: There is purpose beyond your work.

We provide our team members with flexible work options, volunteer days and opportunities to get involved in corporate giving initiatives.

Lifelong Learning: At Assent, curiosity is not only valued but encouraged.

You will receive professional development days that are available to you the day you start.

At Assent, we are committed to growing and sustaining an environment where our team members feel included, valued, and heard.

Our diversity and equal opportunity practices are guided and championed by our Diversity and Inclusion Working Group and our Employee Resource Groups (ERGs).

Our commitment to diversity, equity and inclusion includes recruiting and retaining team members from diverse backgrounds and experiences, and fostering a culture of belonging where all team members are included, treated with dignity and respect, promoted on their merits, and placed in positions to contribute to business success.

If you require assistance or accommodation throughout any part of the interview and selection process,

Required Skill Profession

Mathematical Science Occupations