# 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":4063,"title":"Internship - Software Developer (CPH)","company_name":"Systematic","description":"About the job\n\nInternship – Software Developer (CPH)\nAre you passionate about coding and solving complex problems — and aspiring to develop software solutions that truly make a difference? At Systematic, we offer an exciting and well-established internship where your skills are valued, your ideas are heard, and your professional development is a priority. \n\nExpected start:\n Feb 2026 \nYour role as a Software Developer Intern \nAs a Software Developer Intern at Systematic, you will contribute to meaningful projects — whether developing scalable web solutions, building standalone applications, or enhancing existing systems. You will gain hands-on experience with tools and technologies such as Java, Angular JavaScript, HTML5, CSS3, SQL Server, .NET, WCF, WPF, and more, depending on your team and business area.\n\nYour daily tasks may include:\n\n\nParticipating in Scrum meetings and contributing to sprint planning and reviews \nAssisting with the development of prototypes and innovative solutions \nCollaborating with developers, testers, architects, and other team members \nImproving existing software and development processes \nDocumenting software components and creating technical notes \nSupporting customer-facing solutions and troubleshooting issues \n\n\n\nOur projects at Systematic \nSystematic develops software solutions within three main business areas:\n Defence, Healthcare, and Digital Transformation. In Systematic Copenhagen, you will become part of our Defence business, focusing on developing a suite of products called SitaWare.\n\nLife as an intern \nAt Systematic, interns are considered an integral part of the team. You will be assigned a dedicated tutor or mentor who will guide you through your tasks and provide ongoing support to foster your professional development. You will collaborate closely with colleagues who are eager to share their expertise, while being trusted with responsibility early in your internship. This balance allows you the freedom to learn, explore new approaches, and build confidence in your abilities.\n\nWe are committed to delivering high-quality solutions, while also prioritising a positive work environment – whether through shared laughter, a strong cup of coffee, or meaningful connections with colleagues. In addition to your team, you will join our intern network, where you can build relationships, share experiences, and participate in social events with other interns across the organisation.\n\nWho We Are Looking For\nWe envisage that you are currently studying for a BSc or MSc in Software Technology, Software Development, Computer Science, or a related field — and that you are eager to apply your skills in practice.\n\nYou are likely to thrive in this role if you:\n\n\nWork systematically, write clean code, and maintain a strong focus on quality and detail \nEnjoy coding and take pride in using software to solve real-world problems and make a difference \nAre curious and willing to learn new tools, frameworks, and methods \nTake initiative and are not afraid to suggest improvements or share new ideas \nCommunicate clearly in English, both written and spoken (Danish is an advantage but not a requirement) \nThrive in a collaborative environment, but can also work independently when required \n\n\n\nThe internship is a full-time position lasting five months, commencing on 2 February 2026. It is a paid position if your study programme allows so.\n\nPlease note that you must be able to present a clean criminal record and have resided in a NATO and\/or EU country for the past seven years, as we work with security-classified projects. Read more here. \n\nWelcome to Systematic Copenhagen \nWhen you join us in Copenhagen, you're not just getting a desk at one of the city’s best locations—you’re stepping into a workplace where community matters. Our Employees Club keeps things lively with monthly social events, and our office catering makes sure you’re always well taken care of. Whether you’re into casual games or just good company, you’ll find both at our foosball table or during our relaxed Friday bar gatherings.\n\nNever stop developing \nSystematic is uniquely people-centric, truly international, and proudly rooted in Denmark, with more than 1,100 employees. Together, we write intelligent and innovative code to drive progress and improve lives. We develop IT solutions that make a real difference where it matters most. This is why we never stop developing. Here, there is room to be both professional and personal. It is not just a place to work – it is a place to belong.\n\nStart your development here \nWe will be assessing applications on an ongoing basis as we wish to find our new intern as soon as possible, so click Apply Now and send us your CV, Cover Letter and exam certificates. If you have any questions, you are welcome to contact us on tel. +45 8943 2000 and ask for Camilla Albring, Junior Consultant, People Attraction.\n\nGet in touch\n\nCamilla Albring\n\nJunior Consultant, People Attraction","brief_summary_of_job":null,"existing_skills_from_job":["JavaScript","SQL","Angular","SQL Server"],"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": 4063,
  "extracted_skills": [
    {
      "skill_name": "Java",
      "category": "languages",
      "confidence": 100,
      "mentioned_as": ["Java"],
      "context": "Gaining hands-on experience with tools and technologies such as Java."
    },
    {
      "skill_name": "JavaScript",
      "category": "languages",
      "confidence": 100,
      "mentioned_as": ["JavaScript", "Angular JavaScript"],
      "context": "Gaining hands-on experience with tools and technologies such as Angular JavaScript."
    },
    {
      "skill_name": "HTML",
      "category": "languages",
      "confidence": 100,
      "mentioned_as": ["HTML5"],
      "context": "Gaining hands-on experience with tools and technologies such as HTML5."
    },
    {
      "skill_name": "CSS",
      "category": "languages",
      "confidence": 100,
      "mentioned_as": ["CSS3"],
      "context": "Gaining hands-on experience with tools and technologies such as CSS3."
    },
    {
      "skill_name": "SQL Server",
      "category": "databases",
      "confidence": 100,
      "mentioned_as": ["SQL Server"],
      "context": "Gaining hands-on experience with tools and technologies such as SQL Server."
    },
    {
      "skill_name": ".NET",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": [".NET"],
      "context": "Gaining hands-on experience with tools and technologies such as .NET."
    },
    {
      "skill_name": "WCF",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["WCF"],
      "context": "Gaining hands-on experience with tools and technologies such as WCF."
    },
    {
      "skill_name": "WPF",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["WPF"],
      "context": "Gaining hands-on experience with tools and technologies such as WPF."
    },
    {
      "skill_name": "Angular",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["Angular"],
      "context": "Gaining hands-on experience with tools and technologies such as Angular."
    }
  ],
  "reasoning": {
    "total_skills_found": 8,
    "skills_by_category": {
      "languages": ["Java", "JavaScript", "HTML", "CSS"],
      "frameworks": [".NET", "WCF", "WPF", "Angular"],
      "databases": ["SQL Server"],
      "tools": []
    },
    "duplicates_removed": [],
    "excluded_skills": []
  },
  "confidence": 100
}