Lead Business Analyst

• Collaborate with vendors to design, develop, and implement Automation solutions using RPA tools such as Automation Anywhere, SQLs, Python and VBA.
• Utilize expertise in programming languages such as SQL and Python to perform data analysis and recommend various solutions to improve data accuracy, timeliness, and completeness.
• Create data visualizations utilizing tools such as Tableau\Power BI to present and recommend alternative solutions as well as drive data-driven decision-making.
• Possess deep knowledge of APIs and be able to leverage this expertise to communicate with various data sources and vendors.
• Conduct feasibility studies to determine the technical and economic feasibility of the proposed solution.
• Understand and document well-organized, detailed, and concise business requirements by converting the results of data from interviews and conducting own analysis.
• Identify opportunities in current processes, conduct GAP analysis to quantify issues, and recommend alternative solutions that will optimize process and/or improve the completeness, timeliness, and quality of the data set.
• Plan, organize, facilitate, and lead reviews of business requirements with users and developers to ensure accuracy, completeness, and mutual understanding.
• Coordinate and collaborate effectively with the project team, including but not limited to end-users, product management, evaluations, index, portfolio analytics, quality assurance, project management, and development teams to mitigate and assess project risks, eliminate ambiguities, and meet project deadlines.
• Examine current business functions and system capabilities. Identify trends and causations of inaccurate and/or incomplete data sets by conducting in-depth root cause analysis.
• Determine efficiencies, accuracy, timeliness, completeness gained from recommended solutions.
• Monitor project progress by tracking activity, resolving problems, and publishing progress reports. Prepare production release notes and organize review sessions with RDO and DSG groups to ensure a full understanding of release scope.
• Apply problem-solving skills to create innovative workflow resulting in increased productivity.
• Write complete and concise test scripts for user acceptance testing. Plan, coordinate, and execute created test cases.
• Identify any potential data gaps resulting from the creation of new fields and/or rules. Work with related groups to confirm completion of data backfills required after a production release.
• Coordinate closely with the RDO training team to ensure all training documentation is adjusted, and all training sessions are completed before the release rollout.
• Mentor junior team members on Automation tools and best practices.
• Create working relationships with Data Vendors to understand content and escalate issues.

• Bachelor's degree or higher in Economics, Computer Science, Information Systems, or related technical or financial field required.
• Very strong querying capabilities using SQL.
• Deep understanding in various RPA and Automation tools.
• 3+ years of direct experience as a Business Analyst.
• Ability to work in a fast-paced, high-pressure, fluid environment.
• Ability to distill large amounts of information into specific takeaways.
• Excellent attention to detail and a high degree of demonstrated decision-making and problem-solving skills.
• Excellent written and oral communication skills, including the ability to communicate technical concepts to both technical and non-technical stakeholders.
• Knowledge of software development, life cycle and experience with Agile methodologies is required.
• Experience working with APIs, an advantage.
• Python scripting skills, an advantage.

Mploy