Software Engineer II at American Express in Gurugram

Job description

The Core Infrastructure Compute team is responsible for managing and maintaining enterprise compute inventory, integrating and consolidating data from multiple sources, and ensuring data accuracy, consistency, and visibility across infrastructure platforms. The team focuses on developing modern web applications, building scalable data integration and reporting solutions, leveraging Generative AI capabilities, and delivering actionable insights through advanced analytics and intelligent automation to drive operational efficiency, informed decision-making, and continuous infrastructure optimization. We are seeking an experienced Senior Software Engineer with strong hands-on expertise in Microsoft Power BI, MS SQL Server, React.js, Python, Generative AI, Large Language Models (LLMs), Retrieval-Augmented Generation (RAG), vector databases, and data analytics. The ideal candidate will possess strong software engineering fundamentals, programming expertise, analytical problem-solving capabilities, and practical experience designing and developing AI-enabled enterprise applications. The role requires the ability to integrate structured and unstructured enterprise data with modern AI technologies while ensuring application scalability, security, reliability, and performance. Software Engineering & Application Development Design, develop, enhance, and maintain scalable enterprise applications, analytical platforms, and AI-enabled solutions. Develop modern, responsive, and interactive web applications using React.js, JavaScript, TypeScript, HTML, and CSS. Build reusable frontend components, dashboards, and application interfaces. Develop and integrate RESTful APIs, backend services, and enterprise data integrations. Implement application functionality using Python, JavaScript, TypeScript, C#, or equivalent programming languages. Apply software engineering best practices, including modular architecture, clean coding, unit testing, code reviews, and performance optimization. Troubleshoot complex application, integration, performance, and production issues. Collaborate with product owners, data engineers, AI engineers, and business stakeholders to deliver scalable technical solutions. Power BI & Data Analytics Design, develop, deploy, and maintain enterprise Power BI dashboards, reports, and analytical solutions. Translate complex business requirements into interactive dashboards, KPIs, scorecards, and actionable insights. Develop Power BI semantic models, advanced DAX measures, calculated columns, and Power Query transformations. Integrate Power BI with MS SQL Server, APIs, enterprise applications, and other structured data sources. Optimize dashboard performance, data refresh processes, query execution, and reporting efficiency. Implement row-level security, workspace access controls, and data governance best practices. Analyze large datasets to identify trends, anomalies, operational risks, and opportunities for improvement. Develop automated reporting and analytical solutions to improve business decision-making. Explore AI-assisted analytics, natural-language querying, and intelligent insights across enterprise data. MS SQL Server & Database Engineering Design, develop, maintain, and optimize SQL Server databases and enterprise data solutions. Develop complex T-SQL queries, stored procedures, functions, views, and database scripts. Perform query optimization, indexing, execution plan analysis, and database performance tuning. Develop data extraction, transformation, and integration workflows to support applications, analytics, and AI use cases. Implement relational data models and ensure data quality, consistency, integrity, and security. Integrate SQL Server data with Power BI, React applications, Python services, and AI-powered applications. Support structured data retrieval and integration with Generative AI and RAG solutions. Troubleshoot database performance, connectivity, and data processing issues. Generative AI & LLM Applicatio