We are seeking a Lead Data Warehouse Engineer to spearhead an initiative to bring all of Knock’s operational data into a single data warehouse to enable reporting and analytics.
We are looking for someone who is passionate about data warehousing, governance, and accessibility. The successful candidate will have had extensive experience standing up a data warehouse, developing ingestion and governance processes, and documenting the warehouse so its usable by anyone within the company. This is a high profile position and will work with many teams across the company.
At Knock, we have fun, we move fast, we celebrate &support our fellow teammates, and we live by our POPSICLE values.
As a Lead Data Warehouse Engineer you will:
- Research, identify, and stand up a data warehouse solution that fits Knock’s needs
- Design data schemas for business and transactional data
- Communicate requirements to product teams for making data available in the data warehouse and establish workflows for shipping data into it
- Onboard data from internal and external sources, including both event data and relational data
- Work with data scientists and business analysts to understand the company’s data needs
- Work with internal stakeholders to establish a data governance policy to ensure consistent, reliable data for reporting, dash-boarding, and analysis
- Establish monitoring and alerting practices to ensure the health of the data warehouse
- Lead presentations and trainings to onboard employees into use of the data warehouse
- Coach and mentor less experienced developers to contribute effectively to the initiative
We’re looking for Knockstars who:
- Prior experience setting up a data warehouse in the cloud (we use AWS) for a mid-to-large size company
- Excellent SQL and RDBMS skills, with solid understanding of schema design and query optimization
- Have experience in software engineering and can work effectively with product teams to collect data
- Be security-minded: design a system that can support granular access controls based on industry regulations and requirements
- Excellent communication skills, able to talk with both technical and business staff
- You have a desire to work at a rapidly growing startup and make it a success, and are comfortable learning new technologies and tools
- All of our teams have a strong customer-first mindset and data-driven approach to our work, and that should be your approach as well
- Believe in creating diverse, equitable, and inclusive practices and programs that will further Knock’s commitment to making an impact, learning, putting people first, being open, and courageous.
- Have proven success working 100% remote in prior positions &are experienced working with a distributed, national team
Benefits, Perks, &Enjoying Life
- Knock is a 100% remote, work from home culture and has been since our inception in 2015
- 100% employee covered medical, dental, &vision premiums
- Unlimited PTO (2 weeks mandatory) + flexible work schedules
- Paid parental leave
- $1,000 each year for education, training, and professional development
- Salary + Equity. We offer equitable compensation based market data, accomplishments, experience, &your location
Stack Overflow