Senior Analytics Engineer
Posted over 2 years ago
Description
ConvertKit is the web’s best creator marketing platform that helps creators grow their audience, connect with their true fans, and earn a living online. For makers, authors, chefs, musicians, athletes, and anyone else making a living by creating the culture we all love, there isn’t a better tool for reaching inboxes. More importantly, there isn’t a team more committed to helping creators earn a living doing work that matters.
Role Description
In the delightful land of ConvertKit, there’s a lawless Data Wild West that has vast untapped potential and is primed for transformation and data domestication. If you possess the adventurous spirit of a data pioneer, the ConvertKit Data and Analytics team could be the place for you to stake your claim as our first Analytics Engineer!
You’ll be our data architect, wrangler, law-person, teacher, and general store manager. You will work with our engineers, analysts, and business stakeholders to take our unprocessed data and turn it into a 24-karat, gold-standard data set that anybody can use, in everything from data science research to self-service analysis.
Responsibilities
Architect and Wrangler
- Design the Data Model for our Redshift Data Warehouse and wrangle and transform our data so that it’s simple for analysts and business users to do their data things
- Fastidiously document data lineage and gotchas
- Set up our R environments for seamless access for analysis and delivery to end user consumption. This could involve setting up pipelines from R to Redshift, a Shiny Server, and maintaining Docker images
- Channel Merriam-Webster and create, maintain, and make accessible our Data Dictionary
Law-person
- Enforce consistent data collection requirements from our application and websites
- Catch bad data before it commits any crimes. Outline potential impact if bad data gets through
- Advocate for safe data usage
- Create reproducibility laws like naming conventions, code style guides, project structures
- Ruthlessly hunt down rogue one-off custom queries and analyses and rehabilitate them
Teacher
- Level-up analysts to think and work like software engineers and increase their efficiency by teaching them things like advanced SQL/R, command line automations, proper Git etiquette, etc.
- Hold regular training and office hour sessions on how to use our reporting tool
- Write quick FAQs and starter guides on how data works at ConvertKit
General Store Manager
- Be the friendly face that owns and runs ConvertKit’s reporting tool (currently Sisense), delighting your customers with the data nuggets they uncover
- Create standardized technical and business definitions for our business metadata layer
- Clearly communicate any data issues and resolution steps
Requirements
Must Haves
- A data pioneer spirit! For you, every untamed SQL query is an opportunity to teach your teammate how to be more effective. Every messy data swamp is something you’d love to drain
- A pirate’s mindset. Not just because you talk R, but because you’re willing to get curious and question conventional wisdom
- Allergic to one-off data products. You have a visceral reaction towards ad hoc work that’s become permanent and faux-production. You have a compulsive need to build things that are modular and reusable
- Tri-lingual fluency and translator among engineering, data, and business speak
- Comfortable problem solving in public; not afraid to revisit your choices and change course
- Consistent advocacy for data best practices throughout ConvertKit
- SQL expert
- R expertise. You’re an ardent Tidyverse and Hadley Wickham fan. Using Rmarkdown and Shiny are second nature to you
- GitHub mastery; more importantly you love getting other people committed to disciplined usage
- Live and breathe DBT or some other transformation and testing platform
- Extensive data modeling experience
- Ability to thrive in an ambiguous, fast-paced, and flexible environment with a high degree of autonomy
- Comfortable working in a 100% remote environment
- Have enthusiasm and belief in our mission, vision, and values
Nice But Not Required
- Python expertise. Much of our data pipelines are written in it
- Reporting platform expertise. We currently use Sisense for Cloud Data Teams (Periscope), but are open to moving to something else that works best for ConvertKit
- Front end website tracking experience with Segment, Google Tag Manager, and Google Analytics
Here’s the SQL script that created this job description and finds the right candidates
select
JD.company_descr, JD.role_descr, JD.responsibilities
,JD.requirements, JD.benefits
,JD.sql JD.how_to_apply, JD.app_questions
from
Job_description JD
LEFT_JOIN on job_candidates JC on JD.id = JC.job_description_id
where
JD.description = ‘analytics_engineer’
AND JD.personality = ‘western’
AND JC.attribute_humor = 1 AND JC.skill_r = 1 AND C.skill_sql = 1
AND JC.attribute_trilingual = 1
Benefits
ConvertKit has standardized salaries based on position, no matter where you live. For this role, we’re hiring at our level 4 ($155,000). Level offered is determined based on experience and our interview process.
Other benefits include:
- Three weeks (15 days) paid vacation, increasing to four weeks (20 days) paid vacation after one year on the team
- $1,000 yearly vacation bonus for taking five consecutive days of vacation, fully unplugged from work
- 10 paid holidays
- Two weeks of sick leave per year, including mental health days
- Up to six weeks paid bereavement leave and medical leave after six months of employment, two weeks of each paid leave in your first six months.
- Twelve weeks of disaster leave for all team members in 2021
- Excellent medical, dental and vision benefits
- Gender affirming benefits
- Twelve weeks paid parental leave and flexible scheduling in your child’s first year
- Profit sharing
- $3,200 equipment allowance for your first two years, $2,500 budget every following two years for U.S.-based team members
- 401k with a 5% match
- Individual learning & development budget
- Yearly conference credit
- Four-week, paid sabbatical after five years with the team
- The team gathers twice a year for fantastic virtual or in-person retreats
This role will close on Aug 25th. We usually receive a large number of applications (because of remote work!), but hope to get through them within two weeks of the close date for the role. Don’t worry, you’ll hear from us either way. Here’s what you can expect from the rest of our hiring process:
- A phone screen with the hiring manager (Wes Yeo)
- A brief exercise or homework assignment to assess your skills
- A technical interview to discuss your technical knowledge
- A conversation with an Executive team member
- A culture contribution interview
We’ll keep you informed through every step. To get started, complete this application, including a cover letter and answers to the questions on the next page. We read every single application, and your cover letter and responses help put your experience into context.
ConvertKit is an equal opportunity employer. We value diversity in all of its forms, and we hire the best person we can for each role, no matter your personal background. Research tells us that applicants who are female or non-binary, as well as applicants who are people of color, are less likely to apply for roles they do not feel 100% qualified for. If you think you meet more than 50% of our requirements but fewer than 100% of them, please apply. We’re imperfect communicators, so think of our job postings as the starting point for discussion rather than proof that you shouldn’t apply.