Senior Analytics Engineer, Data Warehouse Architect

At Vanta, our mission is to secure the internet and protect consumer data. We believe that security should be monitored and verified continuously, and we empower companies to practice better security and prove it with ease. Vanta has a kind and talented team, and while some have prior security experience, many have been successful at Vanta without it. Our Data and Analytics team is currently looking for an Analytics Engineer to join us!

As a Senior Analytics Engineer, you’ll be responsible for laying the foundation for a best-in-class analytics function. You’ll partner closely with our engineering team and business stakeholders to ensure that our analytics stack and processes meet the business needs today with an eye towards the future.

What you’ll do as an Senior Analytics Engineer at Vanta:

• Design and implement complex data models, modeling metadata, building reports and dashboards and creating reporting tools for data science and ML products users

• Design and deploy data infrastructure needed to drive data-driven decision-making solutions

• Be the company’s expert on dbt

• Be a technical thought leader on the development of scalable data systems

• Develop front end applications to expose analytical data sets enterprise wide

• Write highly tuned, scalable SQL queries running over large-scale, heterogeneous data warehouses

• Work with the Product and Enterprise Engineering system teams to structure source systems for reporting consumption across the enterprise

How to be successful in this role:

• Have at least four years of experience working with data and two years of experience in Software Engineering or a related field

• Have experience with common analytics tooling (e.g. dbt is a must, Stitch/Fivetran, Snowflake/BigQuery/Redshift, Airflow/Dagster, Looker/Mode/Sigma)

• Bring a system-oriented and software engineering mindset to the Data Engineering practice

• We’re looking to build frameworks that manage data, and minimize bespoke queries

• Deep knowledge of crafting dimensional and fact models in modern data fashion 

• Use your Technical Architecture leadership of owning a reporting mart, and influencing the development of a maintainable data warehouse architecture to deliver a clean analytics layer

• Lead the logical architecture process for completing the build out of our centralized data warehouse

What you can expect as a Vantan:

• Industry-competitive compensation

• 100% covered medical, dental, and vision benefits with dependents coverage

• 16 weeks fully-paid parental Leave for all new parents

• Health & wellness and remote workplace stipends

• 401(k) matching

• Flexible work hours and location

• Open PTO policy

• 9 paid holidays in the US

• Offices …