About this role
Nucleus Security is looking for a Senior Software Engineer to own end-to-end delivery of AI-driven features and build an evolving semantic data layer. The role emphasizes strong SQL and Python expertise, test-driven development, and rapid troubleshooting to keep production systems reliable for customer delivery.
Key Responsibilities
- Own the end-to-end lifecycle of AI-driven features from prototyping to production deployment
- Design, build, and evolve the semantic data layer for AI and analytics use cases
- Collaborate with engineering, product, and data teams to translate ambiguous requirements
- Diagnose, triage, and resolve production issues quickly
- Deliver reliable, continuously improving deployed systems to customers
Technical Overview
You will design and evolve a semantic data layer to enable scalable AI and analytics use cases, focusing on SQL performance optimization and complex query design. The position involves Python-based data processing and AI integration, test-driven engineering with unit and integration tests, and handling production deployment and issue triage.
Ideal Candidate
The ideal candidate is a senior software engineer with strong expertise in SQL (including performance optimization and complex query design) and significant experience building data-centric systems for analytics and AI use cases. They are proficient in Python for data processing and AI integration, have worked in test-driven environments with unit and integration tests, and can independently troubleshoot and triage production issues while delivering AI-driven features end-to-end.
Must-Have Skills
Own the end-to-end lifecycle of AI-driven features—from prototyping and experimentation to production deployment and customer deliveryDesignbuildand evolve our semantic data layer to enable scalablehigh-quality AI and analytics use casesStrong background in data analyticsdata scienceand/or data warehousingDeep expertise in SQLincluding performance optimization and complex query designProficiency in Python or similar language for data processing and AI integrationExperience working in a test-driven environment and writing unit and integration testsProven ability in technical troubleshootingCapable of working independently as well as collaboratively with teams across different time zones
Nice-to-Have Skills
Experience working with vulnerability scanning technologies on any part of the tech stack (e.g.SCASASTDASTIASTVM ScanningContaineretc.)Experience with column store databases and columnar dataespecially using SingleStore/MEMSQLExperience integrating AI/LLM-driven features with data platform.Familiarity with Agile/Scrum methodologies in a professional setting.Experience maintaining applications on Linux platforms in cloud environments.Experience with modern versions of PHPand the Zend and Laminas FrameworksImprove key components of the application to enable data scalability.
Tools & Platforms
SQLPythonSingleStoreMEMSQLLinuxZendLaminasAgileScrumSCASASTDASTIASTVM ScanningContainer
Required Skills
semantic data layerAI-driven featuresdata analyticsdata sciencedata warehousingSQLperformance optimizationcomplex query designPythonunit testsintegration teststest-driven environmenttechnical troubleshootingproduction deploymentAgileScrumLinuxSingleStoreMEMSQLAI/LLM integrationvulnerability scanning (SCASASTDASTIASTVM ScanningContainer)Zend FrameworkLaminas Frameworks
Hard Skills
AI-driven featuressemantic data layerdata analyticsdata sciencedata warehousingSQLperformance optimizationcomplex query designPythondata processingAI integrationtest-driven environmentunit testsintegration teststechnical troubleshootingproduction issues diagnosistriageproduction deploymentcustomer deliveryAgileScrumLinux platformscloud environmentscolumn store databasescolumnar dataSingleStoreMEMSQLAI/LLM-driven featuresdata platformvulnerability scanning technologiesSCASASTDASTIASTVM ScanningContainermodern versions of PHPZend FrameworkZend and Laminas FrameworksLaminas Frameworks
Soft Skills
own end-to-end lifecycletranslate ambiguous requirements into robust technical solutionscollaborate with engineeringproductand data teamswork independentlycollaboratively with teams across different time zonesquickly diagnose and triage production issuescontinuous improvement
Keywords for Your Resume
Senior Software EngineerSenior Software Engineer – Semantic Layer and AI Interfacessemantic data layerdata analyticsdata sciencedata warehousingSQLperformance optimizationcomplex query designPythonunit testsintegration teststest-driven environmenttechnical troubleshootingproduction issuestriageAI-driven featuresproduction deploymentcustomer deliveryAgileScrumLinuxcloud environmentsSingleStoreMEMSQLAI/LLM-driven featuresvulnerability scanning technologiesSCASASTDASTIASTVM ScanningContainerPHPZendLaminas
Deal Breakers
Must have deep expertise in SQL, including performance optimization and complex query design, Must have proficiency in Python (or similar) for data processing and AI integration, Must have experience working in a test-driven environment and writing unit and integration tests
Get matched to jobs like this
Luna finds roles that fit your skills and career goals — no endless scrolling required.
Create a Free Profile