# 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":3595,"title":"Frontendudvikler","company_name":"ONLINECITY.IO","description":"Frontend Webudvikler til ONLINECITY.IO CPaaS Platforms\n\n\n\n\nIntroduktion af ONLINECITY.IO\n\nONLINECITY.GROUP ApS (onlinecity.io) dækker bl.a. over platformene GatewayAPI, RelationCity og NexCon.io.\n\n\n\n\nAlle platformene har det til fælles, at de består af moderne, webbaserede brugergrænseflader, stærke og skalérbare tekniske fundamenter og har stort fokus på automatisering og selvbetjening. Vi servicerer alt fra helt små virksomheder til de allerstørste. \n\n\n\n\nVi har mange projekter undervejs og mangler kreative hænder til at gøre dem til virkelighed, derfor søger vi nu en ekstra Frontend Webudvikler. Sammen kommer I til at arbejde på tværs af vores platforme gatewayapi.com, relationcity.com og nexcon.io.\n\n\n\n\nOm jobbet og rollen\n\nSom vores nye kollega bliver du tilknyttet vores kontor i København eller i Odense. Det er vigtigt, at du er kvalitetsbevidst og er begejstret for best-practice teknologi. På tværs af vores tre platforme, vil du få ansvar for udvikling i en bred vifte af webteknologier. \n\n\n\n\nDu kommer til at samarbejde med vores UX’ere, designere, tekstforfattere, DevOps, supportere samt marketingmedarbejdere. Sammen arbejder vi for at imødekomme vores kunders ønsker og krav til top-moderne platforme.\n\n\n\n\nVi arbejder aktivt med vores processer og har opbygget et harmonisk team, hvor vi hjælpes ad og alle opgaver er et team-ansvar. Vi udvikler løbende vores arbejdsgange og giver altid plads til nye idéer.\n\n\n\n\nDine primære ansvarsområder:\n\nUdvikling af vores tre platforme\nLøbende QA af dine kollegaers arbejde\nAd-hoc problemløsning og teknisk support i særlige tilfælde\nIndgå i samarbejde med andre teams inklusiv samspil mellem marketing, backend- og frontend-udvikling\n\n\n\n\nDine kvalifikationer\n\n\n\n\nVi lægger vægt på:\n\nRelevant uddannelse som f.eks. Softwareudvikler eller Datamatiker \nKvalitetsbevidsthed gennem automatiserede tests, code reviews og dokumentation\nErfaring med frontend-udvikling, inklusiv responsive webdesign, UI-mockups i HTML, CSS\/Tailwind og komponentbaserede frameworks (Vue, React, Angular etc)\nErfaring inden for API-udvikling baseret på GraphQL og REST\nKendskab til Docker\nEn stærk forståelse af moderne teknologier, hvor følgende er en fordel at have kendskab til:\nNode.js\nWordpress \nHeadless CMS\nTypeScript\/JavaScript\nVue 3 \/ Nuxt 3\nHTML og CSS\/Tailwind\nGraphQL\n\n\n\n\nVi vil gerne se dig fremvise et eller flere private git-projekter baseret på ovenstående teknologier. Du er velkommen til at vedhæfte det i dit CV også.\n\n\n\n\nDine kompetencer:\n\nDu har minimum 2 års erhvervserfaring med webudvikling, ideelt i mange af de ovenstående teknologier\nForståelse for god softwarearkitektur\nØje for godt design og god UX\nDu er detaljeorienteret og værdsætter gode processer i dit team\nDu kan skrive og tale dansk og engelsk flydende\n\nVi lægger stor vægt på, at du er disciplineret, struktureret og åbensindet, også når det brænder på, samt at du har en naturlig lyst til at inkludere dine kollegaer i det daglige arbejde. Hos os er performance ikke et spørgsmål om hurtige leverancer, men leverancer af høj kvalitet.\n\n\n\n\nVi kan tilbyde dig: \n\nDu bliver en del af en spændende og hurtigt-voksende IT-virksomhed med et stærkt fællesskab, hvor kulturen og værdier som Simplicitet, Ambition, Inklusion og Loyalitet er omdrejningspunkt for vores forretning og selvforståelse.\n\n\n\n\nVi tilbyder derudover:\n\nLøn efter kvalifikationer\nOverenskomstreguleret ansættelsesforhold (Industriens Funktionæroverenskomst)\nFleksible arbejdstider med frihed under ansvar\nPensionsplan\nFrokostordning \nHjemmearbejde i rimeligt omfang (det øvrige team er oftest på kontoret 4 dage om ugen)\n\nOm ONLINECITY.GROUP ApS\n\nONLINECITY.GROUP ApS blev grundlagt i Odense i 1999 og har siden vokset støt. Vi tæller i dag 45 faste medarbejdere og konsulenter, fordelt på vores kontorer i Odense og København, som alle arbejder målrettet med vores platforme, der anvendes af tusindvis af kunder verden over.\n\n___________\n\nSådan ansøger du:\n\n\n\n\nSaml venligst dit CV og motiveret ansøgning i ét dokument, og søg her på siden.\n\n\n\n\nHar du spørgsmål til denne jobannonce, er du velkommen til at kontakte:\n\nHR Partner, Nadia Panzio: np@onlinecity.dk\n\n\n\n\nSamtaler vil blive afholdt løbende med sigte på opstart hurtigst muligt.","brief_summary_of_job":null,"existing_skills_from_job":["CSS","HTML","JavaScript","TypeScript","Angular","Node.js","React","GraphQL"],"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","Swift","TypeScript"],"frameworks":[".NET","Angular","Apache Spark","ASP.NET","Backbone.js","Bootstrap","CodeIgniter","Django","Ember.js","Express","FastAPI","Flask","Flutter","Hadoop","Ionic","jQuery","Laravel","Livewire","Meteor","NestJS","Next.js","Node.js","Nuxt.js","Phoenix","PHPUnit","PyTorch","React","React Native","Ruby on Rails","Spring Boot","Svelte","Symfony","Tailwind CSS","TensorFlow","Vue.js","Xamarin","Alpine.js","Filament","WordPress"],"databases":["MySQL","PostgreSQL","Redis","MongoDB","DynamoDB","MariaDB","NoSQL","Oracle","BigQuery","Elasticsearch","SQL","SQL Server","SQLite","Cassandra","CouchDB","Neo4j","InfluxDB","CockroachDB"],"tools":["Git","GitHub","GitLab","Bitbucket","Docker","Kubernetes","CI\/CD","Jenkins","Kafka","RabbitMQ","Amazon SQS","AMQP","PubSub","REST API","RESTful APIs","GraphQL","AWS","Azure","GCP","Terraform","Ansible","Puppet","Chef","Vagrant","Vault","Consul","Prometheus","Grafana","ELK Stack","Splunk"],"skills":["English","Danish","Communication","Full-stack development","Back-end development","Front-end development","Cloud computing","DevOps","Microsoft Excel","PowerBI","Power Platform","Agile","Scrum","Problem-solving","Team collaboration","Physical presence","Remote work","Hybrid work"],"colors":{"languages":"blue","frameworks":"purple","databases":"orange","tools":"indigo"}},
  "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","dynamodb":"DynamoDB","dynamo db":"DynamoDB","mariadb":"MariaDB","maria db":"MariaDB","nosql":"NoSQL","no sql":"NoSQL","bigquery":"BigQuery","big query":"BigQuery","elasticsearch":"Elasticsearch","elastic search":"Elasticsearch","cassandra":"Cassandra","couchdb":"CouchDB","couch db":"CouchDB","neo4j":"Neo4j","neo 4j":"Neo4j","influxdb":"InfluxDB","influx db":"InfluxDB","cockroachdb":"CockroachDB","cockroach db":"CockroachDB","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":"Vue.js","vue":"Vue.js","vue js":"Vue.js","vue.js":"Vue.js","vuejs":"Vue.js","VueJS":"Vue.js","xamarin":"Xamarin","Xamarin Forms":"Xamarin","Xamarin.forms":"Xamarin","livewire":"Livewire","phpunit":"PHPUnit","alpine":"Alpine.js","alpine js":"Alpine.js","alpinejs":"Alpine.js","filament":"Filament","docker":"Docker","kubernetes":"Kubernetes","k8s":"Kubernetes","github":"GitHub","gitlab":"GitLab","bitbucket":"Bitbucket","terraform":"Terraform","puppet":"Puppet","chef":"Chef","git":"Git","jenkins":"Jenkins","kafka":"Kafka","rabbitmq":"RabbitMQ","amazon sqs":"Amazon SQS","amqp":"AMQP","pubsub":"PubSub","rest api":"REST API","restful api":"RESTful APIs","restful apis":"RESTful APIs","graphql":"GraphQL","ansible":"Ansible","vagrant":"Vagrant","vault":"Vault","consul":"Consul","prometheus":"Prometheus","grafana":"Grafana","elk stack":"ELK Stack","splunk":"Splunk","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","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**: Programming languages (PHP, Python, JavaScript, Java, C#, Go, Rust, etc.)
