Senior Data Engineer

Overview

Job Description

Responsibilities

• - Dive into our Redshift warehouse, dbt models, and workflows
• - Start building your mental model for the current state by evaluating the CRM data lifecycle
• - Collaborate with data and engineering to understand pain points around source data sprawl, schema constraints, deprecated artifacts, etc.
• - Provide recommendations and a roadmap for prioritized next steps
• - Refine and start implementing your design for source extraction and warehouse ingestion
• - Collaborate with the data team to build an audit feedback loop with business to enforce integrity around identity resolution, hierarchies, and entity relationships
• - Complete the implementation of the CRM source extraction/ingestion project and use the learnings to refine your approach in preparation for other, similar initiatives

Required Skills

• - Strong command of SQL, including DDL and DML
• - Understanding of transaction control, concurrency, and access patterns for column vs. row-stores
• - Proficient in Python to understand where and when it should be used, and to apply it accordingly
• - Strong understanding of DBMS internals, including an appreciation for platform-specific nuances
• - A willingness to work with Redshift and deeply understand its nuances
• - Familiarity with our key tools (Redshift, Segment, dbt, github)
• - 8+ years in data, with at least 3 years specializing in Data Engineering
• - Proven track record managing and optimizing OLAP clusters
• - Experience refactoring problematic data pipelines without disrupting business operations
• - History of implementing data quality frameworks and validation processes

Benefits

• - Profit Sharing
• - Kit equity
• - 401k with a 5% match
• - We cover up to $1,950 per month toward medical premiums, with dental and vision premiums fully covered
• - Health Insurance plans through Aetna
• - $4,000 equipment allowance for your first two years, $3,000 budget every following two years
• - Individual learning + development budget ($3,500/year)
• - Gender affirming benefits
• - Childcare benefit up to $3,000 annually
• - Twenty (20) days of paid time off during each year of employment
• - Paid paid vacation: An after-tax bonus of $1,000 for taking five consecutive days of vacation where you’re fully unplugged from work
• - Ten (10) paid holidays a year
• - Two weeks of paid sick time each year, including mental health + well being days
• - Twelve (12) weeks paid parental leave and flexible scheduling in your child’s first year
• - Up to six weeks of paid bereavement leave, medical leave, and disaster after six months of employment, two weeks of each paid leave in your first six months
• - Winter Break Closure: Kit closes for a week at the end of December, giving everyone a collective break to enjoy the holiday season
• - Four-week, paid sabbatical after five years with the team
• - Fantastic in-person or virtual retreats with the team twice a year