Oh Snap!
This job is no longer active - but you can still view the details below.

Data Engineer, Business Intelligence

| Seattle

In just a little over a decade, PitchBook has grown into a global organization with offices in Seattle, San Francisco, New York and London. With consistent high double-digit growth since 2009, the company has become the industry’s leading source of private market data, serving more than 3,000 clients around the world.

As a four-time winner of the Best Workplaces in Washington award, PitchBook is committed to fostering an open, collaborative work environment driven by excellence, inclusion and fun. Our culture is at the heart of our success, and it’s something we work on every day.

Our primary home for the last decade, PitchBook’s Seattle office has grown from humble beginnings in a 200-square-foot windowless room to our current three-floor home in a downtown skyscraper. Located just blocks away from Pike Place Market and historic Pioneer Square, our headquarters boast stunning mountain views, open collaboration spaces and a startup culture that emphasizes hard work and camaraderie. Working in our Seattle office means growing your career alongside smart, dedicated people in the city where it all began.

The PitchBook Business Intelligence team embraces this data driven ethos by delivering key analytics and insights internally to every facet of our business. Our work is manifested as tools and data to help the enterprise grow and run more efficiently, at both strategic and tactical levels. Simply put, we believe that the data we build, across many sources, is our competitive advantage for making the most of our resources while we bring the most compelling product possible to market. 

To that end, as our scope of data integration and analysis expands, so do the needs of the BI team. We’re looking for a person with the ability to work with a range of data and reporting technologies (eg Python, R, Tableau, Power BI) in order to build upon a strong foundation of rigor, quantitative techniques and efficient processing. The Data Engineer will join other Engineers and Analytics professionals as part of the team that develops data pipelines and insights for our internal stakeholders across Sales, Customer Success, Marketing, Research, Product, Finance, and Administration. 

Responsibilities

  • You’ll be PitchBook’s expert at building unified data tech to support advanced and automated business analytics.
  • Design, develop, document and maintain database and reporting structures used to compile insights.
  • Define, develop and review ETL processes and data modeling solutions.
  • Consistently evolve data processes and techniques in accordance with industry best practices.
  • Establish and help define reports and dashboards used to translate business data into insights, identify and prioritize operational improvement opportunities, and measure business performance against objectives.
  • Contribute to ongoing improvement of quality assurance standards and procedures.

Qualifications

  • Bachelor's degree in Economics, Business, Finance, Engineering, Statistics, Computer Science or related fields, or related work experience
  • 2 years of relevant experience working experience as a business analyst, business intelligence engineer, or equivalent
  • Understanding of advanced data warehousing concepts and track record of applying these concepts on the job
  • Advanced SQL skills, with experience querying large datasets from multiple sources and developing automated reporting
  • R and/or Python skills for scripting, data manipulation, custom ETLs, statistical/regression analysis particularly as they apply to sales and marketing operations and performance
  • Experience with BI software programs, such as Tableau or Microsoft Power BI
  • Excellent Microsoft Office/PC skills, Advanced Excel experience analyzing data and creating daily/weekly/monthly reports
  • Ability to display complex quantitative data in a simple, intuitive format and to present findings in a clear and concise manner
  • Capable of investigating, familiarizing and mastering new data sets quickly
  • Excellent interpersonal skills, with the ability to communicate complex data issues correctly and clearly to both internal and external customers

Preferred Qualifications

  • Experience with Google Analytics/Omniture, SalesForce, Marketo APIs
  • Experience with Amazon Web Service and/or Microsoft Azure
  • Experience with multi-touch attribution
  • Experience with presenting actionable insights to business stakeholder

Company Overview

At PitchBook, we work tirelessly to arm professionals within the global VC, PE and M&A industries with the finest data, technology and service so they can make the most informed business decisions efficiently. This is accomplished through our award-winning product, the PitchBook Platform, along with a powerful suite of integrated tools to meet the diverse data-driven needs of our clients. It’s a very collaborative, client-focused environment with a culture that is driven toward excellence and getting things done.

If you are ready to start the conversation about how you might contribute to all the happenings at PitchBook, submit your resume today! PitchBook appreciates and respects diversity, and as such, we are an equal opportunity employer.

 

Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • ScalaLanguages
    • SqlLanguages
    • SwiftLanguages
    • ReactLibraries
    • AngularJSFrameworks
    • FlaskFrameworks
    • Node.jsFrameworks
    • SpringFrameworks
    • CassandraDatabases
    • Maria DBDatabases
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • MySQLDatabases
    • PostgreSQLDatabases
    • SQLiteDatabases
    • RedshiftDatabases
    • Google AnalyticsAnalytics
    • OptimizelyAnalytics
    • heapAnalytics
    • AxureDesign
    • InVisionDesign
    • SketchDesign
    • zeplinDesign
    • principleDesign
    • AsanaManagement
    • ConfluenceManagement
    • JIRAManagement
    • SmartsheetManagement
    • TrelloManagement
    • WistiaCMS
    • CerosCMS
    • UnbounceCMS
    • SalesforceCRM
    • HighspotCRM
    • BizableCRM
    • OutreachEmail
    • MarketoLead Gen
    • Sprout SocialLead Gen
    • Chili PiperLead Gen

Location

901 5th ave, Seattle, WA 98164

An Insider's view of PitchBook

What are some social events your company does?

As the (unofficial) social chair of the outside sales team, I’ve gotten to plan a ton of awesome events, from group pedicures to rooftop happy hours to rock climbing. We also do incentive trips. My favorite was rafting down the Colorado River through the Moab Desert in Utah.

Cindy

Sr. Business Development Manager

What does your typical day look like?

As a UX Designer, I constantly discover user needs that enlighten a feature experience I'm creating. For a tool like PitchBook, there are a lot of different users to deeply understand. I wield the power of pen & paper, research and testing, design software, awesome collaborators, cups of coffee, and conversation to empathize and build with users.

Marissa

User Experience Designer

How does the company support your career growth?

PitchBook made it a priority to support my growth by understanding my aspirations and aligning a plan to get me there. My vision was to be in a leadership position and PitchBook motivated me to achieve this by providing me with tremendous resources, guidance, and opportunities to push myself and succeed.

Nitin

Manager, West Coast Customer Success Development

How do you collaborate with other teams in the company?

I work on the accounts receivable team at PitchBook, which involves extensive collaboration with other teams to obtain and update client billing information, reconcile expenses and complete compliance forms. My role requires me to work closest with customer success and outside sales to improve processes for invoicing and error prevention.

Lewis

Accounts Receivable Specialist

What are PitchBook Perks + Benefits

PitchBook Benefits Overview

Health and wellness: We offer health and life insurance, generous time off and paid parental leave, retirement plans with a substantial company contribution, transportation assistance and more.

Career development: We offer VC, PE and M&A industry training, tuition reimbursement programs, annual education stipend, and more.

Good vibes: We offer an open work environment, team-building and company-wide events, sponsored volunteer opportunities, referral bonuses and more.

Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Onsite Gym
Retirement & Stock Options Benefits
401(K) Matching
Vacation & Time Off Benefits
Generous PTO
Paid Volunteer Time
Sabbatical
Paid Holidays
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Game Room
Recreational Clubs
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Diversity Program
More Jobs at PitchBook17 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Marketing
Operations
Product
Project Mgmt
Sales
Content
Content
new
Seattle
Design + UX
new
Seattle
Marketing
new
Seattle
Operations
new
Seattle
Operations
new
Seattle
Product
new
Seattle
Finance
new
Seattle
Product
new
Seattle
Content
new
Seattle
Project Mgmt
new
Seattle
Data + Analytics
new
Seattle