# Job Skill Enhancement System

## CORE INSTRUCTION:
You are an AI that extracts and identifies coding languages and frameworks from job descriptions. Your goal is to find ALL relevant technical skills mentioned in the job posting, even if they're mentioned in different ways or aliases.

## INPUT DATA:
{
  "job": {"job_id":3724,"title":"Teknisk konsulent","company_name":"DoWEB ApS","description":"Rollen som Konsulent hos DoWEB\n\nDoWEB er en lille virksomhed, og derfor vil du opleve at skulle udfylde flere roller.\n\nUdvikler – du bygger integrationer, moduler og funktionalitet i vores kunders CRM-, ERP- og BI-systemer.\nRådgiver – du hjælper kunder med at forstå deres egne processer og omsætter deres behov til tekniske løsninger, der skaber værdi.\n\nDu vil opleve stor variation i opgaverne: fra kundeprojekter til intern produktudvikling, hvor vi udvikler og tester nye standardløsninger og abonnementsservices. Ingen dage er ens, og du vil hurtigt få ansvar og indflydelse.\n\nDine opgaver\nUdvikling af integrationer mellem CRM-, ERP- og BI-systemer.\nUdvikling af brugerflader, moduler og forretningslogik i CRM-platforme (primært SuperOffice, men også Salesforce, Microsoft og Pipedrive).\nOpsætning, support og tilpasning af CRM\/BI-løsninger hos kunder.\nKonsulentarbejde med fokus på at optimere kundernes arbejdsgange.\nBidrage til udvikling af DoWEB’s egne SaaS-produkter og abonnementsservices.\nDokumentation, videndeling og tæt samarbejde med kunder.\nDine opgaver\n\nVi ser gerne, at du har:\n\n1+ års erfaring med JavaScript\/TypeScript frameworks (Vi arbejder primært med React).\nErfaring med Node.js (Express), gerne suppleret med PHP.\nStærke kompetencer i HTML5, CSS og SQL.\nForståelse for dataintegrationer og API-udvikling.\nGode problemløsningsevner og sans for detaljen.\nGode AI prompting skills\nFlydende Dansk og Engelsk i skrift og tale.\n\nDet er en fordel, hvis du har erfaring med:\n\nCRM-systemer (SuperOffice, Salesforce, Microsoft, HubSpot, Pipedrive).\nERP-systemer (Business Central, Navision, Axapta eller lignende).\nMicrosoft Power Platform (Power BI, Power Automate, Power Apps).\nWordpress\nHvem er du?\nDu har erfaring som konsulent og trives med kundekontakt.\nRelevant it uddannelse, for eksempel datamatiker eller lignende\nDu er løsningsorienteret og kan hurtigt oversætte forretningsbehov til tekniske løsninger.\nDu er selvdrevet og kan tage ansvar for dine opgaver uden at blive “micro-managed”.\nDu er nysgerrig, lærevillig og motiveres af at skabe værdi for både kunder og DoWEB.\nPraktisk...\n\nSted: Kontoret ligger i Pakhuset Kolding, som er et kontorfællesskab for ambitiøse startup virksomheder som os selv, med placering lige ud til Kolding havn. Det forventes at ansøger har kørekort og egen bil.\n\nUdstyr: En 16” MacBook Pro M1 Max computer, samt en 49” ultra-wide LG skærm står klar til dig på kontoret\n\nArbejdstid: Fuldtid\n\nLøn: Efter kvalifikationer, Der stilles i øvrigt arbejdsgiverbetalt internet og mobilabonnement til rådighed.\n\nTiltrædelse: Hurtigst muligt","brief_summary_of_job":null,"existing_skills_from_job":["Hybridarbejde","Fuldtid","CSS","HTML","JavaScript","OOP","Engelsk","Java","XML","ERP","Erhverv","Sted"],"existing_skills_from_database":[]},
  "coding_categories": {"languages":["Bash","C","C#","C++","CSS","Clojure","Dart","Elixir","Go","Groovy","Haskell","HTML","Java","JavaScript","Julia","Kotlin","Lua","MATLAB","Objective-C","Perl","PHP","PowerShell","Python","R","Ruby","Rust","Sass","Scala","SQL","Swift","TypeScript"],"frameworks":[".NET","Angular","Apache Spark","ASP.NET","AWS","Azure","Backbone.js","Bootstrap","CodeIgniter","Django","Docker","Ember.js","Express","FastAPI","Flask","Flutter","GCP","Hadoop","Ionic","jQuery","Kubernetes","Laravel","Meteor","NestJS","Next.js","Node.js","Nuxt.js","Phoenix","PyTorch","React","React Native","Ruby on Rails","Spring Boot","Svelte","Symfony","Tailwind CSS","TensorFlow","Vue.js","Xamarin"]},
  "skill_aliases": {"bash":"Bash","c":"C","c plus plus":"C++","C plus plus":"C++","c sharp":"C#","C sharp":"C#","c#":"C#","c++":"C++","clojure":"Clojure","cpp":"C++","dart":"Dart","elixir":"Elixir","go":"Go","golang":"Go","Golang":"Go","groovy":"Groovy","haskell":"Haskell","java":"Java","java script":"JavaScript","Java script":"JavaScript","javascript":"JavaScript","Javascript":"JavaScript","js":"JavaScript","JS":"JavaScript","es5":"JavaScript","ES5":"JavaScript","es6":"JavaScript","ES6":"JavaScript","julia":"Julia","kotlin":"Kotlin","lua":"Lua","matlab":"MATLAB","Matlab":"MATLAB","objective c":"Objective-C","Objective C":"Objective-C","objective-c":"Objective-C","objc":"Objective-C","ObjC":"Objective-C","obj-c":"Objective-C","Obj-C":"Objective-C","perl":"Perl","php":"PHP","Php":"PHP","powershell":"PowerShell","Power Shell":"PowerShell","python":"Python","py":"Python","Py":"Python","phyton":"Python","r":"R","ruby":"Ruby","rust":"Rust","scala":"Scala","swift":"Swift","typescript":"TypeScript","Typescript":"TypeScript","ts":"TypeScript","TS":"TypeScript","mysql":"MySQL","postgresql":"PostgreSQL","postgres":"PostgreSQL","mongodb":"MongoDB","mongo":"MongoDB","redis":"Redis","sqlite":"SQLite","oracle":"Oracle","mssql":"SQL Server","sql server":"SQL Server","aws":"AWS","amazon web services":"AWS","azure":"Azure","microsoft azure":"Azure","gcp":"GCP","google cloud platform":"GCP","google cloud":"GCP",".Net":".NET","angular":"Angular","angular js":"Angular","Angular js":"Angular","angularjs":"Angular","AngularJS":"Angular","apache spark":"Apache Spark","asp net":".NET","ASP net":".NET","asp.net":"ASP.NET","ASP.NET":".NET","asp.net core":".NET","ASP.NET Core":".NET","backbone":"Backbone.js","BackboneJS":"Backbone.js","backbone js":"Backbone.js","backbonejs":"Backbone.js","bootstrap":"Bootstrap","Bootstrap framework":"Bootstrap","twitter bootstrap":"Bootstrap","Twitter Bootstrap":"Bootstrap","code igniter":"CodeIgniter","codeigniter":"CodeIgniter","django":"Django","ember":"Ember.js","ember js":"Ember.js","emberjs":"Ember.js","EmberJS":"Ember.js","express":"Express","express.js":"Express","Express.js":"Express","expressjs":"Express","ExpressJS":"Express","fast api":"FastAPI","Fast api":"FastAPI","fastapi":"FastAPI","flask":"Flask","flutter":"Flutter","hadoop":"Hadoop","Hadoop":"Hadoop","ionic":"Ionic","Ionic framework":"Ionic","ionic framework":"Ionic","jquery":"jQuery","JQuery":"jQuery","JQUERY":"jQuery","laravel":"Laravel","meteor":"Meteor","meteor js":"Meteor","meteorjs":"Meteor","MeteorJS":"Meteor","nestjs":"NestJS","nest js":"NestJS","Nest JS":"NestJS","Nestjs":"NestJS","next js":"Next.js","Next js":"Next.js","next.js":"Next.js","nextjs":"Next.js","NextJS":"Next.js","node":"Node.js","Node":"Node.js","node.js":"Node.js","nodejs":"Node.js","NodeJS":"Node.js","nuxt js":"Nuxt.js","Nuxt js":"Nuxt.js","nuxt.js":"Nuxt.js","nuxtjs":"Nuxt.js","NuxtJS":"Nuxt.js","phoenix":"Phoenix","Phoenix framework":"Phoenix","pytorch":"PyTorch","Pytorch":"PyTorch","torch":"PyTorch","Torch":"PyTorch","react":"React","react.js":"React","React.js":"React","reactjs":"React","ReactJS":"React","react native":"React Native","ReactNative":"React Native","reactnative":"React Native","rn":"React Native","RN":"React Native","rails":"Ruby on Rails","Rails":"Ruby on Rails","ror":"Ruby on Rails","ROR":"Ruby on Rails","ruby on rails":"Ruby on Rails","Ruby On Rails":"Ruby on Rails","spark":"Apache Spark","Spark":"Apache Spark","spring":"Spring Boot","Spring":"Spring Boot","spring boot":"Spring Boot","Spring Boot":"Spring Boot","spring framework":"Spring Boot","Spring Framework":"Spring Boot","SpringBoot":"Spring Boot","springboot":"Spring Boot","svelte":"Svelte","symfony":"Symfony","tailwind":"Tailwind CSS","Tailwind":"Tailwind CSS","tailwind css":"Tailwind CSS","Tailwind Css":"Tailwind CSS","tailwindcss":"Tailwind CSS","TailwindCSS":"Tailwind CSS","tensorflow":"TensorFlow","Tensorflow":"TensorFlow","tensor flow":"TensorFlow","vue js":"Vue.js","vue.js":"Vue.js","vuejs":"Vue.js","VueJS":"Vue.js","xamarin":"Xamarin","Xamarin Forms":"Xamarin","Xamarin.forms":"Xamarin","docker":"Docker","kubernetes":"Kubernetes","k8s":"Kubernetes","github":"GitHub","gitlab":"GitLab","bitbucket":"Bitbucket","terraform":"Terraform","puppet":"Puppet","chef":"Chef","scrum":"Scrum","agile":"Agile","kanban":"Kanban","devops":"DevOps","ci\/cd":"CI\/CD","tdd":"TDD","bdd":"BDD","linux":"Linux","windows":"Windows","macos":"macOS","ubuntu":"Ubuntu","centos":"CentOS","debian":"Debian","junit":"JUnit","pytest":"PyTest","jest":"Jest","mocha":"Mocha","cypress":"Cypress","selenium":"Selenium","html":"HTML","HTML":"HTML","html5":"HTML","HTML5":"HTML","css":"CSS","CSS":"CSS","css3":"CSS","CSS3":"CSS","sass":"Sass","scss":"Sass","SCSS":"Sass","less":"Less","LESS":"Less","webpack":"Webpack","gulp":"Gulp","npm":"npm","yarn":"Yarn","sql":"SQL","vue":"Vue.js","full time":"Fuldtid","full-time":"Fuldtid","fuldtid":"Fuldtid","part time":"Deltid","part-time":"Deltid","deltid":"Deltid","contract":"Kontrakt","kontrakt":"Kontrakt","remote":"Fjernarbejde","fjernarbejde":"Fjernarbejde","hybrid":"Hybridarbejde","hybridarbejde":"Hybridarbejde","on-site":"Fysisk tilstedeværelse","onsite":"Fysisk tilstedeværelse","fysisk tilstedeværelse":"Fysisk tilstedeværelse"}
}

