How Jobtrain supports data lakes
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 Account Manager 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, please speak to your Account Manager 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 Account Manager who will arrange an electronic invoice and access to an online facility to book your 1-hour Define session.