💼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)