# 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":4035,"title":"Senior Engineer","company_name":"the LEGO Group","description":"About the job\n\nJob Description\n\nCan you picture yourself shaping the future of how LEGO presents our products?\n\nJoin our collaborative team to transform how LEGO products are digitally showcased across platforms and channels. Bring your engineering expertise to help us evolve our Product Information and Experience (PIM\/PXM) ecosystem.\n\nWe see huge potential in how we present products to different audiences. With a wealth of content and countless touchpoints, our challenge is to deliver the right content in the right way for every situation. That’s where you come in!\n\nWe’re looking for a Senior Software Engineer to develop innovative technical solutions that meet ambitious business needs and bring our product experiences to the next level.\n\nThis role is based in our Copenhagen Digital Hub. Please note that relocation assistance is not available.\n\nCome join us!\n\n\nCore Responsibilities\n\nAs we roll out our new PIM\/PXM platform, we expect both challenges and opportunities—some clear today, others we’ll uncover along the way.\n\nYou’ll help define data models, integrate with existing systems, optimize workflows with end users, analyze data, and rethink how we handle content. Our team has a solid foundation and growing demand for solutions, giving you the chance to make a real impact.\n\nYou’ll be part of the group that maintains current automation while driving the new platform. Success depends on seamless integration with other internal systems and evolving workflows across our commercial teams.\n\nYour role goes beyond coding APIs and building data integrations. You’ll collaborate with users to understand their needs and deliver meaningful solutions. This calls for technical skill, user empathy, a hands-on approach, and belief in our shared vision.\n\nPlay your part in our team succeeding\n\nProduct Development Technology is on a mission to deliver the best digital experience for our commercial partners. We set standards for content creation, curation, and optimization—helping teams make data-driven decisions, reduce manual work, and showcase LEGO products at their best across digital channels. Our tools make a real difference for colleagues in commercial offices worldwide and for digital teams building engaging applications.\n\nYou’ll join our Copenhagen-based Product Information Management team, working closely with colleagues in Billund, London, Boston, Shanghai, and more. We balance focus time and collaboration with three days a week in the office.\n\nA typical day could involve pair programming with a teammate to implement a new feature, diving into a workshop to design an integration pattern, or reviewing pull requests. You could also be exploring ways to address data issues or brainstorming with our commercial partners to streamline workflows. Every day offers variety, impact, and opportunities to collaborate.\n\nOur department typically relies on the following tools, languages and technologies (all in a backend context) Go, Typescript, Node.js, AWS (CDK, Lambda, EventBridge, SQS, SNS, etc), Elastic\/Elasticsearch & some rational databases. Expect to be working with Akeneo PIM. We like to build exciting things with boring technology but value a no-fuss best tool for a particular task!\n\nDo you have what it takes?\n\nYou love building great products as part of a team and empowering and mentoring others. Sharing your skills and approaches is a strength for you, and you’re always open to learning in return. As a problem solver, you focus on crafting the best solution, tackling technical challenges, and ensuring all requirements are met and delivered.\n\nFurthermore, you'll do well in this role if you\n\n\n\n\n\nHave experience building distributed cloud systems at scale, using infrastructure-as-code, event-driven principles, and our tech stack. \nHave worked with Product Information\/Experience Management, Master Data Management, or similar systems related to commercial product content. \nBring solid API composition and system integration expertise, demonstrating the ability to articulate and deliver solutions. \nUnderstand security in web-based solutions and APIs. \nKnow CI\/CD workflows, e.g. GitHub Actions, and advocate automation. \nExcel at evolving existing systems into next-generation services, not just greenfield development. \nAre flexible and open to working with different product teams when needed, adapting to new challenges and chipping in where your expertise can make the greatest impact. \nYou have excellent spoken and written English skills. \n\n\n\n\nIt Wouldn’t Hurt If You Knew About\n\n\n\n\n\nProviding digital solutions for a retail-related domain and digital marketplaces. \nOperating high-performance applications and services in the AWS cloud. \nFamiliarity with React.js and GraphQL. \nExperience with data mining on large datasets. ML tools and techniques. \nDevOps experience. \nBuilding distributed systems using microservice architecture. \nOpen-Source contribution experience is a plus. \n\n\n\n\nApplications are reviewed on an ongoing basis. However, please note we do amend or withdraw our jobs and reserve the right to do so at any time, including prior to any advertised closing date. So, if you're interested in this role we encourage you to apply as soon as possible.\n\nWhat’s in it for you?\n\nHere is what you can expect\n\nFamily Care Leave - We offer enhanced paid leave options for those important times.\n\nInsurances – All colleagues are covered by our life and disability insurance which provides protection and peace of mind.\n\nWellbeing - We want our people to feel well and thrive. We offer resources and benefits to nurture physical and mental wellbeing along with opportunities to build community and inspire creativity.\n\nColleague Discount – We know you'll love to build, so from day 1 you will qualify for our generous colleague discount.\n\nBonus - We do our best work to succeed together. When goals are reached and if eligible, you'll be rewarded through our bonus scheme.\n\nWorkplace - When you join the team you'll be assigned a primary workplace location i.e. one of our Offices, stores or factories. Our hybrid work policy means an average of 3 days per week in the office. The hiring team will discuss the policy and role eligibility with you during the recruitment process.\n\nChildren are our role models. Their curiosity, creativity and imagination inspire everything we do. We strive to create a diverse, dynamic and inclusive culture of play at the LEGO Group, where everyone feels safe, valued and they belong.\n\nThe LEGO Group is highly committed to equal employment opportunity and equal pay and seeks to encourage applicants from all backgrounds (eg. sex, gender identity or expression, race\/ethnicity, national origin, sexual orientation, disability, age and religion) to apply for roles in our team.\n\nThe LEGO Group is fully committed to Children’s Rights and Child Wellbeing across the globe. Candidates offered positions with high engagement with children are required to take part in Child Safeguarding Background Screening, as a condition of the offer.\n\nThank you for sharing our global commitment to Children’s Rights.\n\nJust imagine building your dream career.\n\nThen make it real.\n\nJoin the LEGO® team today.","brief_summary_of_job":null,"existing_skills_from_job":["TypeScript","Node.js","React","Elasticsearch","Git","GitHub","CI\/CD","GraphQL","AWS"],"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": 4035,
  "extracted_skills": [
    {
      "skill_name": "Go",
      "category": "languages",
      "confidence": 100,
      "mentioned_as": ["Go"],
      "context": "mentioned in the tools, languages and technologies section"
    },
    {
      "skill_name": "TypeScript",
      "category": "languages",
      "confidence": 100,
      "mentioned_as": ["TypeScript"],
      "context": "mentioned in the tools, languages and technologies section"
    },
    {
      "skill_name": "Node.js",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["Node.js"],
      "context": "mentioned in the tools, languages and technologies section"
    },
    {
      "skill_name": "AWS",
      "category": "tools",
      "confidence": 100,
      "mentioned_as": ["AWS"],
      "context": "mentioned in the tools, languages and technologies section"
    },
    {
      "skill_name": "Elasticsearch",
      "category": "databases",
      "confidence": 100,
      "mentioned_as": ["Elastic/Elasticsearch"],
      "context": "mentioned in the tools, languages and technologies section"
    },
    {
      "skill_name": "Git",
      "category": "tools",
      "confidence": 100,
      "mentioned_as": ["Git"],
      "context": "mentioned in the CI/CD workflows section"
    },
    {
      "skill_name": "GitHub",
      "category": "tools",
      "confidence": 100,
      "mentioned_as": ["GitHub"],
      "context": "mentioned in the CI/CD workflows section"
    },
    {
      "skill_name": "CI/CD",
      "category": "tools",
      "confidence": 100,
      "mentioned_as": ["CI/CD"],
      "context": "mentioned in the CI/CD workflows section"
    },
    {
      "skill_name": "GraphQL",
      "category": "frameworks",
      "confidence": 100,
      "mentioned_as": ["GraphQL"],
      "context": "mentioned in the tools, languages and technologies section"
    }
  ],
  "reasoning": {
    "total_skills_found": 9,
    "skills_by_category": {
      "languages": ["Go", "TypeScript"],
      "frameworks": ["Node.js", "GraphQL"],
      "databases": ["Elasticsearch"],
      "tools": ["AWS", "Git", "GitHub", "CI/CD"]
    },
    "duplicates_removed": [],
    "excluded_skills": []
  },
  "confidence": 100
}