- **Frameworks**: Web frameworks and libraries (Laravel, React, Vue.js, Angular, Django, Spring Boot, etc.)
- **Databases**: Database systems and data stores (MySQL, PostgreSQL, Redis, MongoDB, DynamoDB, etc.)
- **Tools**: Development tools and infrastructure (Git, Docker, AWS, CI/CD, Jenkins, Kafka, etc.)

## EXCLUSION RULES:
- Do NOT extract general skills (communication, languages like English, etc.)
- Do NOT extract business skills (Excel, PowerBI for non-technical roles)
- Do NOT extract work arrangements (remote, physical presence)
- Do NOT include methodologies (Agile, Scrum, etc.) unless specifically technical
- 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|databases|tools>",
      "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>"],
      "databases": ["<skill1>", "<skill2>"],
      "tools": ["<skill1>", "<skill2>"]
    },
    "duplicates_removed": ["<original_mention> → <normalized_name>"],
    "excluded_skills": ["<skill>", "<reason>"]
  },
  "confidence": <integer 0-100>
}

Return nothing outside the JSON object.

{
  "job_id": 3595,
  "extracted_skills": [
    {
      "skill_name": "HTML",
      "category": "languages",
      "confidence": 100,
      "mentioned_as": ["HTML"],
      "context": "Mentioned in the requirements for UI-mockups."
    },
    {
      "skill_name": "CSS",
      "category": "languages",
      "confidence": 100,
      "mentioned_as": ["CSS", "CSS/Tailwind"],
      "context": "Mentioned in the requirements for responsive web design."
    },
    {
      "skill_name": "JavaScript",
      "category": "languages",
      "confidence": 100,
      "mentioned_as": ["JavaScript", "Java script", "javascript", "js"],
      "context": "Mentioned in the requirements for frontend development."
    },
    {
      "skill_name": "TypeScript",
      "category": "languages",
      "confidence": 100,
      "mentioned_as": ["TypeScript", "typescript"],
      "context": "Mentioned as a technology to have knowledge of."
    },
    {
      "skill_name": "React",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["React", "react", "React.js", "react.js"],
      "context": "Mentioned in the requirements for component-based frameworks."
    },
    {
      "skill_name": "Angular",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["Angular", "angular", "AngularJS", "angularjs"],
      "context": "Mentioned in the requirements for component-based frameworks."
    },
    {
      "skill_name": "Vue.js",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["Vue", "Vue.js", "vue", "vue.js"],
      "context": "Mentioned in the requirements for component-based frameworks."
    },
    {
      "skill_name": "GraphQL",
      "category": "tools",
      "confidence": 100,
      "mentioned_as": ["GraphQL", "graphql"],
      "context": "Mentioned in the requirements for API development."
    },
    {
      "skill_name": "Docker",
      "category": "tools",
      "confidence": 100,
      "mentioned_as": ["Docker"],
      "context": "Mentioned as a technology to have knowledge of."
    },
    {
      "skill_name": "Node.js",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["Node.js", "node.js", "node"],
      "context": "Mentioned as a technology to have knowledge of."
    },
    {
      "skill_name": "Tailwind CSS",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["Tailwind", "Tailwind CSS", "CSS/Tailwind"],
      "context": "Mentioned in the requirements for responsive web design."
    },
    {
      "skill_name": "WordPress",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["Wordpress", "WordPress"],
      "context": "Mentioned as a technology to have knowledge of."
    },
    {
      "skill_name": "Nuxt.js",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["Nuxt 3", "Nuxt.js", "nuxt.js"],
      "context": "Mentioned as a technology to have knowledge of."
    }
  ],
  "reasoning": {
    "total_skills_found": 12,
    "skills_by_category": {
      "languages": ["HTML", "CSS", "JavaScript", "TypeScript"],
      "frameworks": ["React", "Angular", "Vue.js", "Node.js", "Tailwind CSS", "WordPress", "Nuxt.js"],
      "databases": [],
      "tools": ["GraphQL", "Docker"]
    },
    "duplicates_removed": [],
    "excluded_skills": []
  },
  "confidence": 100
}