Sr. Business Analyst

Sr. Business Analyst Columbus, OH

Visa status: U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. Tax Terms: W2, 1099 Corp-Corp or 3rd Parties: Yes

About the Business Analyst Role

This role plays a critical part in the development of an automated compliance monitoring system for IT Controls. Must be experienced in requirement gathering, data analysis, use case documentation. Review business requirements with project teams to propose and produce technical documentation such as current state, future state, gap analysis, source to target mapping, data flow diagrams, and test cases. Work with the development team in seamless implementation of each task. Participate in the Agile development process in delivering increments of final product.

Responsibilities

• Gather requirements from JAD sessions with business users.
• Design and develop Activity Diagrams, Sequence Diagrams, and OOD to represent the requirements to communicate the information effectively with users, developers and testers.
• Work closely with business users, subject matter experts to understand and document functional and non-functional requirements for various use cases.
• Identify/document data sources and transformation rules required to populate and maintain data warehouse content.
• Review and analyze data and data models including reports to augment the requirement for use cases with technical information for facilitating development and data modeling activities.
• Conduct meetings and presentations to share ideas and findings to stakeholders and team members.
• Effectively communicate insights and plans to cross-functional team members and management.
• Write data analysis SQL queries to profile and document metadata to analyze data and augment key inputs required.
• Perform extensive requirement analysis, develop use cases and workflows.
• Play key role in the planning, User Acceptance Testing, and Implementation of system enhancements and conversions.
• Develop strategic partnerships with the business units to develop a solid knowledge base of the business line including the business plan, products, process and revenue streams.
• Develop business requirement specification documents as well as high-level project plan.

Requirements

Bachelor's Degree or master's degree in Computer Science, Mathematics, Statistics.

• 10+ years of experience working as Business Analysts.
• 5+ years of experience in T-SQL and multiple databases like SQL Server, Oracle or Netezza.
• 5+ years of experience in projects involving Java, Spring Batch or Spring-Kafka.
• 3+ years of experience in Reporting tool like Tableau.
• Excellent verbal and written communication skills.
• Conducted benchmarking activities to identify best practices.