Data Engineer, Analytics Engineering

$125,000 - $150,000/Yr

Morningstar - Seattle, WA

Full-time - Mid Level

Seattle, WA

Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services

About the position

As a Data Engineer on the Enterprise Data Platform team at PitchBook, you will be responsible for building data pipelines, manipulating data into well-structured models for analysis, and ensuring data governance. This role emphasizes collaboration, customer empathy, and continuous improvement, allowing you to impact various areas of analytics and operational thinking across the organization.

Responsibilities

• Apply unified data technologies 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, load, and transform (ELT) processes and data modeling solutions
• Consistently evolve data processes and techniques following industry best practices
• Build data models for reports and dashboards to translate business data into insights and measure business KPIs
• 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

Requirements

• Bachelor's degree in a related field (Computer Science, Engineering, etc.)
• 2+ years of experience in data engineering roles, including creating and maintaining data pipelines, data modeling, and data architecture
• 3+ years of experience in advanced SQL, including expert-level skills in querying large datasets from multiple sources and developing automated reporting
• 2+ years of experience in Python, with skills for diverse components of data pipelines
• Expertise in ETL and 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)
• Proficiency in data storage solutions, data warehousing, and cloud-based data platforms (e.g. Snowflake)
• Knowledge and applicable working experience establishing and ensuring data governance, data quality, and compliance standards
• Exceptional problem-solving skills
• Excellent communication and collaboration skills with the ability to engage with non-technical stakeholders
• Experience working with enterprise technologies (CRM, ERP, Marketing Automation Platforms, Financial Systems, etc.) is a plus
• Proficiency with the Microsoft Office suite including in-depth knowledge of Outlook, Word, and Excel

Nice-to-haves

• Experience with enterprise technologies (CRM, ERP, Marketing Automation Platforms, Financial Systems, etc.) is a plus

Benefits

• Comprehensive health benefits
• Additional medical wellness incentives
• STD, LTD, AD&D, and life insurance
• 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
• Matching gifts program
• Employee resource groups
• Subsidized emergency childcare
• Dependent Care FSA
• Company-wide events
• Employee referral bonus program
• Quarterly team building events
• 401k match
• Shared ownership employee stock program
• Monthly transportation stipend