Data Engineer

At PitchBook, we are always on the move. We continuously innovate, evolve and invest in ourselves to extract the best from everyone. We thrive on deep collaboration and the excitement, energy and fun that resonates throughout the company. Our extensive learning programs and mentorship opportunities help us cultivate a culture of inquisitiveness that compels us to continually find new solutions and better ways of doing things. The amalgamation of a swiftly transforming industry and our lofty ambitions means there will be some ambiguity, but we thrive when we push ourselves. We are ready to take risks, fail quickly, and do it all over again in the pursuit of excellence. If you have a positive attitude and are ready to get your hands dirty to get things done, PitchBook is the place for you. About the role: As a member of the Product and Engineering team at PitchBook, you will be part of a team of grand thinkers, innovators and problem solvers who strive to increase the positive impact we have on our customers and our company each day. We value curiosity and the determination to find better ways of doing things. We thrive on empathy towards customers, which remains our focus when creating excellent customer experiences through product innovation. We understand that greatness is achieved through collaboration and diverse points of view, so we work closely with partners worldwide. As a team, we trust each other's intent in words and actions, value constructive discussions and foster a respectful working environment built on integrity, growth and business value. We heavily invest in our people, who are keen to learn and improve continually. Join our team and grow with us! The demands of the Business Intelligence team are growing as our scope of data integration and analysis expands. We are seeking someone capable of working with a variety of data and reporting technologies (e.g., Python, Docker, Tableau, Power BI) to build on a robust 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: - 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 extract, transform and load processes and data modeling solutions. - Consistently evolve data processes and techniques according to 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 the ongoing improvement of quality assurance standards and procedures. - 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. - 2+ years of relevant work experience in creating and maintaining data pipelines and architecture. - Understanding of advanced data warehousing concepts, data modeling and extract, transform and load development. - Advanced SQL skills with experience in 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 especially, as they apply to sales and marketing operations and performance. - Experience with software programs, such as Tableau, Microsoft Power BI, Docker, Linux, and Postgres. - 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. - Experience with presenting actionable insights to business stakeholders. - Experience with: Airflow, Luigi, Amazon Web Services, Microsoft Azure, Git, Postgres, Debezium, and Kafka is preferred. - Experience with Snowflake development and cloud data warehousing is preferred. - Proficiency with the Microsoft Office suite including in-depth knowledge of Outlook, Word and Excel with the ability to adapt to new systems and software easily. 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 child care - Dependent Care FSA - Company-wide events - Employee referral bonus program - Quarterly team building events Financial Health - 401k m