Technical BA

Akaasa Technologies; Michigan; On-site; USD 90,000 - 120,000; Full time

Job summary

Akaasa Technologies in Dearborn, MI is seeking a Technical Business Analyst to provide production support for two data‑driven, dealer‑facing applications. You will triage incidents, analyze data, and translate technical issues into clear communications for business stakeholders.

The role requires 3+ years of SQL, API integration experience, and familiarity with Azure AD SSO, Azure/GCP, Databricks, and Oracle.

Qualifications

• Bachelor's degree in CS/IT/Engineering or equivalent.
• 3+ years of hands-on SQL experience and data analysis.
• Experience with Microsoft Entra ID / Azure AD SSO and API integrations.
• Familiarity with cloud platforms (Azure, GCP) and Databricks.
• Strong written and verbal communication for technical and business audiences.

Responsibilities

• Provide production support for data-driven, dealer-facing applications.
• Triage incidents, changes, and data issues; optimize SQL queries.
• Support API integrations (REST/SOAP) and data mapping fixes.
• Assist with Azure AD SSO configuration and access troubleshooting.
• Analyze multi-source data to identify trends and root causes; document findings.
• Maintain BRDs, functional specs, and technical runbooks; use Jira for work tracking.
• Apply Agile/Scrum and SDLC best practices; deliver clear status updates.

Skills

Analytical skills

Data interpretation

Effective communication

Stakeholder management

Documentation

Agile/Scrum practices

SDLC knowledge

Education

Bachelor's degree in Computer Science / Information Technology / Engineering

Tools

SQL

Azure AD / Entra ID

Databricks

Oracle

Jira

Excel

Google Cloud Platform

Azure

Job description

Need one manager reference.

MUST BE LOCAL TO WORK ONSITE in Dearborn, MI 48126

Industry: Marketing Services

*client name will be provided only once candidate is selected prior to my technical screen call with them

Interview: must be able to go onsite for Final in Dearborn, MI (NO EXCEPTIONS)

Candidates with eCommerce, B2B, and Auto Retail backgrounds are a plus

We are seeking a Technical Business Analyst to provide production support and drive enhancements for two data-driven, dealer-facing applications. This role involves triaging incidents and change requests, analyzing data to resolve issues, writing SQL queries, supporting API integrations, and assisting with Microsoft Entra ID (Azure AD) SSO configuration and troubleshooting. The ideal candidate is detail-oriented, analytical, and skilled at translating technical issues into clear communication for both technical and business stakeholders.

Responsibilities:

Provide production support for data-driven applications, including monitoring inbound/outbound data feeds, managing file schedules, and maintaining database integrity.

Write and optimize SQL queries (3+ years of experience) to investigate data issues, validate results, and support analysis.

Work within cloud-based data platforms such as Azure or Google Cloud Platform (GCP), with Databricks and/or Oracle experience considered a plus.

Support and troubleshoot API integrations between internal applications and third-party systems, including RESTful and/or SOAP-based services - validating payloads, diagnosing connectivity or data-mapping issues, and working with development teams to resolve integration defects.

Support Microsoft Entra ID (Azure AD) Single Sign-On for dealer-facing applications, including assisting with configuration and app registration, troubleshooting user login/access issues, coordinating with IAM/security and development teams on integration and token handling, and documenting SSO processes and incidents.

Analyze complex, multi-source datasets to identify trends, anomalies, and root causes, translating findings into actionable recommendations.

Maintain and update business requirements documentation (BRDs), functional specs, and technical runbooks as systems evolve.

Apply Agile/Scrum principles and SDLC best practices to manage enhancement requests and support tasks.

Create clear, detailed technical documentation, incident reports, and status updates for both technical and non-technical audiences.

Manage and track work using project/ticketing tools such as Jira.

Balance independent ownership of tasks with active collaboration in a team environment.

Qualifications:

Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field, plus 3-5 years of relevant professional experience.

3+ years of hands‑on experience writing and troubleshooting SQL queries.

Practical experience with Microsoft Entra ID / Azure AD SSO - including configuration, access troubleshooting, and integration with enterprise applications.

Demonstrated experience supporting or implementing API integrations, including diagnosing failures in data exchange between systems.

Strong analytical skills with the ability to interpret complex datasets and drive data‑informed decisions.

Experience gathering, documenting, and validating business and technical requirements.

Familiarity with Databricks and/or Oracle environments is a plus.

Excellent verbal and written communication skills, with the ability to translate technical concepts for non-technical audiences.

Strong meeting facilitation and stakeholder management skills.

Intermediate to advanced proficiency in Microsoft Excel.

Prior experience in a customer-facing or technical support environment.

Exceptional attention to detail, organizational skills, and ability to manage multiple priorities.

Self‑motivated, resourceful, and adaptable, with a professional demeanor under pressure.

Ability to work independently with minimal supervision while remaining a strong team contributor.