Quality Assurance Business Intelligence Analyst, Real Estate Investments

Reinsurance Group of America, Incorporated•Chesterfield, MO

3d•$78,080 - $110,860•Hybrid

About The Position

The Quality Assurance Business Intelligence Testing Analyst position is an integral part of RGA Reinsurance Group of America's Real Estate Investments team. This role is responsible for all aspects of QA and testing related to the Loan Management Core system and the Reporting Analytics environment that supports the full life cycle of Commercial Mortgage Loans. Under limited supervision, the analyst will create and execute test plans, test scripts, and test cases using various tools to ensure the Real Estate systems function as designed. The position will also liaise with and support the user acceptance testing group, assisting with the triage, diagnosis, and resolution of identified issues. This position is based in Chesterfield and offers a hybrid work schedule.

Requirements

Bachelor’s degree in Computer Science, Mathematics or Equivalent related work experience
3+ years in QA Testing
3+ years in Business Intelligence and data warehousing areas
3+ years in programming and system analysis
3+ years using SQL Server
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.

Nice To Haves

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

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.