Analytics Engineer

Vouch Insurance is a tech-enabled insurance advisory and brokerage focused on supporting growing companies in technology, life sciences, and professional services. The Analytics Engineer will be responsible for architecting and optimizing data models, ensuring data quality, and acting as a liaison between engineering and analytics teams to drive business insights.

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
• 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