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 (BONUS)
Familiarity with insurance or financial services data modeling (BONUS)
Exposure to and passion for early-stage startups and/or high growth environments

Benefits

Competitive compensation and equity packages
Health, dental, and vision insurance
Parental leave
Flexible vacation time
Wellness allowance
Technology allowance
Company-sponsored personal and professional development
L&D: Partnerships with Ethena and monthly Lunch & Learns
Wellbeing: access to many wellbeing perks, including Peloton, Fetch, OneMedical, Headspace care+, etc.
Caregiver Support: company seed into the dependent care FSA and company sponsored Care.com membership.
Regular performance reviews: Vouch conducts regular performance discussions with all team members, offering goal setting and check-ins, development discussions, and promotion opportunities

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

dbtSQLSnowflakegitAirflowPythonETLELTdata modelingdata quality

Soft Skills

communicationcollaborationproblem-solvingself-startercross-functional teamworkfeedbackadaptabilitybusiness impactanalytical thinkingstakeholder engagement