Vouch Insurance is a tech-enabled insurance advisory and brokerage that supports growing companies in various sectors. They are seeking an Analytics Engineer to build and optimize data models, ensuring data quality and acting as a liaison between engineering and analytics teams.
Responsibilities:
- Architect, build and optimize robust data models in dbt to power business reporting processes and analytics use cases
- Effectively speak with, and listen to, business stakeholders, engineers, designers, executives, etc., so that you can
- Understand business context and support analysts/business stakeholders across GTM, Finance, and Product to design and build single-source-of-truth data assets to drive Vouch’s business
- Act as a liaison between Engineering and Analytics to define source and target fields for data assets
- Partner with upstream Engineering teams to develop new and adapt existing data models as our technology and business evolve
- Clearly document specs and data models with source, description, and field definitions to enhance collaboration, scalability, and usability
- Set up tests to ensure data quality, monitor daily job execution, and diagnose/fix issues to ensure SLAs are met
- Perform root cause analysis for data quality issues, and partner with upstream teams and business stakeholders to rectify dirty, incomplete, or unreliable data
- Maintain and enforce consistent data modelling standards, best practices, and design patterns
- Provide and receive constructive feedback through code reviews, technical specifications, and pair programming sessions
- Use software development best practices with a focus on version control, testing, reliability and maintainability
- Work in dbt, SQL, Snowflake, git, Airflow, Python, Stitch, Mode, and we welcome new ideas!
Requirements:
- 3+ years experience developing ETL/ELT workflows as a data analytics engineer, data engineer, or data analyst, supporting a variety of business domains
- Advanced experience in SQL, dbt, Snowflake, and git
- Intermediate experience building business reporting processes (e.g. for Finance, GTM, etc.)
- Intermediate experience leveraging data pipeline services like Stitch and orchestration tools like Airflow
- Are excited to learn about Vouch's business models, and dig into our business processes to understand how data is generated
- Are energized by business impact & a self-starter
- Advanced communication skills and the ability to explain complex concepts to both technical and non-technical audiences
- Thrive in cross-functional projects that have a heavy combination of technical requirements and user-focused workflow
- Basic experience with business intelligence tools such as Mode Analytics
- Basic experience in Python, Airflow, Stitch
- Familiarity with insurance or financial services data modeling
- Exposure to and passion for early-stage startups and/or high growth environments