## TASK:
1. **Extract ALL coding languages and frameworks** mentioned in the job description
2. **Use the skill_aliases mapping** to normalize skill names (e.g., "JS" → "JavaScript", "React.js" → "React")
3. **Only include skills from the coding_categories** (languages and frameworks)
4. **Avoid duplicates** - if "JavaScript" and "JS" are both mentioned, only include "JavaScript"
5. **Be thorough** - look for skills mentioned in:
   - Job title
   - Job description
   - Brief summary
   - Requirements sections
   - Nice-to-have sections

## SKILL CATEGORIES TO EXTRACT:
- **Languages**: JavaScript, Python, Java, C#, PHP, Go, Rust, etc.
- **Frameworks**: React, Angular, Vue.js, Laravel, Django, Spring Boot, etc.

## EXCLUSION RULES:
- Do NOT include soft skills (communication, teamwork, etc.)
- Do NOT include methodologies (Agile, Scrum, etc.)
- Do NOT include general tools (Git, VS Code, etc.) unless they're specifically coding-related
- Do NOT include skills already in existing_skills_from_database

## OUTPUT FORMAT:
Return ONLY valid JSON in this exact structure:
{
  "job_id": <integer>,
  "extracted_skills": [
    {
      "skill_name": "<normalized_skill_name>",
      "category": "<languages|frameworks>",
      "confidence": <integer 0-100>,
      "mentioned_as": ["<original_mention_1>", "<original_mention_2>"],
      "context": "<brief_context_where_found>"
    }
  ],
  "reasoning": {
    "total_skills_found": <integer>,
    "skills_by_category": {
      "languages": ["<skill1>", "<skill2>"],
      "frameworks": ["<skill1>", "<skill2>"]
    },
    "duplicates_removed": ["<original_mention> → <normalized_name>"],
    "excluded_skills": ["<skill>", "<reason>"]
  },
  "confidence": <integer 0-100>
}

