๐ผFULL PORTFOLIO PROJECT TITLE: SecureHire360 โ Data Model & Security Overhaul for a UK Recruitment Firm
๐ Company: SecureHire Ltd A recruitment agency based in Manchester that connects tech professionals to contract and permanent jobs across the UK. ๐ง PROJECT BACKGROUND: SecureHire has recently migrated from spreadsheets to Salesforce. The company is growing fast, and leadership has asked YOU, their new Salesforce Admin, to build a secure, scalable data model that matches how the business actually works. Right now, everything is being dumped into the Account and Opportunity objects, and data is being viewed and edited by the wrong people. Leadershipโs biggest concern? - Recruiters are seeing salary info they shouldnโt - Sales reps are editing candidates they donโt manage - Managers want reports by industry, recruiter, and region - Finance wants visibility into payments only - Data structure is messy, reporting is unreliable, and data access is out of control ๐ง YOUR TASK (As the Admin): You are required to design and implement a proper Data Model and apply security controls to protect sensitive data and clean up the chaos. ๐DATA MODEL โ OBJECTS TO CREATE: ๐นCustom Object 1: Candidate__c Stores individual candidate information Fields to Create: - Full Name (Text) - Email (Email) - Phone (Phone) - Current Role (Text) - Expected Salary (Currency) - Availability Date (Date) - Assigned Recruiter (Lookup to User) - Region (Picklist โ North, South, Midlands, Scotland, Remote) ๐นCustom Object 2: Job_Position__c Represents open job roles from client companies Fields to Create: - Job Title (Text) - Department (Picklist) - Salary Range (Currency) - Employment Type (Picklist โ Contract, Permanent) - Hiring Manager (Lookup to Contact) - Status (Picklist โ Open, Interviewing, Closed) - Linked Account (Lookup to Account) ๐นCustom Object 3: Placement__c Represents a match between a candidate and a job Fields to Create: - Candidate (Lookup to Candidate__c) - Job Position (Lookup to Job_Position__c) - Start Date (Date) - End Date (Date) - Placement Status (Picklist โ Interviewing, Offered, Accepted, Rejected) - Recruiter (Lookup to User)