Application Analyst – Integrations

Position: Application Analyst Integrations

Duration: Long-term contract expected up to 36 months

Location: Detroit MI (Onsite Position)

Client: City of Detroit (Detroit Water and Sewerage Department)

Position Overview:

We are seeking an experienced Application Analyst Integrations to support enterprise application integration data flow testing and workflow improvement initiatives for a public-sector utility client.

The consultant will work closely with internal business and technical teams to understand application needs document workflows support system integrations perform testing troubleshoot issues and help improve business processes across critical software platforms.

This role requires strong experience with Oracle Cloud Infrastructure application integrations APIs middleware testing and business workflow documentation.

Key Responsibilities:

• Meet with business users and internal teams to gather and document business requirements.
• Analyze existing applications systems workflows and integrations.
• Design configure test and support application integrations.
• Support middleware APIs web services and data mapping between enterprise systems.
• Troubleshoot application data flow integration and system issues.
• Develop and support test cases for integrations software upgrades and application changes.
• Support user acceptance testing and coordinate testing with business users.
• Document business workflows and recommend improvements to reduce inefficiencies.
• Help improve transaction transparency data accuracy and customer-facing system performance.
• Identify risks dependencies and conflicts between applications systems and business processes.
• Support application enhancements upgrades replacements and implementation activities.
• Provide training or knowledge transfer to end users and internal teams when needed.
• Work with client staff project teams and stakeholders in an onsite environment.

Required Skills and Experience

• 8 years of progressive experience as an Application Analyst Integration Analyst Systems Analyst or similar IT role.
• 5 years of experience with application integration design and development.
• 5 years of experience with Oracle Cloud Infrastructure Oracle applications or OCI-based integration work.
• Strong experience with APIs middleware web services data mapping and enterprise system integrations.
• Experience developing test cases for integrations software upgrades and application changes.
• Experience supporting UAT QA processes and testing documentation.
• Experience documenting business workflows and recommending workflow improvements.
• Strong troubleshooting skills for application integration and data-related issues.
• Ability to work with business users and technical teams.
• Strong written and verbal communication skills.
• Must be able to work onsite in Detroit MI during the initial phase of the project.

Preferred Experience

• Experience with public-sector or utility-sector projects.
• Experience with Oracle Utilities Customer Care and Billing.
• Experience with enQuesta customer information system.
• Experience with CityWorks or GIS-based work order management systems.
• Experience with customer portals payment systems or billing integrations.
• Experience with Java Python SQL stored procedures CI/CD pipelines or cloud-native microservices.
• Experience supporting data quality customer privacy data security and customer satisfaction initiatives.

Education

• Bachelors degree in Computer Science Information Systems Engineering Business or a related technical field is required.
• Masters degree is preferred.