Associate Business Intelligence Analyst

About the Role

The Associate Business Intelligence Analyst will perform critical analysis and data support for all data operations at PitchBook. This role uses data to identify trends, perform critical analysis, and build data visualizations for the Data Operations function. The Analyst will conduct thorough data analysis, help design and implement analytics programs, generate reports, and collaborate with various teams to optimize resources and maximize output. The Analyst works closely with business and IT teams to turn data into critical information and knowledge for sound business decisions.

Key Responsibilities

• Work with a range of data and reporting technologies like SQL, Tableau, and Power BI to help build, maintain, and manage dashboards 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 presents findings clearly and concisely.
• Interpret and analyze data from multiple sources, spot trends/anomalies/outliers, synthesize raw data, and create models to test hypotheses.
• Provide design support for the 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 determine optimum BI solutions to meet business needs.
• Train users and executives to use reports, metrics, and action-oriented information correctly.

Requirements & Tech Stack

• Ability to work with a range of data and reporting technologies to build upon a strong foundation of rigor, quantitative techniques, and efficient processing.
• Basic SQL skills are a necessity, and intermediate SQL skills are preferred, with experience querying large datasets from multiple sources and developing automated reporting.
• R and/or Python skills for scripting, data manipulation, custom ETLs, and 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, and priorities.
• Willing and flexible to work on UK shift, US shift, and Indian holidays.

Qualifications

• Bachelor’s degree from STEM fields such as Computer Science, Engineering, IT, Analytics, etc.
• Specialized training/certification and a master’s degree are preferred.