# 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":5577,"title":"Frontend Engineer (Vue\/Nuxt)","company_name":"Quiver","description":"Our Journey 🎯\n\nAt Quiver, we're making advanced forecasting and inventory management accessible for small and medium-sized merchants. With over 90% still relying on Excel—manual, error-prone, and lacking advanced optimization, leading to both waste of capital and over-production of unsold goods—we saw a need for change.\n\nSince early 2023, we've been on a mission to transform this process. Our easy-to-use SaaS solution automates and enhances planning, freeing our customers from tedious tasks and offering advanced capabilities. We solve complex inventory problems, that requires working with complex rule sets, and large amounts of data - but our core value is that we do so without overloading the user with information - and instead care about an intuitive and easy-to-learn platform.\n\nIn a short time we have launched our platform, gained paying customers, and secured funding - and we are currently onboarding new customers at our fastest pace ever. In combination with an ambitious expansion plan, this requires increasing our head count for multiple roles.\n\nJoin us as we innovate and redefine inventory management for merchants everywhere!\n\n\n\n\nAbout you 🧑‍💻\n\nBuilding software that can solve complicated planning processes is core to Quiver's mission. We're looking for a Front-end\/Full-stack developer passionate about web-applications and our mission to build the next generation of inventory management software. We also expect interest and knowledge about good UX\/UI, but we are looking for an engineer, not a designer.\n\nYou will be employee #7, joining a team of experienced tech and supply chain nerds. We enjoy working together in-person, and while we are fully flexible in terms of work-from-home days when needed, we meet in our Office in Copenhagen 90% of the days and expect a similar presence from you.\n\n\n\n\nYour main responsibilities\n\nDevelopment of our Vue3\/Nuxt3 frontend\n\nSoftware development in other parts of the stack (if your skills\/interests match up)\n\nArchitectural decisions in close collaboration with our CTO. We are refactoring the current version (piece-by-piece), so you can influence the direction going forward.\n\nCo-creating and prioritising the engineering roadmap\n\nCoaching and teaching future tech-employees\n\nBe part of building our team and culture in person with us in our office in Copenhagen\n\n\n\n\nQualifications\n\nExperience in software development - maybe full-time, maybe from building stuff besides your studies\n\nMaster's degree in Software Engineering\/Computer science (or a matching skill set from other experience)\n\nExperience with modern web development (Vue, React, Angular, Svelte etc..) and Typescript as well as SQL - we'll be using Vue3\/Nuxt, so some experience with that is a plus\n\nExperience with one or more of the following is an advantage, but in no way a requirement: Python, Kubernetes, ETL, Data warehousing, Machine Learning, Time Series Forecasting, Tailwind, Celery, GraphQL\n\n\n\n\nOur stack 💻\n\nBackend: Python, Celery, Postgres, Cube.js, Directus\n\nFrontend: Vue, Nuxt, Typescript, Tailwind\n\nInfra: Kubernetes, Helm, Google Cloud\n\nData Integration: Airbyte, Prefect, Dbt\n\n\n\n\nWhat we offer 🎁\n\nCompetitive salary (€5-6k \/ 37-46tDKK)\n\nProfessional learning and development benefit\n\nPossibly Equity (0-0,5%)\n\n1 company off-site per year\n\nLunch, coffee, Friday bars, social events and much more!\n\n\n\n\nWhy us 🚀\n\nYou will join an experienced team, founders have +10 years post masters-degree experience within their respective fields\n\nYou will have the opportunity to be part of building Quiver as a business and team from the ground up\n\nYou will work day-to-day directly with our co-founders and of course the software team that consists of 1x FE engineer, 1x BE engineer, 1x Data Engineer and a CTO.\n\nYou will get a high level of autonomy over yourself and your work\n\nYou will join a start-up that has strong traction from customers and investors alike\n\n\n\n\nInterview process 👥\n\nScreening (15 mins [Phone-call])\n\nIntroduction interview (60 mins [On-site])\n\nTech interview (1-2 hrs [On-site])\n\nContract & Hiring\n\n\n\n\nIf the above has sparked your interest, please do not hesitate to reach out!","brief_summary_of_job":null,"existing_skills_from_job":["Python","TypeScript","Angular","Next","Nuxt","React","Svelte","Vue","Kubernetes","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","Bootstrap","CodeIgniter","Django","Ember","Express","FastAPI","Flask","Flutter","Hadoop","Ionic","jQuery","Laravel","Livewire","Meteor","NestJS","Next","Node","Nuxt","Phoenix","PHPUnit","PyTorch","React","React Native","Ruby on Rails","Spring Boot","Svelte","Symfony","Tailwind CSS","TensorFlow","Vue","Xamarin","Alpine","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","BackboneJS":"Backbone","backbone js":"Backbone","backbonejs":"Backbone","backbone.js":"Backbone","bootstrap":"Bootstrap","Bootstrap framework":"Bootstrap","twitter bootstrap":"Bootstrap","Twitter Bootstrap":"Bootstrap","code igniter":"CodeIgniter","codeigniter":"CodeIgniter","django":"Django","ember":"Ember","ember js":"Ember","emberjs":"Ember","EmberJS":"Ember","ember.js":"Ember","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","meteor.js":"Meteor","nestjs":"NestJS","nest js":"NestJS","Nest JS":"NestJS","Nestjs":"NestJS","next js":"Next","Next js":"Next","next.js":"Next","nextjs":"Next","NextJS":"Next","node":"Node","Node":"Node","node.js":"Node.js","nodejs":"Node","NodeJS":"Node","nuxt js":"Nuxt","Nuxt js":"Nuxt","nuxt.js":"Nuxt","nuxtjs":"Nuxt","NuxtJS":"Nuxt","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","vue js":"Vue","vue.js":"Vue","vuejs":"Vue","VueJS":"Vue","xamarin":"Xamarin","Xamarin Forms":"Xamarin","Xamarin.forms":"Xamarin","livewire":"Livewire","phpunit":"PHPUnit","alpine js":"Alpine","Alpine.js":"Alpine","alpinejs":"Alpine","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","Vue":"Vue","Vue.js":"Vue","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": 5577,
  "extracted_skills": [
    {
      "skill_name": "Python",
      "category": "languages",
      "confidence": 100,
      "mentioned_as": ["Python"],
      "context": "Experience with one or more of the following is an advantage, but in no way a requirement: Python, Kubernetes, ETL, Data warehousing, Machine Learning, Time Series Forecasting, Tailwind, Celery, GraphQL"
    },
    {
      "skill_name": "TypeScript",
      "category": "languages",
      "confidence": 100,
      "mentioned_as": ["Typescript", "TypeScript"],
      "context": "Experience with modern web development (Vue, React, Angular, Svelte etc..) and Typescript as well as SQL"
    },
    {
      "skill_name": "Vue",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["Vue", "Vue3"],
      "context": "Development of our Vue3/Nuxt3 frontend"
    },
    {
      "skill_name": "Nuxt",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["Nuxt", "Nuxt3"],
      "context": "Development of our Vue3/Nuxt3 frontend"
    },
    {
      "skill_name": "Kubernetes",
      "category": "tools",
      "confidence": 100,
      "mentioned_as": ["Kubernetes"],
      "context": "Experience with one or more of the following is an advantage, but in no way a requirement: Python, Kubernetes, ETL, Data warehousing, Machine Learning, Time Series Forecasting, Tailwind, Celery, GraphQL"
    },
    {
      "skill_name": "GraphQL",
      "category": "tools",
      "confidence": 100,
      "mentioned_as": ["GraphQL"],
      "context": "Experience with one or more of the following is an advantage, but in no way a requirement: Python, Kubernetes, ETL, Data warehousing, Machine Learning, Time Series Forecasting, Tailwind, Celery, GraphQL"
    },
    {
      "skill_name": "Tailwind CSS",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["Tailwind"],
      "context": "Experience with one or more of the following is an advantage, but in no way a requirement: Python, Kubernetes, ETL, Data warehousing, Machine Learning, Time Series Forecasting, Tailwind, Celery, GraphQL"
    }
  ],
  "reasoning": {
    "total_skills_found": 6,
    "skills_by_category": {
      "languages": ["Python", "TypeScript"],
      "frameworks": ["Vue", "Nuxt", "Tailwind CSS"],
      "databases": [],
      "tools": ["Kubernetes", "GraphQL"]
    },
    "duplicates_removed": [],
    "excluded_skills": []
  },
  "confidence": 100
}