Application Systems Analyst - #26343

Job Summary

Blue Chip Talent, in partnership with a manufacturing organization, is seeking a skilled Technical Business Analyst. This role is responsible for supporting production applications, analyzing and resolving complex data issues, managing API integrations, and providing hands-on support for Microsoft Entra ID (Azure AD) Single Sign-On across dealer-facing applications. The ideal candidate is comfortable working with SQL, cloud-based data platforms, identity management processes, and cross-functional teams to ensure reliable, secure, and efficient application support.

Job Duties

• Provide production support for data-driven dealer-facing applications by triaging incidents, monitoring data flows, and resolving application issues
• Write and optimize SQL queries to investigate data discrepancies, validate results, and support root cause analysis
• Monitor inbound and outbound data feeds while maintaining database integrity and file schedules
• Support API integrations between internal and third-party systems by troubleshooting connectivity, payload, and data mapping issues
• Gather and document Single Sign-On requirements for new and existing applications, translating business needs into technical specifications
• Assist with Microsoft Entra ID (Azure AD) enterprise application configuration, app registrations, claims mapping, group assignments, and token configuration reviews
• Support SSO testing in development and test environments prior to production deployment
• Troubleshoot user authentication and access issues by reviewing Entra ID sign-in logs, audit logs, group memberships, conditional access policies, MFA challenges, and token behavior
• Coordinate with Identity & Access Management, Security, and Development teams to resolve authentication and integration issues while communicating status to business stakeholders
• Support application integration testing to ensure applications correctly consume SSO tokens, validate claims, and maintain expected session behavior
• Monitor recurring authentication incidents, identify trends, and recommend long-term improvements
• Maintain business requirements documents, functional specifications, technical runbooks, and SSO process documentation
• Assess the impact of identity and access policy changes and communicate upcoming changes to affected stakeholders
• Manage enhancement requests and production support activities using Agile methodologies and Jira
• Participate in daily production support triage meetings and other recurring team meetings

Required Skills:

• 3–5 years of Business Analyst or Business Systems Analyst experience
• 3+ years of hands-on SQL experience, including writing and troubleshooting complex queries
• Practical experience supporting Microsoft Entra ID (Azure AD) Single Sign-On, including enterprise applications, app registrations, claims mapping, group assignments, access troubleshooting, and authentication support
• Experience supporting API integrations and diagnosing data exchange or integration issues
• Experience gathering, documenting, and validating business and technical requirements
• Experience reviewing Entra ID sign-in logs, audit logs, conditional access policies, and authentication events
• Experience creating BRDs, functional specifications, technical documentation, and support runbooks
• Understanding of Agile/Scrum and SDLC methodologies
• Experience using Jira or similar work management tools
• Intermediate to advanced Microsoft Excel skills