Data Engineer, Business Intelligence at PitchBook

| Seattle
Sorry, this job was removed at 12:11 p.m. (PST) on Wednesday, March 11, 2020
Find out who's hiring in Seattle.
See all Data + Analytics jobs in Seattle
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

At PitchBook we work to provide global professionals with comprehensive data on the entire venture capital, private equity and M&A landscape so they can discover and execute opportunities with confidence. We credit our success and rapid growth to our cutting-edge products, customer centered attitude and ability to embrace and drive change.

In just over a decade, PitchBook has reached over 1,000 global employees with offices worldwide, and we're not slowing down! Consistently recognized as a Best Place to Work, our culture is at the heart of our success and is driven by excellence, inclusion and fun. At PitchBook we're committed to fostering an open and collaborative work environment.

About the Role:

PitchBook's mission is to deliver value to customers through our industry leading platform of private and public equity marketplace data. Our customers rely on this data, peerless in its quality, comprehensiveness and insight, every day to make critical decisions about their business interests across the equity markets.

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 built 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. 

Primary Job 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.

Skills and Qualifications:

  • Bachelor's degree in Economics, Business, Finance, Engineering, Statistics, Computer Science or related fields
  • 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 open source data pipeline frameworks such as: Airflow, Luigi, etc.
  • Experience with Amazon Web Services and/or Microsoft Azure
  • Experience with Snowflake development and cloud data warehousing
  • Experience with a version control system such as Git
  • Experience with presenting actionable insights to business stakeholders

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
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

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
    • BizibleCRM
    • OutreachEmail
    • MarketoLead Gen
    • Sprout SocialLead Gen
    • Chili PiperLead Gen

Location

Located just blocks away from Pike Place Market and historic Pioneer Square, our headquarters boast stunning mountain views

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?

UX Designers at PitchBook actively work on one main project at a time, but could be supporting multiple projects in development. I usually spend some time each day answering any questions that our development team has on in-flight projects and iterating designs if necessary. Every day is different as I’m constantly solving new problems.

Nitaya

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 your team's ideas influence the company's direction?

One of PitchBook’s core values is to embrace and drive change, which in turn promotes a scrappy, entrepreneurial working style and allows individual contributions to influence the direction of the company. We see examples of this every day from launching a weekend version of our newsletter to optimizing customer onboarding processes.

Amy

VP of HR

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.

Culture
Volunteer in local community
Partners with Nonprofits
Friends outside of work
Eat lunch together
Intracompany committees
Daily stand up
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Pair programming
Open office floor plan
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Onsite Gym
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Performance Bonus
Match charitable contributions
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Family Medical Leave
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
Some Meals Provided
Happy Hours
Recreational Clubs
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Diversity Program
Lunch and learns
Cross functional training encouraged
Promote from within
Mentorship program
Continuing Education stipend
Time allotted for learning
Customized development tracks
More Jobs at PitchBook6 open jobs
All Jobs
Finance
Operations
Sales
Operations
new
Seattle
Operations
new
Seattle
Finance
new
Seattle
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView PitchBook's full profileSee more PitchBook jobs