Analytics Engineer

Summary

Join Evolve, a tech-enabled disruptor in the vacation rental industry, as an Analytics Engineer. You will be a key contributor responsible for building and optimizing data models, enabling data-driven decisions across the organization. This role involves designing and implementing ETL processes, creating data visualizations, and ensuring data quality. You will collaborate with stakeholders, automate monitoring, and support team members. The ideal candidate possesses 5+ years of experience in a relevant role, strong SQL skills, and expertise with cloud-based data warehouses. Evolve offers a competitive salary, comprehensive benefits, and opportunities for professional growth.

Requirements

• 5+ years in a developer, architect, engineer, or DBA role working with large data sets
• SQL knowledge is required
• Expertise with one or more cloud-based data warehouses is required such as Snowflake
• Expertise in building and using dimensional data models using star schema techniques that serve as the source of truth for reports, dashboards, and data visualizations
• Ability to explain complex information and concepts to technical and non-technical audiences
• Enjoy supporting team members by sharing technical knowledge and helping solve problems
• Enjoy a connected, collegial environment even though we are remote, hybrid, and on-site
• Familiarity with documenting data definitions and code
• Driven by a fast-paced, energetic, results-oriented environment
• Exemplary organizational skills with the ability to manage multiple competing priorities

Responsibilities

• Build data visualizations, supporting data models, data marts, star schemas, curated data sets, and ETL processes that enable the efficient achievement of business goals
• Design, build, deploy, and manage ETL processes using SQL, Python, Snowflake scripting, and data transformation tools like Matillion and dbt to curate and transform data from the data lake and data warehouse into appropriate data sets and star schema structures within data marts to support KPIs, dashboards, and self-service analytics
• Develop a deep understanding of the data you are working with
• Ensure the quality and trustworthiness of data sources used for reporting, dashboards, and analytics
• Maintain and optimize Evolve’s cloud data platform, environment, and infrastructure by solving problems and tuning performance for underlying data structures, systems, and processes
• Design and implement processes to automate monitoring on key company metrics
• Manage the deployment and monitoring of scheduled data transformation and visualization processes
• Assist in defining quality standards for ELT, SQL, Snowflake, dbt, and Tableau as well as documenting and training other teammates on these standards
• Provide self-service data transformation and visualization support
• Partner with stakeholders to develop scalable solutions for new and modified data source
• Prioritize multiple tasks and projects efficiently, and clearly communicate progress and status

Preferred Qualifications

• Experience coding with Python is preferred
• Experience with Snowflake, Fivetran, dbt, Tableau, and AWS is preferred
• Experience with Git version control and repository management in Gitlab
• Experience with enterprise ELT tools like Fivetran, dbt, Matillion or other similar ETL/ELT tools

Benefits

• Industry-competitive pay
• Equity in the company
• A 401(k) with a 4% immediate vesting match
• 16-18 weeks of paid parental leave for birthing parents and 10 weeks for non-birthing parents
• Infertility coverage
• Comprehensive medical, dental, and vision plans (100% employer-paid for individual enrollment)
• 10 free mental health visits
• Pet insurance
• Generous PTO
• RTO (for full-time exempt employees)
• Sick leave
• Holidays
• A personal holiday to celebrate what matters most to you
• Annual Evolve travel credit after one year
• Discounts on stays at all Evolve properties
• World-class onboarding programs, learning, and development resources to help you grow your impact
• Employee Resource Groups celebrating our diverse communities at Evolve