Data Engineer at PitchBook Data

At PitchBook a Morningstar company we are always looking forward. We continue to innovate evolve and invest in ourselves to bring out the best in everyone. Were 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 theres going to be some ambiguity along the way but we excel when we challenge ourselves. Were 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: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 worlds best private market database and we recognize the importance of investing in our team members from day one. Thats 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 youre looking for a challenging and rewarding opportunity to take your career to new heights we invite you to join us at PitchBook.As a Data Engineer you will work across a global team of analysts and data operation associates to develop new data technologies for Data Operations at PitchBook. Were looking for a person who can combine proficiency in data engineering technologies (SQL Python R Tableau Power BI) with an operational mindset and deliver powerful new data processing tools to the team. You will also spend time learning PitchBooks data operations processes and methodologies establishing the process knowledge necessary to develop effective data solutions.Primary Job Responsibilities:Develop data pipelines that automate data sourcing and processingDevelop programs to synchronize technology and human-powered processesDesign and maintain database and data warehousing solutionsDevelop automated reports to monitor and track data pipelines (Power BI Tableau)Work alongside Data Operations teams to augment core technologiesServe as a data and engineering SME on cross-functional Data Operations initiativesSkills and Qualifications:Bachelors degree in Economics Business Finance Engineering Statistics Computer Science or related fields2 years of relevant experience working experience as a Data EngineerAdvanced SQL skills with experience querying large datasets from multiple sources and developing automated reportingIntermediate Python skills with experience in scripting web scraping optical character recognition data manipulation and extract transform and loadKnowledge of statistical methods and regression analysisProficiency in Tableau or Power BI (both is a plus)Excellent Microsoft Office/PC skills Advanced Excel experience analyzing data and creating daily weekly and monthly reportsAbility to display complex quantitative data in a simple intuitive format and to present findings in a clear and concise mannerCapable of investigating familiarizing and mastering new data sets quicklyExcellent interpersonal skills with the ability to communicate complex data issues correctly and clearly to both internal and external customersMust be authorized to work in the United States without the need for visa sponsorship now or in the futureBenefits Compensation at PitchBook:Physical Health Comprehensive health benefitsAdditional medical wellness incentivesSTD LTD AD&D and life insuranceEmotional HealthPaid 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 HealthMatching gifts programEmployee resource groupsSubsidized emergency childcareDependent Care FSACompany-wide eventsEmployee referral bonus programQuarterly team building eventsFinancial Health401k matchShared ownership employee stock programMonthly 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.CompensationAnnual base salary: $120000-$135450Target annual bonus percentage: 10%Working Conditions:At the heart of our company is a belief in the power of in-person collaboration. Being together in the office fuels our creativity strengthens our connections and drives the innovation that sets us apart. Our culture is built on spontaneous momentsthose hallway conversations whiteboard brainstorms and shared celebrations in each of our global officesthat simply cant be replicated remotely. This role is expected to be in the office 5 days a week.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. Its 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 weve 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-TK1#LI-Onsite Key Skills Apache Hive,S3,Hadoop,Redshift,Spark,AWS,Apache Pig,NoSQL,Big Data,Data Warehouse,Kafka,Scala Employment Type : Full Time Experience: years Vacancy: 1 Monthly Salary Salary: 120000 - 135450