• AI Engineer (Onsite Chicago 5/x week)

    Insight Global (Chicago, IL)


    Job Description

    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.

    Key Responsibilities

    • 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).

     

    We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [email protected] learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

    Skills and Requirements

    • 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. • 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