Senior AI Software Engineer - Hamilton, NJ - Need to work from office 5 Days a week and has to come to office for F2F Round

[Shristi Awasthi]

Hi,

Hope you are doing well.

Role Name - Senior AI Software Engineer

Location: Hamilton, NJ - Need to work from office 5 Days a week and has to come to office for F2F Round

Type: Contract

Only H1B
ROLE_DESCRIPTION 

We are hiring a Senior AI Software Engineer to lead the design and delivery of AI-powered applications within our Platform Development team.
This role is designed for someone who can bridge the gap between large language models (LLMs) and real financial data by architecting the backend systems and data platforms that make AI genuinely useful for our advisors and their clients.

Your primary focus will be building and scaling our text-to-SQL agent and other conversational AI tools.

Our data ecosystem spans:
• SQL Server
• Microsoft Fabric
• Databricks
You will architect schemas, validate AI-generated queries, and build the backend services that connect AI systems to our financial data platforms.
The AI writes the SQL — you must know whether it is correct.
This is a high-impact and high-visibility role where you will:
• Mentor engineers
• Drive architectural decisions
• Establish engineering standards
• Help build a culture of experimentation, learning, and delivery

If you have been deeply exploring AI technologies and want to apply them to meaningful financial services problems, this is the opportunity.

Responsibilities
• Lead the architecture and development of a text-to-SQL agent that allows financial advisors to query complex datasets using natural language
• Architect the data layer used by AI models, including:
• Designing schemas
• Structuring data across SQL Server and modern data platforms
• Validating AI-generated SQL queries for correctness and performance
• Build and refine AI integration patterns, including:
• Prompt engineering
• Retrieval-Augmented Generation (RAG)
• Function calling
• Agent-based workflows
• Implement AI guardrails appropriate for regulated financial environments
• Design and develop backend services and APIs supporting AI-driven features
• Deploy and operate services on Microsoft Azure
• Mentor engineers and guide best practices in architecture, design, and development
• Drive engineering standards and technical direction
• Collaborate with product, design, and data teams to deliver AI solutions from concept to production

Qualifications and Skills
• Bachelor’s degree in Computer Science or related field (Master’s degree preferred)
• 7+ years of professional software development experience
• Strong backend and API development experience on a major cloud platform (Azure preferred)
• Strong SQL expertise, including:
• Writing and analyzing complex queries
• Designing database schemas
• Evaluating AI-generated SQL for correctness and performance
• Hands-on experience working with LLMs and AI services
• Must have delivered production AI features, not just prototypes or proof-of-concepts
• Experience with backend technologies such as:
• C# / .NET
• Python
• Java
• or similar backend frameworks
• Familiarity with modern data platforms such as:
• SQL Server
• Microsoft Fabric
• Databricks
• or similar platforms
• Demonstrated ability to mentor engineers and lead technical initiatives
• Experience working in regulated industries, preferably financial services

Skills: Digital : Microsoft Azure~Digital : Databricks~Microsoft Fabric Experience Required: 8-10

Thanks & Regards,

Shristi Awasthi

US IT Recruiter

PROLIM Global Corporation

Email : shristi...@prolim.com