Data Modeling Analyst jobs in Seattle, WA

About the Role:

As a member of the Editorial team, you will spend each day immersed in the private markets, aiming to help our customers be better investors, advisors, and market participants. The work you will do plays a direct role in the evolution of the industry!  

Everyone on our team is supported by a flexible work environment and a culture that promotes curiosity, collaboration, and professional development. We prioritize recognition and respect across all roles and have a high level of camaraderie. The fast-growing nature of our organization provides ample opportunity to advance in your career and explore what interests you.  

As we continue investing in the talent of our group, our coverage has evolved rapidly over multiple industries and geographies. Our insights are routinely cited by top-tier publications and sought after by prominent players in the financial markets. In addition to publishing timely market insights, we also partner closely with our Product, Engineering, and Data Operations teams to continually enhance our datasets and develop unique tools that have a material impact on our customers’ workflows. There is no better time to join us!  

The Senior Data Analyst with a focus on performance analytics works with a wide range of data and reporting technologies (i.e., Python, Tableau, Power BI, Mixpanel) to build a strong foundation of rigor, quantitative techniques, and efficient processing. They perform critical analysis and data support for all business aspects across the Editorial department. The Senior Data Analyst delivers tools and data to help the enterprise grow and run more efficiently at both strategic and tactical levels. 

Primary Job Responsibilities:

• Act as the business intelligence expert for the Research, Editorial, and Media Sales businesses, setting the foundation for data-driven insights to optimize these programs 
• Present findings and recommendations to stakeholders regularly 
• Design and maintain database and reporting structures used to compile insights 
• Serve as the primary owner of business queries 
• Establish and help define KPI dashboards used to translate web analytics data into insights and evaluate the performance of editorial products 
• Interpret data from multiple sources, spot trends/anomalies/outliers, synthesize raw data, and create models to test hypotheses and AB testing frameworks 
• Own reporting for daily, weekly, and monthly business metrics delivered to senior management team and assist in business assessment and decision-making 
• Support the vision and values of the company through role modeling and encouraging desired behaviors 
• Participate in various company initiatives and projects as requested 

Skills and Qualifications:

• Bachelor’s degree in Economics, Business, Finance, Engineering, Statistics, Computer Science, or related fields 
• 5 years of relevant experience working as a data analyst, business analyst, business intelligence engineer, or equivalent 
• Advanced SQL skills, with experience querying large datasets from multiple sources and developing automated reporting 
• Python skills for scripting, data manipulation, custom extract, transform, and loads, and statistical/regression analysis, particularly as they apply to editorial operations and performance 
• Experience with business intelligence software programs, such as Oracle, Tableau, or Microsoft Power BI 
• Excellent Microsoft Office/PC skills, particularly advanced Excel experience analyzing data and creating daily, weekly, and monthly reports 
• Ability to display complex quantitative data in a simple, intuitive format and to present findings clearly and concisely 
• Capable of investigating, familiarizing, and mastering new datasets quickly 
• Attention to detail to spot inconsistencies, errors, and trends across multiple analytical tools 
• Excellent interpersonal skills with the ability to communicate complex data issues correctly and clearly to both internal and external customers 
• Experience with Google Analytics/Omniture, Salesforce, and Marketo APIs 
• Experience with Amazon Web Service and/or Microsoft Azure 
• Experience with CRMs (Salesforce) and Marketing Automation platforms (Marketo) 
• Experience with multi-touch attribution

Benefits Compensation at PitchBook:

Physical Health            

• Comprehensive health benefits
• Additional medical wellness incentives 
• STD, LTD, AD&D, and life insurance

Emotional Health 

• Paid sabbatical program after four years
• Paid family and paternity leave 
• Annual educational stipend
• Ability to apply for tuition reimbursement
• CFA exam stipend 
• Robust training programs on industry and soft skills 
• Employee assistance program
• Generous allotment of vacation days, sick days, and volunteer days 

Social Health 

• Matching gifts program
• Employee resource groups
• Subsidized emergency childcare  
• Dependent Care FSA
• Company-wide events
• Employee referral bonus program  
• Quarterly team building events

Financial Health 

• 401k match
• Shared ownership employee stock program 
• Monthly transportation stipend  

*Please be aware the above PitchBook benefit and perk offerings are subject to corresponding plan and policy documents and may change during the course of your employment.

Compensation

• Annual base salary: $75,300-$115,000
• Target annual bonus percentage: 10%

*Starting pay will be based on several factors and commensurate with qualifications & experience. We also have a location-based compensation structure; there may be different ranges for candidates by location. 

Working Conditions:

The job conditions for this position are in a standard office setting. Employees in this position use PC and phone on an on-going basis throughout the day. Limited corporate travel may be required to remote offices or other business meetings and events.

Life At PB:

We are consistently recognized as a Best Place to Work and our culture is at the heart of our success. It’s our fundamental belief that people do and create great things and that people are the cornerstone of prosperity. We believe that proactively seeking out different points of view, listening to others, learning, and reflecting on what we’ve heard creates a sense of belonging within PitchBook and strengthens the PitchBook community.

We are excited to get to know you and your background. Concerned that you might not meet every requirement? We encourage you to still apply as you might be the right candidate for the role or other roles at PitchBook.

#LI-EO1