Business Intelligence Analyst, Real Estate Investments

You desire impactful work.
 

You’re RGA ready

RGA is a purpose-driven organization working to solve today’s challenges through innovation and collaboration. A Fortune 500 Company and listed among its World’s Most Admired Companies, we’re the only global reinsurance company to focus primarily on life- and health-related solutions. Join our multinational team of intelligent, motivated, and collaborative people, and help us make financial protection accessible to all.

Business Intelligence Analyst – Real Estate Investments

Position Overview

ReCap is a wholly owned subsidiary of RGA Reinsurance Group of America, a leader in the global life reinsurance industry.

Position is an integral part of the ReCap Real Estate Investments team providing technological solutions to support the full life cycle of commercial mortgage loans and joint ventures. The Senior Analyst will be responsible for Analysis, Design and Development of a variety of BI Reporting Tools in support of the Real Estate Investment group.  Custom Data Extracts and Ad-hoc internal reporting creation will be required to support the data needs of the Real Estate Investment team. Additionally, this position will act as business reporting liaison to the IT Investment solution team. Ensures department alignment and coordination with all other areas of the company to achieve corporate business strategies and vision.

Responsibilities

·Participate and elicit business requirements for reporting and dashboard design and translate these requirements into technical specifications. Conducts structured walk throughs of requirements with business and project team members.

·Design and Development of Canned, Custom and Ad-hoc Commercial Mortgage Loan reports to support the Origination, Underwriting, Asset Management, Accounting and Servicing groups utilizing in house BI reporting tools including SSRS, Power Queries, Power Pivots and Cube Reporting.

·Design and Development of Tableau and Power-BI Dashboards reports to support both the Real Estate and Investment areas.

·Analyze and extract Commercial Mortgage Loan data to support key performance information, trends, data audits as well as portfolio management data analytics.

·Identify Business opportunities to improve and streamline operational processes through technology solutions.

·Participate in special projects resulting from new business activities that require data to be on-boarded into commercial mortgage loan and join venture systems.

·Design and Development of Test Plans in support of all reporting requests following standard SDLC processes.

·Develop and update report documentation and utilize reporting deployment tools to migrate reporting tools through multiple environments.

·Train Real Estate business users on the Commercial Mortgage Loan Reporting environment in support of self-service reporting model.

·Assesses current data use of the Commercial Mortgage Loan system and provides continuing performance improvements to best utilize tool to determine any data clean-up required, working closely with IT investment solutions teams.

·Assist with coordination and facilitation of SOX and internal audit testing for the Real Estate and Mortgage Loan area providing audit reporting as determined.

·Trains and mentors’ other members of team in reporting and analytics

Requirements

Education and Experience

Required:  

• Bachelor’s Degree in Computer Science or equivalent related work experience
• 5+ years in Business Intelligence and data warehousing areas
• 5+ years in programming and system analysis

Preferred: 

• Experience in Commercial Real Estate Finance
• Working knowledge of Loan Management Systems  

SKILLS AND ABILITIES

Required: 

• Advanced Knowledge of Business Intelligence tools including SSRS, SSAS (Multi-dimensional and Tabular), DAX and SSIS
• Advanced SQL/Query Skills
• Advanced Knowledge of SharePoint, Visio & Microsoft Access
• Intermediate Knowledge of Tableau  & Power BI
• Intermediate Knowledge of Excel, Word, and PowerPoint
• Intermediate level of people management skills, demonstrating the ability to lead, mentor, and develop associates; including the ability to delegate key areas of responsibility
• Advanced level of investigative, analytical, and problem-solving skills
• Advanced oral and written c