Data Analyst Apprentice Regis Group Plc
Pier Management are recruiting for an IT Data & Technology Apprentice to join our PropTech Development Team. This role is aimed at someone embarking on a career in the IT profession; focusing on data handling, system process development and documentation of business operating procedures.
Closing date: 06 Oct 2021
To be agreed upon appointment
Total hours per week: 37.50
Possible start date
11 Oct 2021
02 Jul 2021
Level 4 (Higher national Certificate)
Reporting to the Business System Administrator, the successful candidate will be taking on various projects relating to data extraction, cleansing, manipulation and loading, application development, and documenting business critical procedures. This role requires a strong attention to detail and a passion for technology. Reporting to the Business System Administrator, the successful candidate will be taking on various projects relating to data extraction, cleansing, manipulation and loading, application development, and documenting business critical procedures. This role requires a strong attention to detail and a passion for technology.
The following is a brief breakdown of the roles and skills that this new apprentice will be undertaking:
SQL and Database Administration – The new apprentice will learn our SQL database structure as well as the SQL coding language and the flow of data through various technologies within the SQL management studio.
Qube PM data processing - The successful candidate would be trained on our property management software – Qube. Additionally, this task requires the extraction, cleansing and reuploading of the data used across the business, with attention to standardised practices and data consistency.
Business Information Reporting: Excel, SQL, VBA and PowerBi – This candidate will be regularly interacting with Excel and will be taught the basics of VBA & macros. Linking data through SQL and pulling data from other sources for the purposes of transformation and analysis. Data transformations will be used for further analysis and visualisation in Excel and PowerBi.
Standard Operation Procedures – This focuses on the successful candidate collecting and maintaining a portfolio of documents relating to the Standard Operation Procedures (SOPs) of the PropTech department. This would include liaising with colleagues to understand the systems and processes in place and creating a repository of documents that accurately details the user’s end-to-end process, trouble shooting and recovery.
Personal Project – Development of an in-house ticketing system -The successful candidate will be given responsibility for the development and deployment of a ticketing system for the PropTech department and the wider business. This project is for logging and tracking requests that come in and giving the user confirmation request was received. This will give the candidate an opportunity to develop skills relating to project requirement collection, project management and real-world software and technology development.
Requirements and prospects
- A genuine interest in computing, business systems and data analytics
- Knowledge of the MSOffice suite
- Basic awareness of SQL, relational databases, PowerBi and VBA is a plus
- Basic understanding of coding concepts and logic
- Strong written and verbal skills
- Keen attention to details
- Good problem-solving skills
- Good documentation skills
- Strong attention to detail
- Ability to listen and clarify where necessary
- A good work ethic
- 5 GCSEs at a 4/C or above including English and maths
- Level 3 BTEC in a STEM Subject
- HNC in Computing
There will be a possibility of gaining permanent employment after completing the apprenticeship programme.
About the employer
Regis has demonstrated a track record of success over a 40-year period, by identifying non-traditional real estate asset classes with the potential to scale and then build national, institutionally managed companies to capitalise on these opportunities.
Regis has partnered repeatedly with some of the largest real estate investors, insurance companies and pension funds in the world and has developed an admirable reputation as trusted stewards of institutional capital.
Our platform creation strategy combines extensive operational expertise and experience, with deep knowledge of financial structuring.
Visionary thematic investment strategies have generated exceptional value for Regis and it’s partners over time and has led to the creation of some of the largest companies in their respective sectors.
The stabilised business platforms developed by Regis have led to numerous public and privately rated ABS issuances, each being the very first of their kind, effectively pioneering brand-new institutional asset classes in each instance, paving the way for whole industries to follow suit.
ITEC LEARNING TECHNOLOGIES LIMITED
Applications for this apprenticeship are being processed by ITEC Learning Technologies
Ellie Hendy 01268 286 929 firstname.lastname@example.org
- Data Analyst Level 4 Apprenticeship
Level 4 (Higher national Certificate)
Before you apply
Before you apply for an apprenticeship you must first create an account. If you already have an account you'll need to sign in.