PitchBook
Sr. Data Engineer, Analytics Engineering
PitchBook, Seattle, Washington, us, 98127
At PitchBook, we are always looking forward. We continue to innovate, evolve, and invest in ourselves to bring out the best in everyone. We’re deeply collaborative and thrive on the excitement, energy, and fun that reverberates throughout the company.
Our extensive learning programs and mentorship opportunities help us create a culture of curiosity that pushes us to always find new solutions and better ways of doing things. The combination of a rapidly evolving industry and our high ambitions means there’s going to be some ambiguity along the way, but we excel when we challenge ourselves. We’re willing to take risks, fail fast, and do it all over again in the pursuit of excellence.
If you have a good attitude and are willing to roll up your sleeves 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 big thinkers, innovators, and problem solvers who strive to deepen the positive impact we have on our customers and our company every day. We value curiosity and the drive to find better ways of doing things. We thrive on customer empathy, which remains our focus when creating excellent customer experiences through product innovation.
As a Senior Data Engineer on the Enterprise Data Platform team, you are responsible for building data pipelines to ingest various source data from enterprise technologies and PitchBook Platform data, manipulating (cleanse, dedupe, normalize) data into well-constructed data models for data analysis, implementing business logic and standard calculations, governing (supporting, observing, documenting) the data, and making the data available to end consumers in the form of PitchBook data products built on top of our data warehouse / data lake (e.g. Snowflake). You’ll work with a range of data and reporting technologies (e.g. Python, Docker, Tableau, Power BI) to build upon a strong foundation of rigor, quantitative techniques, and efficient processing.
Primary Job Responsibilities:
Expert at building unified data technologies to support advanced and automated business analyticsDesign, develop, document, and maintain database and reporting structures used to compile insightsDefine, develop, and review extract, load, and transform (ELT) processes and data modeling solutionsConsistently evolve data processes and techniques following industry best practicesEstablish and help define reports and dashboards used to translate business data into insights, identify and prioritize operational improvement opportunities, and measure business KPIs against objectivesContribute to the ongoing improvement of quality assurance standards and proceduresMentor and guide less experienced data engineers, contributing to their professional developmentStay updated with the latest data engineering technologies and trends and share your insights with the teamSupport the vision and values of the company through role modeling and encouraging desired behaviorsParticipate in various company initiatives and projects as requestedSkills and Qualifications:
Bachelor's degree in a related field (Computer Science, Engineering, etc.)5+ years of experience in data engineering roles, including creating and maintaining data pipelines, data modeling, and data architecture5+ years of experience in data cleansing, governance, and quality/integrity5+ years of experience in advanced SQL, including expert-level skills in querying large datasets from multiple sources and developing automated reporting5+ years of experience in Python, with skills for diverse components of data pipelines, including scripting, data manipulation, custom extract, transform and loads, and statistical/regression analysisExpertise in extract, transform, and load (ETL) and extract, load, transform (ELT) processes and pipelines, platforms (e.g. Airflow), and distributed messaging (e.g. Kafka)Experience with tools that capture and control data modeling change management (e.g. SQLMesh)Experience building data alerting & notifications (e.g. on deviations, thresholds, etc.)Experience building and managing tools for data observability and documentation (e.g. DataLab)Proficient in data storage solutions, data warehousing, and cloud-based data platforms (e.g. Snowflake)Proficient in deploying data pipelines to a cloud-native, containerized deployment/delivery environment (e.g. Kubernetes)Knowledge and applicable working experience establishing and ensuring data governance, data quality, and compliance standardsExceptional problem-solving skills and a track record of designing and optimizing data pipelinesExcellent communication and collaboration skills with the ability to engage with non-technical stakeholdersExperience working with enterprise technologies (CRM, ERP, Marketing Automation Platforms, Financial Systems, etc.) is a plusProficiency with the Microsoft Office suite including in-depth knowledge of Outlook, Word, and Excel with the ability to pick up new systems and software easilyBenefits + Compensation at PitchBook:
Physical Health
Comprehensive health benefitsAdditional medical wellness incentivesSTD, LTD, AD&D, and life insuranceEmotional Health
Paid sabbatical program after four yearsPaid family and paternity leaveAnnual educational stipendAbility to apply for tuition reimbursementCFA exam stipendRobust training programs on industry and soft skillsEmployee assistance programGenerous allotment of vacation days, sick days, and volunteer daysSocial Health
Matching gifts programEmployee resource groupsSubsidized emergency childcareDependent Care FSACompany-wide eventsEmployee referral bonus programQuarterly team building eventsFinancial Health
401k matchShared ownership employee stock programMonthly transportation stipendPlease 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: $180,000-$200,000Target 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:
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.
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.
#J-18808-Ljbffr
Our extensive learning programs and mentorship opportunities help us create a culture of curiosity that pushes us to always find new solutions and better ways of doing things. The combination of a rapidly evolving industry and our high ambitions means there’s going to be some ambiguity along the way, but we excel when we challenge ourselves. We’re willing to take risks, fail fast, and do it all over again in the pursuit of excellence.
If you have a good attitude and are willing to roll up your sleeves 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 big thinkers, innovators, and problem solvers who strive to deepen the positive impact we have on our customers and our company every day. We value curiosity and the drive to find better ways of doing things. We thrive on customer empathy, which remains our focus when creating excellent customer experiences through product innovation.
As a Senior Data Engineer on the Enterprise Data Platform team, you are responsible for building data pipelines to ingest various source data from enterprise technologies and PitchBook Platform data, manipulating (cleanse, dedupe, normalize) data into well-constructed data models for data analysis, implementing business logic and standard calculations, governing (supporting, observing, documenting) the data, and making the data available to end consumers in the form of PitchBook data products built on top of our data warehouse / data lake (e.g. Snowflake). You’ll work with a range of data and reporting technologies (e.g. Python, Docker, Tableau, Power BI) to build upon a strong foundation of rigor, quantitative techniques, and efficient processing.
Primary Job Responsibilities:
Expert at building unified data technologies to support advanced and automated business analyticsDesign, develop, document, and maintain database and reporting structures used to compile insightsDefine, develop, and review extract, load, and transform (ELT) processes and data modeling solutionsConsistently evolve data processes and techniques following industry best practicesEstablish and help define reports and dashboards used to translate business data into insights, identify and prioritize operational improvement opportunities, and measure business KPIs against objectivesContribute to the ongoing improvement of quality assurance standards and proceduresMentor and guide less experienced data engineers, contributing to their professional developmentStay updated with the latest data engineering technologies and trends and share your insights with the teamSupport the vision and values of the company through role modeling and encouraging desired behaviorsParticipate in various company initiatives and projects as requestedSkills and Qualifications:
Bachelor's degree in a related field (Computer Science, Engineering, etc.)5+ years of experience in data engineering roles, including creating and maintaining data pipelines, data modeling, and data architecture5+ years of experience in data cleansing, governance, and quality/integrity5+ years of experience in advanced SQL, including expert-level skills in querying large datasets from multiple sources and developing automated reporting5+ years of experience in Python, with skills for diverse components of data pipelines, including scripting, data manipulation, custom extract, transform and loads, and statistical/regression analysisExpertise in extract, transform, and load (ETL) and extract, load, transform (ELT) processes and pipelines, platforms (e.g. Airflow), and distributed messaging (e.g. Kafka)Experience with tools that capture and control data modeling change management (e.g. SQLMesh)Experience building data alerting & notifications (e.g. on deviations, thresholds, etc.)Experience building and managing tools for data observability and documentation (e.g. DataLab)Proficient in data storage solutions, data warehousing, and cloud-based data platforms (e.g. Snowflake)Proficient in deploying data pipelines to a cloud-native, containerized deployment/delivery environment (e.g. Kubernetes)Knowledge and applicable working experience establishing and ensuring data governance, data quality, and compliance standardsExceptional problem-solving skills and a track record of designing and optimizing data pipelinesExcellent communication and collaboration skills with the ability to engage with non-technical stakeholdersExperience working with enterprise technologies (CRM, ERP, Marketing Automation Platforms, Financial Systems, etc.) is a plusProficiency with the Microsoft Office suite including in-depth knowledge of Outlook, Word, and Excel with the ability to pick up new systems and software easilyBenefits + Compensation at PitchBook:
Physical Health
Comprehensive health benefitsAdditional medical wellness incentivesSTD, LTD, AD&D, and life insuranceEmotional Health
Paid sabbatical program after four yearsPaid family and paternity leaveAnnual educational stipendAbility to apply for tuition reimbursementCFA exam stipendRobust training programs on industry and soft skillsEmployee assistance programGenerous allotment of vacation days, sick days, and volunteer daysSocial Health
Matching gifts programEmployee resource groupsSubsidized emergency childcareDependent Care FSACompany-wide eventsEmployee referral bonus programQuarterly team building eventsFinancial Health
401k matchShared ownership employee stock programMonthly transportation stipendPlease 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: $180,000-$200,000Target 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:
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.
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.
#J-18808-Ljbffr