Return nothing outside the JSON object.

{
  "job_id": 3724,
  "extracted_skills": [
    {
      "skill_name": "JavaScript",
      "category": "languages",
      "confidence": 100,
      "mentioned_as": ["JavaScript", "javascript", "JS"],
      "context": "1+ års erfaring med JavaScript/TypeScript frameworks (Vi arbejder primært med React)."
    },
    {
      "skill_name": "TypeScript",
      "category": "languages",
      "confidence": 100,
      "mentioned_as": ["TypeScript", "typescript", "ts"],
      "context": "1+ års erfaring med JavaScript/TypeScript frameworks (Vi arbejder primært med React)."
    },
    {
      "skill_name": "Node.js",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["Node.js", "node.js", "node"],
      "context": "Erfaring med Node.js (Express), gerne suppleret med PHP."
    },
    {
      "skill_name": "Express",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["Express", "express", "Express.js"],
      "context": "Erfaring med Node.js (Express), gerne suppleret med PHP."
    },
    {
      "skill_name": "HTML",
      "category": "languages",
      "confidence": 100,
      "mentioned_as": ["HTML", "html", "HTML5"],
      "context": "Stærke kompetencer i HTML5, CSS og SQL."
    },
    {
      "skill_name": "CSS",
      "category": "languages",
      "confidence": 100,
      "mentioned_as": ["CSS", "css", "CSS3"],
      "context": "Stærke kompetencer i HTML5, CSS og SQL."
    },
    {
      "skill_name": "SQL",
      "category": "languages",
      "confidence": 100,
      "mentioned_as": ["SQL", "sql"],
      "context": "Stærke kompetencer i HTML5, CSS og SQL."
    },
    {
      "skill_name": "React",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["React", "react", "React.js"],
      "context": "Vi arbejder primært med React."
    }
  ],
  "reasoning": {
    "total_skills_found": 7,
    "skills_by_category": {
      "languages": ["JavaScript", "TypeScript", "HTML", "CSS", "SQL"],
      "frameworks": ["Node.js", "Express", "React"]
    },
    "duplicates_removed": [],
    "excluded_skills": []
  },
  "confidence": 100
}