Description

Position: Associate Business Intelligence Analyst Department: PitchBook Team Shift: Night Shift / Afternoon ( UK ) Night Shift - Shift timing of 8:30 PM - 5:30 PM IST UK shift - Shift timing of 2:30 PM - 11:30 PM IST How to Apply: Application Link (mandatory) Candidates need to visit the below link and submit their application failing which the application won't be considered: https://morningstar.wd5.myworkdayjobs.com/Americas/job/Mumbai/Business-Intelligence-Analyst_REQ-035443-1 The Team: PitchBook Data Operations team performs web-based research and utilizes technology tools to capture hard-to-find data on private capital markets including venture capital, private equity, and mergers and acquisitions (M&A). This information allows PitchBooks customers to discover emerging companies, conduct research on potential investment opportunities, and gain a competitive edge in investment decision-making and negotiations. The Role: The Associate Business Intelligence Analyst perform critical analysis and data support of all data operations at PitchBook. The role uses data to figure out trends, perform critical analysis and build data visualizations for Data Operations function at PitchBook. The Analyst will conduct thorough data analysis, help design and implement analytics programs, generate reports, and collaborate with various teams to ensure we are optimizing our resources and maximizing our output. The Analyst works closely with business and IT team to turn data into critical information and knowledge that can be used to make sound business decisions. Responsibilities: Work with a range of data and reporting technologies like SQL, Tableau and Power BI to help build, maintain and manage dashboards to power analytics for data-driven decision making Design and maintain SQL views, Power BI datasets, workspaces and reporting structures used to compile insights Build executive level reporting that displays complex quantitative data in a simple, intuitive format and to present findings in a clear and concise manner Interpret and analyze data from multiple sources, spot trends/anomalies/outliers, synthesize raw data and create models to test hypotheses Provide design support for development of business intelligence solutions, build an in-depth understanding of the business, and serve as the primary owner of new report requests Interpret business requirements and determines optimum BI solutions to meet business needs • Own reporting for daily, weekly and monthly business metrics, and the responsibility to communicate results and make recommendations to senior management Trains users and executives to use reports, metrics and action-oriented information correctly. Qualifications: Ability to work with a range of data and reporting technologies to build upon a strong foundation of rigor, quantitative techniques, and efficient processing Bachelors degree from STEM fields such as Computer Science, Engineering, IT, Analytics, etc. Specialized training/certification and masters degree preferred. Basic SQL skills a necessity and advanced SQL preferred, with experience querying large datasets from multiple sources and developing automated reporting R and/or Python skills for scripting, data manipulation, custom ETLs, statistical analysis Experience with BI/data visualization software programs such as Tableau or Microsoft Power BI is preferred Good analytical thinking and interpersonal skills, with the ability to communicate complex data issues correctly and clearly to both internal and external customers. Attention to detail. Ability to define and organize tasks, responsibilities & priorities. Willing and flexible to work on UK shift and Indian holidays

Role and Responsibilities

• Position: Associate Business Intelligence Analyst Department: PitchBook Team Shift: Night Shift / Afternoon ( UK ) Night Shift - Shift timing of 8:30 PM - 5:30 PM IST UK shift - Shift timing of 2:30 PM - 11:30 PM IST How to Apply: Application Link (mandatory) Candidates need to visit the below link and submit their application failing which the application won't be considered: https://morningstar.wd5.myworkdayjobs.com/Americas/job/Mumbai/Business-Intelligence-Analyst_REQ-035443-1 The Team: PitchBook Data Operations team performs web-based research and utilizes technology tools to capture hard-to-find data on private capital markets including venture capital, private equity, and mergers and acquisitions (M&A). This information allows PitchBooks customers to discover emerging companies, conduct research on potential investment opportunities, and gain a competitive edge in investment decision-making and negotiations. The Role: The Associate Business Intelligence Analyst perform critical analysis and data support of all data operations at PitchBook. The role uses data to figure out trends, perform critical analysis and build data visualizations for Data Operations function at PitchBook. The Analyst will conduct thorough data analysis, help design and implement analytics programs, generate reports, and collaborate with various teams to ensure we are optimizing our resources and maximizing our output. The Analyst works closely with business and IT team to turn data into critical information and knowledge that can be used to make sound business decisions. Responsibilities: Work with a range of data and reporting technologies like SQL, Tableau and Power BI to help build, maintain and manage dashboards to power analytics for data-driven decision making Design and maintain SQL views, Power BI datasets, workspaces and reporting structures used to compile insights Build executive level reporting that displays complex quantitative data in a simple, intuitive format and to present findings in a clear and concise manner Interpret and analyze data from multiple sources, spot trends/anomalies/outliers, synthesize raw data and create models to test hypotheses Provide design support for development of business intelligence solutions, build an in-depth understanding of the business, and serve as the primary owner of new report requests Interpret business requirements and determines optimum BI solutions to meet business needs • Own reporting for daily, weekly and monthly business metrics, and the responsibility to communicate results and make recommendations to senior management Trains users and executives to use reports, metrics and action-oriented information correctly. Qualifications: Ability to work with a range of data and reporting technologies to build upon a strong foundation of rigor, quantitative techniques, and efficient processing Bachelors degree from STEM fields such as Computer Science, Engineering, IT, Analytics, etc. Specialized training/certification and masters degree preferred. Basic SQL skills a necessity and advanced SQL preferred, with experience querying large datasets from multiple sources and developing automated reporting R and/or Python skills for scripting, data manipulation, custom ETLs, statistical analysis Experience with BI/data visualization software programs such as Tableau or Microsoft Power BI is preferred Good analytical thinking and interpersonal skills, with the ability to communicate complex data issues correctly and clearly to both internal and external customers. Attention to detail. Ability to define and organize tasks, responsibilities & priorities. Willing and flexible to work on UK shift and Indian holidays