How Jobtrain supports data lakes

Modified on Wed, 13 Nov at 3:00 PM

Do you:

  • Have a data lake?
  • Want it to include data from Jobtrain? 
  • Unsure how to make this happen?

 

We can provide 3 options:

 

Jobtrain API

We have an API which is intended for integrations such as with HRIS systems and job boards, but it can also be used for data warehousing.


It provides data related to:

  • Applicant Status workflow events
  • Approval Status workflow events
  • Job Status workflow events
  • Some job data fields and Candidate data fields


Which is sufficient for tracking live progress of vacancies and candidates. It can produce periodic volumes and timescales associated with recruitment activity whether that is specific stages of the lifecycle or from raising a vacancy through to the hire of the applicant, with the ability to split this by taxonomies related to organisation structure or job types.


Good for those… 

- Not wanting to be constrained by the structure of a CSV format, or limits on data size
- Want the freedom to call what they want when they want
- Who have the technical resources to manage this by themselves, with no support from Jobtrain

Cost: Please speak to your Continuous Improvement Consultant for a price.


How to get started:

Click here for details of the API and instructions for access.


------------------------------------------------------------------------------------------------------------------------------------------------------

CSV Export/Import via the Advanced Insights Report Builder

If you have the Advanced Insights Report Builder as part of your Jobtrain package, you will know you can build your own reports encompassing:

  • Applicant Status workflow events
  • Approval Status workflow events
  • Job Status workflow events
  • Job Record fields
  • Application Form fields
  • Checklist Form fields
  • Starter Form fields
  • Approval Form fields
  • Source Data

You can also create these as CSV data exports and add them to an automated export schedule (such as every hour, day or week). The scheduled export can be sent to a designated email address, from where you can use an Outlook rule or PowerQuery to automate the extraction of the attached CSV data into your data lake.


Good for those…
- Wanting a wider choice of data fields than that offered by the API
- Can operate within a 10,000 line limit for data per CSV export
- Wanting the ability to build these exports themselves, with no support from Jobtrain

Cost: £0*
*(if you don’t have the Advanced Insights Report Builder as part of your ATS package, speak to your Continuous Improvement Consultant for a price.)

 

How to get started:

Log into your system and start building. If you need them, online training videos numbered 1-10, as well as written guides, can be found here.


-------------------------------------------------------------------------------------------------------------------------------------------------------

Jobtrain delivered solution

Our Talent Intelligence Unit can work with you to deliver a solution that utilises our 3 D’s method:

  • Define: A 1-hour meeting to understand your desired reporting outputs and define your data needs
  • Design: We will put together a specification for what data will be delivered, when and how
  • Deliver: This will then be created and activated to send you the data, with an option for any necessary tweaks to be completed within a set timeframe.

For peace of mind and ease of budgeting, this service is provided for a fixed fee.


Good for those…
- Who don’t have the resources or capabilities to manage this by themselves
- Who want our assistance and the peace of mind from our expertise of doing this successfully for many years
- Don’t expect their needs to change regularly or in the near future

Cost: £5k


How to get started:

Contact your Continuous Improvement Consultant who will arrange an electronic invoice and access to an online facility to book your 1-hour Define session.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article