Associate Business Intelligence Analyst

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 PitchBook’s 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 analyse 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.
• 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.
• Bachelor’s degree from STEM fields such as Computer Science, Engineering, IT, Analytics, etc. Specialized training/certification and master’s degree preferred.
• Basic SQL skills a necessity and intermediate SQL skills 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
• Excellent 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, US shift and Indian holidays.

Morningstar is an equal opportunity employer

Morningstar's hybrid work environment gives you the opportunity to collaborate in-person each week as we've found that we're at our best when we're purposely together on a regular basis. In most of our locations, our hybrid work model is four days in-office each week. A range of other benefits are also available to enhance flexibility as needs change. No matter where you are, you'll have tools and resources to engage meaningfully with your global colleagues.