Senior Technical Systems Analyst | SQL & Reporting

Responsibilities

• Proactively plan and coordinate business workshops, define objectives, and partner with project management to meet delivery timelines.
• Lead business meetings to gather and refine requirements, and present design concepts and solution recommendations.
• Create detailed business requirements for functional (e.g., business processes, rules) and non-functional (e.g., data, security) capabilities.
• Validate test cases to ensure that scripts will evaluate the business function being performed.
• Gather and interpret information from multiple sources (including databases, interviews, etc.) and make recommendations.
• Support the business by handling configuration and workflow management for financial and document management systems.
• Provide support for application development teams, including documenting business processes.
• Translate technical concepts to business audience and business information to a technical audience.
• May take a lead role in developing estimates and implementation plans for technical solutions.
• Partner with team members to develop project schedules, reports and documentation.
• May be required to act as project lead on small to medium projects and/or provide direction to others on the team.
• Collaborate with the vendor handing over business use cases, designing technical solutions and assessing implementation options.
• Understand and apply principles in risk management, issue tracking and change management.

Requirements

• More than five (5) years of experience as a Technical Business Analyst is required.
• Financial Services experience is highly preferred.
• Experience with supporting enterprise level, complex applications is preferred.
• Experience and background in working with financial accounting systems would be preferred.
• Experience with Financial Accounting platforms (FIS, RenInc) preferred.
• Experience with Hyland OnBase software (Workflow, WorkView) preferred.
• Experience with gathering business requirements from ground up is required.
• Experience with SQL scripting, RDBMS queries, pulling data out of various systems, writing BRD's, etc... is required.
• Experience writing scripts for data manipulation.
• Experience in working with various stakeholders of IT and Business Operations at senior level is required.
• Experience with analyzing data in a complicated multi-layered application in heterogeneous environment.
• Experience in working with vendor-based application software implementation and support is a plus.
• Experience developing reports in SSRS/Tableau/ Power BI is a plus.

Qualifications

• Advanced knowledge issue tracking, change management and requirements gathering.
• Solid understanding of SDLC and working through various phases of it with Peers and IT Partners.
• Knowledge of Waterfall, Agile and Hybrid software development methodologies.
• Reporting knowledge from user perspective, such as creating and running reports in SSRS and Tableau.
• Demonstrated ability to independently lead workstreams, prioritize tasks, and drive progress with minimal oversight.
• Ability to understand in-depth details of business processes rules. Document and communicate them effectively to various technical and non-technical partners.
• Clearly convey information and ideas through a variety of media to individuals or groups in a manner that engages the audience and helps them understand and retain the message.
• Demonstrate a strong knowledge in position-related areas; remains current with developments and trends in areas of expertise.
• Work in a team environment or project room to facilitate collaboration.
• Ability to provide system support including after-hour incident handling when necessary (rotation within the support team).

Skills

• More than five (5) years of experience as a Technical Business Analyst is required.
• Financial Services experience is highly preferred.
• Experience with supporting enterprise level, complex applications is preferred.
• Experience and background in working with financial accounting systems would be preferred.
• Experience with Financial Accounting platforms (FIS, RenInc) preferred.
• Experience with Hyland OnBase software (Workflow, WorkView) preferred.
• Experience with gathering business requirements from ground up is required.
• Experience with SQL scripting, RDBMS queries, pulling data out of various systems, writing BRD's, etc... is required.
• Experience writing scripts for data manipulation.
• Experience in working with various stakeholders of IT and Business Operations at senior level is required.
• Experience with analyzing data in a complicated multi-layered application in heterogeneous environment.
• Experience in working with vendor-based application software implementation and support is a plus.
• Experience developing reports in SSRS/Tableau/ Power BI is a plus.