Corporate Services Business Intelligence Analyst

  • Competitive
  • New York, NY, USA
  • Permanent, Full time
  • Morgan Stanley USA
  • 20 Apr 19

Corporate Services Business Intelligence Analyst

Company Profile
Morgan Stanley is a leading global financial services firm providing a wide range of investment banking, securities, investment management and wealth management services. The firm's employees serve clients worldwide including corporations, governments and individuals from more than 1,200 offices in 43 countries.

As a market leader, the talent and passion of our people is critical to our success. Together, we share a common set of values rooted in integrity, excellence and strong team ethic. Morgan Stanley can provide a superior foundation for building a professional career -- a place for people to learn, to achieve and grow. A philosophy that balances personal lifestyles, perspectives and needs is an important part of our culture.

Department Profile
Corporate Services provides a robust portfolio of global services utilized daily across the firm to enable productivity, efficiency, safety, optimized business models and an enhanced employee experience in the workplace. We have over 5,000 staff managing a multi-billion dollar scope of services including Real Estate and Location Strategy; Real Estate Portfolio and Transaction Management; Property Management; Corporate Travel; Corporate Security & Investigations; Corporate Information Management; and Regional Client Services; and Office of the COO.

The Business Intelligence Analyst will support the development of the Global BI Data & Analytics platform within the Morgan Stanley's Real Estate and Location Strategy group. They will work directly with subject matter experts (SMEs) to develop and maintain dashboard reporting and business analytics. They will assist in the development of dashboard modules within the BI tool kit that provides end users with relevant metrics and analytics to manage the corporate real estate portfolio. In addition to technical responsibilities, the ability to work on a team, in a highly collaborative environment is required. The ability to communicate with stakeholders is also required. An understanding of corporate real estate is preferred.


- 5-8 years' professional experience
- Ability to analyze data, determine trends and develop metrics
- Design, develop and implement Business Intelligence (BI) solutions under the direction of the BI Manager
- Extract data from databases and data warehouses
- Standardize data collection by developing methods for database design and validation reports
- Create QA test cases/test steps to ensure data integrity across all performance-based metrics and quality assurance of BI output
- Work with end users to ensure user acceptance testing and a complete delivery of reporting/analysis solution
- Statistical knowledge and/or Six Sigma expertise
- Work with IT to identify and import new data into the Corporate Services' data warehouse
- Build prototypes for demonstration and illustration purposes for peer groups and partners
- Collaborate with others regarding data/table structures to optimize Tableau Dashboards and other self-service needs
- Improve current processes and develop efficiencies by applying best practices
- Ability to meet deadlines, prioritize work and handle multiple tasks
- Ability to work independently as well as in a team environment
Technical Skills:
- Highly skilled in developing Tableau dashboards
- VBA programming, PIVOT table development, and in-depth knowledge of EXCEL functions and formulas
- Proficient in the use of Structured Query Language (SQL), BOXI, and other reporting tools
- Strong PC skills, particularly spreadsheet (Excel) and presentation (PowerPoint) expertise
Communication Skills:
- Build, document, and communicate user requirements
- Interpret and communicate information for consumption by a non-technical audience
- Clearly communicate and drive discussions on data structure with business and technology partners
- Document and communicate technical specifications to ensure database queries and final deliverables are understood
- Effective written and verbal communication skills