AI Engineer (Onsite Chicago 5/x week)

We’re seeking a seasoned Senior Data Solution Developer to design, build, and optimize mission critical applications and data platforms. You will own end to end engineering across backend services (Java/Spring) and data layers with a focus on performance, reliability, security, and scalability. Additionally, you will be responsible for integrating with industry leading AI platforms for cybersecurity intelligence solution. This is a hands-on role for someone who enjoys solving complex data and system problems, leading technical initiatives, and mentoring others., * Application Development o Architect, develop, and maintain backend services using Java (Java 11+/17), Spring (Boot, Data, Security), and RESTful APIs. o Implement robust data access patterns using JDBC, JPA/Hibernate, and stored procedures/functions where appropriate.

• Database Engineering o Design and optimize schemas, indexes, constraints, and query plans for Oracle Database o Build and maintain ETL/ELT processes; ensure data quality, lineage, auditing, and reconciliation. o Implement and query Graph databases (e.g., TigerGraph, Neo4j, JanusGraph, Amazon Neptune) for relationship heavy workloads; design graph models (nodes, relationships, properties), Cypher/Gremlin queries.

• AI Platform Integration o Design and implement AI and Graph DB friendly application data output o Integrate with Graph DB for security graph visualization o Integrate with LLMs and provide solution for complex cybersecurity investigation

• Performance, Scalability & Reliability o Conduct SQL performance tuning (execution plans, hints, statistics, partitioning, indexing strategies). o Profile Java services (GC tuning, thread management, connection pools, caching) to meet latency and throughput SLAs. o Design for high availability and disaster recovery (replication, failover, backups).

• Security & Compliance o Implement least-privilege access, encryption at rest/in transit, secrets management, auditing, and compliance (SOX/PCI/HIPAA as applicable).

• Collaboration & Leadership o Partner with Product, Data, and Platform teams to translate requirements into robust designs. o Lead code reviews, establish best practices, and mentor junior engineers. o Contribute to roadmaps, estimation, documentation, and production support (on-call rotation if applicable).

• 8+ years of professional software development experience, with 5+ years focused on Java backend development.
• Expert-level SQL and RDBMS experience with Oracle (schema design, complex queries, query optimization, stored procedures, PL/SQL/T-SQL).
• Hands-on experience with Graph databases (TigerGraph/Neo4j/JanusGraph/Amazon Neptune), including data modeling and query languages (Cypher, Gremlin).
• Strong experience with Java 11+, Spring Boot, REST APIs, JPA/Hibernate, and JDBC.
• Proven track record in performance tuning (both SQL and JVM), transactions, locking, isolation levels, and concurrency.
• Strong experience using the MCP to enable LLMs to safely query and interact with cybersecurity data source. Familiarity with secure context management and auditability within MCP-driven architectures is highly value
• Experience with CI/CD, Git, Docker/Kubernetes, and cloud platforms (AWS or Azure).
• Solid understanding of data security, encryption, auditing, and access control.
• Excellent problem-solving skills, communication, and the ability to lead complex cross functional initiatives.

Nice to Have Skills & Experience

• Experience with data caching (Redis/Apache Ignite), message brokers (Kafka/RabbitMQ), and event-driven architectures.
• Familiarity with partitioning, sharding, table compression, in memory OLTP, and columnstore indexes (MSSQL).
• Exposure to Oracle features (e.g., AWR/ASH, optimizer hints, partitioning, materialized views). Self-motivated and enjoy resolving issues and building solutions to complex problems

Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.