Senior Data Engineer

Summary

Join PandaDoc as a Senior Data Engineer and contribute to building scalable data solutions that transform raw data into valuable business insights. You will design, develop, and maintain data pipelines within the Snowflake ecosystem, create and optimize dimensional data models, implement data quality checks, and collaborate with analytics teams. This role also involves mentoring junior team members, performing ETL/ELT development, optimizing data warehouse performance, and documenting data architectures.

Requirements

• 5+ years of experience in data engineering roles
• 3+ years of hands-on experience with Snowflake, including performance optimization
• Strong expertise in dimensional data modeling (star schema, snowflake schema)
• Proficiency in SQL and at least one programming language (Python preferred)
• Experience designing and implementing data pipelines using modern tools
• Knowledge of data warehouse concepts and best practices
• Proven experience with data transformation frameworks and tools

Responsibilities

• Design, develop, and maintain data pipelines within the Snowflake ecosystem
• Create and optimize dimensional data models following Kimball methodology
• Implement data quality checks and monitoring systems
• Collaborate with analytics teams to understand business requirements and translate them into technical solutions
• Mentor junior team members and promote best practices in data engineering
• Perform ETL/ELT development to integrate data from multiple sources
• Optimize data warehouse performance and manage cloud resources efficiently
• Document data architectures, models, and transformation processes

Preferred Qualifications

• Experience with dbt (data build tool)
• Familiarity with cloud platforms (AWS, Azure, or GCP)
• Experience with version control systems (Git) and CI/CD pipelines
• Understanding of data governance and security principles
• Experience with business intelligence tools (Tableau, Looker, Power BI)

Benefits

• Employees may be able to purchase company stock (or receive annual bonuses)
• Employees (and their families) may enroll in the company's medical, dental, vision, short & long term disability, life insurance, FSA and 401k plans
• Employees will also receive 13.34+ hours of paid time off per month, 6 self care days, birthday PTO day, and 10 company-paid holidays off per year