• Sourcing Reporting and Analytics Director Jobs in United States Of America - 25320286

  • Morgan Stanley Pvt Ltd
  • United States Of America, Usa
  • Save Job
  • 0 - 3 Years
  • Posted : above 1 month

Job Description:

Morgan Stanley is a leading global financial services firm providing a wide range of investment banking, securities, investment management and wealth management services The Firms 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

REM (Reengineering & Expense Management) works in close partnership with the businesses and support functions to identify and execute opportunities to manage expenses through strategic sourcing, demand management, process reengineering and procurement management REM leverages the Source-to-Pay process to create expense data transparency and ensure vendor contract compliance REM also manages our supplier relationships and our outsourcing risk

This is a reporting & data analytics role within REM The successful candidate will be responsible for delivering reporting solutions to stakeholders in Firmwide Sourcing and across the firm The candidate should have a strong technology-based skillset and business acumen with a focus on finding and creating efficiencies while delivering effective reporting & analytics This position will require a strong attention to detail, ability to multitask, and an understanding of expense management, invoicing, procurement and sourcing end to end processes

The reporting & data analyst is expected to provide daily/weekly/monthly/quarterly reporting deliverables in a fast paced and deadline driven environment The candidate will work closely with Firmwide Sourcing leadership in order to support negotiations, data quality assurance, data analytics and process automation initiatives The candidate is also responsible for producing KPIs (Key Performance Indicators) and metrics regarding savings, productivity and other performance measures

Responsibilities include
- Execution of daily ETL processes This includes the extraction, transformation and loading of datasets from multiple source systems, specifically; sourcing, contracts, accounts payable (BOXI), and other expense management and risk related tools
- Turn business requirements into solutions that drive meaningful reporting and analysis for stakeholders across Firmwide Sourcing and the firm
- Write complex queries for large volumes of data (joins, functions, sub queries, etc)
- Become a subject matter expert on the data model/structure in order to perform meaningful analysis and apply it to business needs
- Ensure all daily/weekly/monthly/quarterly reporting deliverables are completed on time
- Edit and create SQL stored procedures/views in order to generate the KPIs and metrics required by leadership
- Develop, modify and maintain visualizations and dashboards that are hosted on an in-house Tableau server (MSViz)
- Troubleshoot and perform root cause analysis; investigate discrepancies and gaps for issues arising from code errors, failing data connections or source system data quality
- Independently work with stakeholders for any ad hoc requests or modifications to existing reporting solutions and dashboards
- Find efficiencies with respect to database indexing, process automation and report execution
- Proactively monitor and manage ad-hoc and day to day tasks and document procedures that are easily replicable by other resources

Qualifications

Responsibilities include
- Execution of daily ETL processes This includes the extraction, transformation and loading of datasets from multiple source systems, specifically; sourcing, contracts, accounts payable (BOXI), and other expense management and risk related tools
- Turn business requirements into solutions that drive meaningful reporting and analysis for stakeholders across Firmwide Sourcing and the firm
- Write complex queries for large volumes of data (joins, functions, sub queries, etc)
- Become a subject matter expert on the data model/structure in order to perform meaningful analysis and apply it to business needs
- Ensure all daily/weekly/monthly/quarterly reporting deliverables are completed on time
- Edit and create SQL stored procedures/views in order to generate the KPIs and metrics required by leadership
- Develop, modify and maintain visualizations and dashboards that are hosted on an in-house Tableau server (MSViz)
- Troubleshoot and perform root cause analysis; investigate discrepancies and gaps for issues arising from code errors, failing data connections or source system data quality
- Independently work with stakeholders for any ad hoc requests or modifications to existing reporting solutions and dashboards
- Find efficiencies with respect to database indexing, process automation and report execution
- Proactively monitor and manage ad-hoc and day to day tasks and document procedures that are easily replicable by other resources

Profile Summary:

Employment Type : Full Time
Eligibility : Any Graduate
Industry : Financial Services/Stockbroking
Functional Area : Accounting/Tax/Company Secretary/Audit
Role : Cost Accounting/ ICWA
Salary : As per Industry Standards
Deadline : 03rd Jun 2020

Key Skills:

These free online tutorials may interest you

People who search this job also searched for the following Keywords

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status