Associate Data Engineer

About the Role:

At PitchBook, we believe that the Data Operations team plays a vital role in setting us apart from our competitors. We take immense pride in providing top-quality data to our customers, while also being accountable, collaborative, and receptive to feedback. Our team members are highly engaged, detail-oriented, and always eager to learn and grow as our industry evolves.

Our reputation for excellence is a direct result of our deep commitment to building the world's best private market database, and we recognize the importance of investing in our team members from day one. That's why we offer specialized training and a mentorship program that is tailored specifically to the needs of the Data Operations team.

We value and celebrate the diverse perspectives, talents, and experiences of our team members and recognize the importance of building trust and strong cross-functional partnerships. If you're looking for a challenging and rewarding opportunity to take your career to new heights, we invite you to join us at PitchBook.

As an Associate Data Engineer, you will work across a global team of analysts and Data Operations Associates to develop new data technologies for Data Operations at PitchBook. We're looking for a person who can combine proficiency in data engineering technologies (SQL, Python, AWS, Data Warehousing & ETL tools, Power BI) with an operational mindset and deliver powerful new data sourcing and processing tools to the team. You will be responsible for extracting data from external sources and working alongside senior members of the team to build out the infrastructure necessary to operationalize the data. You will also spend time learning PitchBook's data operations processes and methodologies, establishing the process knowledge necessary to develop effective data solutions.

Primary Job Responsibilities:

• Automate collection of data from various sources, including web scraping, API requests, etc.
• Develop data extraction pipelines by leveraging OCR technology and translations, processing structured and unstructured data
• Create data entry automation pipelines to import and edit mass volumes of data points
• Work with Data Engineers to build complex data pipelines that automate data sourcing and processing
• Develop programs to synchronize technology and human-powered processes (human in the loop)
• Collaborate with senior team members to design and maintain database and data warehousing solutions
• Play a key role in continuing to build out a newly formed data engineering function in the department
• Work alongside Data Operations teams to augment core technologies
• 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 related field (such as Data Engineering, Information Systems, Statistics, or Computer Science)
• 1-3 years of relevant experience working in Data Engineering, ETL development, or software engineering with exposure to ELT pipelines, workflow automation, and API development. Ideally in a fintech, financial data, or research-driven company
• 1+ year of Python skills with experience in web scraping, OCR, REST APIs, and data manipulation
• 2+ years of SQL skills, with experience querying large datasets from multiple sources and optimizing SQL queries for relational databases like PostgreSQL, Snowflake etc.
• Familiarity with software engineering best practices (e.g. unit testing, code reviews, design, continuous delivery, git, test automation, and build\deploy systems)
• Hands on experience with at least one cloud platform (AWS, Azure, GCP) and one cloud data warehouse (Snowflake, Redshift, BigQuery, etc.)
• Familiarity with workflow orchestration tools such as Airflow
• Proficiency in data visualization tools such as Tableau or Power BI
• Excellent Microsoft Office/PC skills and advanced Excel experience analyzing data and creating daily/weekly/monthly reports
• Ability to display complex quantitative data in a simple and intuitive format and to present findings in a clear and concise manner
• Capable of investigating, familiarizing, and mastering new data sets quickly
• Ability to manage multiple projects/tasks at once
• Excellent interpersonal skills with the ability to communicate complex data issues correctly and clearly to both internal and external customers
• Experience with event-driven architecture and real-time data processing preferred
• Knowledge of data governance, security, and compliance best practices preferred
• Familiarity with machine learning workflows and AI-driven data extraction preferred
• Proficiency with the Microsoft Office suite including in-depth knowledge of Outlook, Word, and Excel with the ability to pick up 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 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: $84,000-$114,000
• Target annual bonus percentage: 7.5%

*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:

We believe our business and our culture are strongest when we work together in person. We also know that it's helpful to have some flexibility to work remotely. Most roles work in the office 3+ days/week, and some are expected to work in the office 4-5 days/week. The current expectation for this role is that you are working in the office 3+days/week and that you are in the office full-time during the training period, for which the length varies by role. During an initial phone screen, the team will discuss expectations for this specific position.

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-AD2