Job description

Business Intelligence/QA Testing Analyst Location: Chesterfield, MO – Hybrid 2-3 days a week in office Duration: 12 months with right-to-hire after six months Required: • 3+ years in QA Testing • 3+ years in Business Intelligence and data warehousing areas (SSRS (Report Builder), Tableau, and Power BI) • 3+ years in programming and system analysis • 3+ years using SQL Server Preferred: • Working knowledge of SDLC process and Agile methodology • Working knowledge of Testing tools and Testing Methodologies • Experience in Commercial Real Estate Finance • Working knowledge of Loan Management Systems Position Overview: Within the Real Estate Investments team, this QA BI Testing Analyst position is responsible for all aspects of QA and testing related to the Loan Management Core system as well as the Reporting Analytics environment that supports the full life cycle of Commercial Mortgage Loans. Responsibilities • Develop unit, system, and regression test plans, and effective strategies to allow for shorter and more frequent test cycles. • Develop and execute test plans for each type of reporting tool including SSRS, Tableau, PowerBI, PowerQuery and Cube testing to ensure output meets user requirements. • Design and development of test plans in support of all reporting requests following standard SDLC processes and iterative development cycles. • Support and execute User Acceptance Test cases working closely with Servicing and Asset Management teams to assist in completing User Acceptance Testing. • Support end to end testing of reporting data mart to ensure transformations of data meet end user requests. • Develop performance testing plans to speed up end user experience on reporting tools. • Create QA and testing artifacts (Test Strategy, Test Matrix, Test Scenarios, Test Cases and Test Results) and functional documentations. • Communicate test progress, test results and other relevant information to project stakeholders and management. • Assist with triage, diagnosis and resolution of issues discovered by Real Estate Business areas throughout User Acceptance. • Participate in special projects, providing testing data analytics as needed in support of end business users in real estate. SKILLS AND ABILITIES • Strong detailed analysis skills when troubleshooting bugs. • Strong business process flow knowledge • Strong written documentation skills focusing on testing guides to streamline test cases. • Intermediate SQL/Query Skills • Intermediate Knowledge of Business Intelligence tools including SSRS (Report Builder), Tableau, and Power BI • Intermediate Knowledge of SharePoint, Visio & Microsoft Access • Intermediate Knowledge of Excel, Word, and PowerPoint • Intermediate level of investigative, analytical, and problem-solving skills • Intermediate level of people management skills, demonstrating the ability to lead, mentor, and develop associates; including the ability to delegate key areas of responsibility. • Strong oral and written communication skills demonstrating ability to convey business terminology that is meaningful and well received. • Advanced ability to set goals and handle multiple tasks, clients, and projects simultaneously; Ability to appropriately balance priorities, deadlines, and deliverables. • Ability to quickly adapt to new methods, work under tight deadlines and stressful conditions. • Broad business knowledge, including knowledge of investments and\or financial lending. • Ability to work well within a team environment and participate in department/team projects. • Ability to balance detail with departmental goals/objectives. • Ability to liaise with individuals across a wide variety of operational, functional, and technical disciplines.

Requirements