Analytics Engineer

Why this role

As a tech-enabled disruptor in the vacation rental industry, data is the backbone of how Evolve is fundamentally changing how guests interact with vacation rentals and how homeowners maximize rental income generation.  Evolve’s Data & Analytics Engineering team is focused on enabling the company to innovate and make data informed decisions at scale by ensuring data is a trusted and valued asset available to all levels of the organization for innovation, visualization, analytics, reporting, data hygiene, and data science. 

In this role, you will be a key contributor responsible for enabling the business with the right information, tools, and technologies to gain valuable insights and make data-driven decisions. The Analytics Engineer is a technical role on the team and will play a key part in building, supporting, and optimizing data models that enable mission critical workflows for our reporting, analytics, business operations, and data science teams. This team and role is a critical element to Evolve’s success and helps position us as an innovator and thought-leader in the vacation rental space.

What you’ll do

• 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 sources
• Prioritize multiple tasks and projects efficiently, and clearly communicate progress and status

What makes you a great fit 

• 5+ years in a developer, architect, engineer, or DBA role working with large data sets 

• SQL knowledge is required
• 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 

• 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

Compensation