Skip to content

Sr. Data Engineer – Analytics Engineering
Company | PitchBook |
---|
Location | Seattle, WA, USA |
---|
Salary | $180000 – $200000 |
---|
Type | Full-Time |
---|
Degrees | Bachelor’s |
---|
Experience Level | Senior |
---|
Requirements
- 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 architecture
- 5+ years of experience in data cleansing, governance, and quality/integrity
- 5+ years of experience in advanced SQL, including expert-level skills in querying large datasets from multiple sources and developing automated reporting
- 5+ 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 analysis
- Expertise 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 and 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 standards
- Exceptional problem-solving skills and a track record of designing and optimizing data pipelines
- Excellent communication and collaboration skills with the ability to engage with non-technical stakeholders
Responsibilities
- Expert at building 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
- Establish and help define reports and dashboards used to translate business data into insights, identify and prioritize operational improvement opportunities, and measure business KPIs against objectives
- Contribute to the ongoing improvement of quality assurance standards and procedures
- Mentor and guide less experienced data engineers, contributing to their professional development
- Stay updated with the latest data engineering technologies and trends and share your insights with the team
- Support the vision and values of the company through role modeling and encouraging desired behaviors
- Participate in various company initiatives and projects as requested
Preferred Qualifications
- Experience working with enterprise technologies (CRM, Enterprise Resource Planning, Marketing Automation Platforms, Financial Systems, etc.) is a plus
- 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