Business Systems Analyst (BA, SQL, API, Agile)

Business Systems Analyst, Assurant-GCC, India

This job is responsible for application configuration management within Assurant’s global Trade-In and Upgrade solution ecosystem; supporting Americas, LATAM, EU, AU and Japan regions. On projects of various complexity, the position participates in activities such as delivery planning, requirement definition, requirements analysis, software setup, test plan design and execution, training and documentation.  Also responsible for data analytical and profiling functions, and creation of technical requirement documents.

This position will be in Hyderabad at our India location.

What will be my duties and responsibilities in this job?

• Acts as the customer/IT liaison during analysis, requirements definition and planning activities; documenting business requirements to implementing software configurations. (10%)

• Participates in the project management process; understands and applies the system development methodology; contributes to project deliverables including status reports, and project risk; and communicates status, business impacts and system changes to team members, business partners, sponsors, management and other interested parties; coordinates issues, tracking and resolution on high level, complex projects.  (15%)

• Coordinates and owns configuration management activities for project assignments; provides guidance for testing strategies, scope and scenarios; reviews and provides advice for testing-related estimates of effort, duration and resource utilization; prepares and reviews test plans; identifies testing risks and contributes to the overall management of project and risk plans; coordinates, manages and participates in complex testing efforts; perform data profiling and analytical tasks using Microsoft SQL Server. (40%)

• Develops moderate to complex reports and file extracts using Power BI; publishing permission-controlled UI reports, subscription delivered reports, subscription delivered files extracts. Understands intricacies of reporting, including system data flows, data availability, data accessibility and data privacy, to gather critical details from stakeholders required to provide secure, compliant access to data. (20%)

• Provides general customer and IT support for assigned business applications; works with business and technical staff to perform effective root-cause analysis and resolution. Gathers, compiles, interprets and summarizes systems and business process changes; maintains reference materials and standard-process documentations. (15%)

What are the requirements needed for this position? 

• 4 years working with business users and stakeholders on business requirements, software setup and testing, technical documentation (including data-process flows), and systems analytics
• Outstanding verbal and written communication soft skills, with a strong emphasis on clarity
• Exceptional skills identifying subtle nuances in business requirements and translating them into precise technical requirements
• Experience working in a high-paced, highly flexible, team environment
• Aptitude for logical and analytical thinking, coupled with strong problem-solving skills
• Comfortable with log-level data analysis of application behavior discrepancies
• Applied understanding of languages: SQL, JSON, XML, HTML, YAML
• Proficient with SQL queries, temp tables, procedures, etc. – able to build complex reports and data extracts
• Utilization of API tools: SOAP UI, Postman, Swagger UI
• Experience with agile management tools (ie: Azure DevOps, JIRA, Confluence, SharePoint)

What other the Preferred Experience, Skills, and Knowledge?

• Bachelor’s degree in Computer Science or Computer Engineering
• Experience with any of the following: MS Power BI, MS Report Builder, MS Power Automate, Azure Storage Explorer, Azure Blob Storage, Twilio
• Experience in a project management role
• Experience with reverse logistics, device trade-in market, omni-channel support
• Experience setting up interdependent configurations across multiple applications
• Experience setting up customer email and sms communications