# 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":4913,"title":"Backend Developer — Full time — Own the Core of AI-Powered B2B Marketing","company_name":"BirdsAtFive","description":"About the job\n\nLocation: Copenhagen (Hybrid)\n\nType: Full-time\n\nAbout BirdsAtFive & Birdie\n\nAt BirdsAtFive, we’re building Birdie – a platform that finally fixes the biggest reason most AI tools fail in B2B marketing: bad input.\n\nAI can write fast, but if it doesn’t know your brand, your market, your goals, or your customers — it just makes things up. That’s a huge risk for marketing teams trying to move fast and stay on-message.\n\nBirdie changes that.\n\nWe structure all of a company’s GTM knowledge — from strategy decks and sales insights to product positioning and audience research — and use it to power AI tools that create content that’s on-strategy, on-brand, and actually useful.\n\nWe’re not building generic chatbots. We’re building the execution engine modern B2B teams need to go from idea to campaign — with AI that doesn’t guess, but understands.\n\nThe Role: Backend Developer (Python\/FastAPI)\n\nWe're looking for someone to own our backend systems.\n\nThis isn’t a “keep the lights on” role. This is your system to build. You’ll be responsible for scaling and maintaining the infrastructure behind a product already used by leading B2B brands — and as we grow, the rest of the team will rely on your technical direction and execution.\n\nRight now, our CTO handles both backend and AI development. Your role will be to take over the backend and infrastructure, so that our CTO can focus entirely on the AI side of the platform. You’ll work closely together to ensure a smooth handover and continued collaboration — but ownership will be yours.\n\nWe’re looking for someone proactive — not just a great developer, but someone who sees what’s missing, proposes improvements, and gets excited about taking responsibility for a critical part of the product.\n\nWhat You'll Be Solving\n\n\nHow do we turn messy, unstructured marketing knowledge into structured data AI can use?\nHow do we scale AI-powered execution across hundreds of projects and teams — reliably?\nHow do we make backend decisions today that won't slow us down tomorrow?\n\n\nThese are real product challenges. They require technical creativity, smart architectural thinking, and the confidence to lead.\n\nYour Responsibilities\n\n\nBuild and maintain backend services in Python using FastAPI\nDesign and improve the architecture that powers our structured data and AI workflows\nSet up and manage backend systems and development environments using Docker, Terraform, and modern tooling\nDesign and optimize databases to support fast queries, clean structure, and flexibility as we grow\nWork closely with our CTO to understand current backend and gradually take full ownership\nCollaborate with AI engineers, product designers, and other developers to ensure smooth integration\nMake technical decisions, set standards, and lead backend direction as we scale\n\n\nYou Might Be a Fit If You…\n\n\nHave designed and built backend systems from scratch before — and loved the ownership\nHave experience working on early-stage products, ideally in a startup or small team setting\nUnderstand database design and care about maintainable architecture\nWork proactively — you don’t wait to be told what to do, you drive your own roadmap\nCommunicate clearly and are comfortable making decisions\nAre curious about AI and how it can be built into real-world tools\n\n\nCore Technical Requriements (1 - 5 Years Experience With)\n\n\nPython: Solid, professional experience building backend systems in Python.\nFastAPI & Ecosystem: You know your way around FastAPI and have hands-on experience with its ecosystem, including SQLAlchemy and Pydantic.\nArchitectural Experience: You have proven experience with the architectural development of a larger project, ideally from scratch, and you loved the ownership.\nSQL: Strong skills in SQL and relational database design, with a focus on creating maintainable and performant systems.\nIaC (Infrastructure as Code): You have hands-on experience using tools like Terraform to manage and provision infrastructure.\nContainerization (Docker): Strong experience with container-based deployment.\nCI\/CD: You have practical experience building and maintaining CI\/CD pipelines to automate testing and deployment.\n\n\nEven Better If You Have Experience With\n\n\nNoSQL \/ Vector Databases: Familiarity with Qdrant, MongoDB, NoSQL, or other document-based databases.\nMessage Brokers: Experience with systems like RabbitMQ.\nOrchestration: Knowledge of Kubernetes.\nAI Integration: Experience with the OpenAI API or similar large language models.\nML\/AI: A genuine curiosity and interest in the broader field of Machine Learning and AI.\nFrontend Knowledge: Familiarity with TypeScript\/Javascript.\n\n\nBeyond the tech stack, you work proactively, communicate clearly, are comfortable making decisions, and thrive in an early-stage product environment.\n\nWhy This Role Is Different\n\nAt BirdsAtFive, there’s no legacy mess to clean up, no tech debt holding you back, and no layers of management.\n\nThis is a chance to take full ownership of a backend that powers a next-generation AI product already being used by real customers. You’ll shape how it’s built, scaled, secured, and maintained — and play a defining role in our technical foundation.\n\nIf you want to say, \"I owned the backend for that company — I made it work\", this is your chance.\n\nWhat We Offer\n\n\nReal impact — everything you build will be used by real teams in real marketing work\nOwnership over all backend systems, with room to lead as we scale\nA tight, ambitious team that moves fast and values responsibility\nA hybrid setup — we work from Copenhagen with flexibility for remote days\nA product solving real pain for B2B teams — and doing it in a smarter way.\n\n\nBirdsAtFive is EU-first and privacy-focused We’re GDPR-compliant, security-minded, and built with enterprise customers in mind.","brief_summary_of_job":null,"existing_skills_from_job":["Hybrid","Full-time","Back-End Web Development","Python (Programming Language)","Artificial Intelligence (AI)","Machine Learning","Data Modeling","Data Architecture","Database Design","Infrastructure as code (IaC)","JavaScript","HTML","Python","TypeScript","FastAPI","MongoDB","NoSQL","Kubernetes","CI\/CD","RabbitMQ","Terraform"],"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": 4913,
  "extracted_skills": [
    {
      "skill_name": "Python",
      "category": "languages",
      "confidence": 100,
      "mentioned_as": ["Python", "python"],
      "context": "Core Technical Requirements"
    },
    {
      "skill_name": "FastAPI",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["FastAPI", "fastapi"],
      "context": "Your Responsibilities"
    },
    {
      "skill_name": "SQL",
      "category": "databases",
      "confidence": 100,
      "mentioned_as": ["SQL"],
      "context": "Core Technical Requirements"
    },
    {
      "skill_name": "MongoDB",
      "category": "databases",
      "confidence": 100,
      "mentioned_as": ["MongoDB", "mongodb"],
      "context": "Even Better If You Have Experience With"
    },
    {
      "skill_name": "NoSQL",
      "category": "databases",
      "confidence": 100,
      "mentioned_as": ["NoSQL", "nosql"],
      "context": "Even Better If You Have Experience With"
    },
    {
      "skill_name": "Docker",
      "category": "tools",
      "confidence": 100,
      "mentioned_as": ["Docker", "docker"],
      "context": "Core Technical Requirements"
    },
    {
      "skill_name": "Terraform",
      "category": "tools",
      "confidence": 100,
      "mentioned_as": ["Terraform", "terraform"],
      "context": "Core Technical Requirements"
    },
    {
      "skill_name": "RabbitMQ",
      "category": "tools",
      "confidence": 100,
      "mentioned_as": ["RabbitMQ", "rabbitmq"],
      "context": "Even Better If You Have Experience With"
    },
    {
      "skill_name": "Kubernetes",
      "category": "tools",
      "confidence": 100,
      "mentioned_as": ["Kubernetes", "kubernetes"],
      "context": "Even Better If You Have Experience With"
    },
    {
      "skill_name": "CI/CD",
      "category": "tools",
      "confidence": 100,
      "mentioned_as": ["CI/CD", "ci/cd"],
      "context": "Core Technical Requirements"
    }
  ],
  "reasoning": {
    "total_skills_found": 9,
    "skills_by_category": {
      "languages": ["Python"],
      "frameworks": ["FastAPI"],
      "databases": ["SQL", "MongoDB", "NoSQL"],
      "tools": ["Docker", "Terraform", "RabbitMQ", "Kubernetes", "CI/CD"]
    },
    "duplicates_removed": [],
    "excluded_skills": []
  },
  "confidence": 100
}