# 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":3645,"title":"Tech Team Lead","company_name":"Formalize","description":"Are you looking for a big opportunity and want to invest heavily in your career while being a part of scaling a technical organisation? If so, keep on reading! We are looking for a Tech Team Lead for our growing Product team.\n\nThis is a hands-on management role, expected to be a 70\/30 split (70% hands-on, 30% management responsibility)\n\nThe Opportunity And What We Offer\n\nFormalize is on a scaling journey with significant traction across Europe. As our new Tech Team Lead, you'll have the opportunity to learn, grow, and tackle significant problems to make a meaningful impact in our Content Library team. Seize this distinctive chance to contribute to shaping Formalize's products growth narrative.\n\n\nBe part of a fast-growing international SaaS company\nHigh level of trust\nBe part of a social, diverse, and international team\n\n\nA base salary between 79.000 and 89.000 DKK.\n\nResponsibilities\n\n\nBuild maintainable, flexible software solutions grounded in core domain-driven design principles—designed to scale alongside the team\nHelp shape and drive technical roadmaps, ensuring alignment with broader business goals\nInfluence high-level design and architectural decisions that span across multiple teams and projects\nOwn projects end-to-end, navigating and solving complex problems along the way\nMaintain a strong business perspective, ensuring engineering decisions support long-term strategic objectives\nContribute to and support multiple teams through technical complexity, contributing to a unified, forward-looking roadmap\nMentor senior engineers and serve as a trusted sparring partner—raising the technical bar beyond your immediate team\nPeople management & develop for those within your direct team\nOwn and plan the technical execution and delivery of the team’s roadmap\nFoster seamless collaboration between product and engineering, driving shared ownership and momentum\n\n\nProfessional\n\nQualifications and about you:\n\n\nPrevious experience of leading & developing fellow engineers\nHave a strong grasp of fundamentals and deep knowledge within them; object-oriented programming, common design patterns, system design & testing methodologies\nTried and tested different approaches to software, and have seen the pros and cons\nBroad knowledge and knowhow of what it takes to build software that is prepared for rapid development\n\nOne or more server-side languages. We primarily use PHP (a few services written in Typescript), and know you are capable of learning a new language\n\n\nOne or more frontend frameworks, including an understand of what complex state-management means and how to handle this in growing applications. We use Angular\nGood testing practices and familiarity with one or more testing frameworks (Vitest, Pest)\n\n\nPersonal\n\n\nPride yourself on how to mentor and influence those around you\nAre curious by nature and keep up to date with modern innovations in the space\nAre able to receive and provide relevant and honest feedback\nAre the go-to person for solving complex problems\nProactively suggest changes to existing way of working, and never afraid to question fundamentals\n\n\nOur Tech-stack Includes\n\n\nAngular, including RxJS and observables\nDeclarative programming principles\nGlobal state-management through NgRx\nTailwindCSS for styling\nPostgreSQL and general relational database principles\nPHP and Laravel\nCaching mechanisms through Redis\nConsiderations for deploying to a serverless infrastructure using AWS\n\n\nAbout Formalize\n\nFormalize is a tech company founded in 2021 with offices in Aarhus, Copenhagen, Milan and Madrid. Currently we are a team of +140 people from 13 nationalities operating in multiple European markets and are one of the fastest growing SaaS scale-ups.\n\nOur journey started within the whistleblowing compliance sector, highlighted by the award-winning Whistleblower Software by Formalize, laying the foundation of our success story.\n\nThis initial chapter has been within whistleblowing compliance and meeting those regulations. Along the way we established strong partnerships and a base of satisfied customers. Our commitment was recognized through the best customer support, which earned us reputation as a customer-centric pioneer. But now, we extended our expertise to a larger compliance universe including data compliance, risk and privacy.\n\nFormalize helps companies to effortlessly navigate and stay ahead in the ever-changing landscape of compliance. Our platform adapts to regulatory changes, continuously adapting to meet, and foresee, the evolving needs of our users - ensuring businesses remain compliant and confident in their operations.\n\nTraits That Describe Our Culture And Employees\n\n\nWe are all very goal orienteered and hardworking\nWe are responsible, and we like accountability\nWe are connecting, and we like to build meaningful relationships\nWe are optimistic and like to laugh and have a positive atmosphere\nWe like to dream big and to have clear visions for the future\n\n\nTest in the recruitment process\n\nIn the recruitment process, we use talent profiles. You will therefore receive a link to the test after sending your application.\n\nExperience shows that it provides the best experience for both candidates and us as a company. It's not about answering right or wrong, but whether one's talents match the context you will work in. We want to hire a colleague who really thrives and flourishes with us, and therefore we are looking for the employee who will be a good fit with Whistleblower Software in relation to\n\n\nFit between the person and work tasks\nFit between the person and the colleagues in the team\nFit between the person and the role\n\n\nWe know that when this is staged optimally, you thrive and succeed much better in your job.\n\nRecruitment Process\n\n\nSend application and upload relevant information\nRecruiter screen 30mins (Neil)\nCompletion of personality test & HM Interview 30mins - Emil\nTechnical Interview 60mins - Emil & a member of our Tech Lead cohort\nMeet the Team 30mins - Technical interests, team fit\/coffee chat\n\n\nApply by attaching your resume and other relevant information and you will hear from us soon!\n\nWe will hold interviews and hire on an ongoing basis. For more information or questions please contact the responsible recruiter in the Talent team.","brief_summary_of_job":null,"existing_skills_from_job":["Hybridarbejde","Fuldtid","PHP","OOP","Programmering","Declarative Programming","SQL","Rekruttering","Ingeniørarbejde","Systemdesign","Designmønstre","Teamlederskab"],"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": 3645,
  "extracted_skills": [
    {
      "skill_name": "PHP",
      "category": "languages",
      "confidence": 100,
      "mentioned_as": ["PHP"],
      "context": "One or more server-side languages. We primarily use PHP."
    },
    {
      "skill_name": "TypeScript",
      "category": "languages",
      "confidence": 100,
      "mentioned_as": ["Typescript"],
      "context": "We primarily use PHP (a few services written in Typescript)."
    },
    {
      "skill_name": "Angular",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["Angular"],
      "context": "We use Angular."
    },
    {
      "skill_name": "Laravel",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["Laravel"],
      "context": "PHP and Laravel."
    },
    {
      "skill_name": "Tailwind CSS",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["TailwindCSS"],
      "context": "Our Tech-stack Includes TailwindCSS for styling."
    },
    {
      "skill_name": "PostgreSQL",
      "category": "languages",
      "confidence": 100,
      "mentioned_as": ["PostgreSQL"],
      "context": "PostgreSQL and general relational database principles."
    },
    {
      "skill_name": "Redis",
      "category": "languages",
      "confidence": 100,
      "mentioned_as": ["Redis"],
      "context": "Caching mechanisms through Redis."
    },
    {
      "skill_name": "AWS",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["AWS"],
      "context": "Considerations for deploying to a serverless infrastructure using AWS."
    }
  ],
  "reasoning": {
    "total_skills_found": 7,
    "skills_by_category": {
      "languages": ["PHP", "TypeScript", "PostgreSQL", "Redis"],
      "frameworks": ["Angular", "Laravel", "Tailwind CSS", "AWS"]
    },
    "duplicates_removed": [],
    "excluded_skills": []
  },
  "confidence": 100
}