Skip to content

Analytics Engineer

Avenue One LogoAvenue One
View Organization

We are looking for an experienced analytics engineer for our Data & Analytics team to work on our most critical data infrastructure projects. The data team is responsible for managing the core data that feeds our internal production systems & reporting platform. Data is at the heart of what we do here at Avenue One and ensuring clean data quality from ingestion to transformation to presentation is critical.

Day-to-day responsibilities:

  • Write data models using dbt and SQL that encompass common business processes and provide data to production systems, reporting tools and data science.
  • Research data questions, identify root causes and interact closely with analysts and other engineers.
  • Build a strong understanding of the technical and business aspects of the Avenue One product and business functions, and the SFR market and apply that knowledge effectively.
  • Contribute to the quality control and assurance process via code review, process creation, and helping to inform process development.
  • Develop and maintain strong practices on data rigor to ensure trust, accuracy, and transparency in our data.
  • Optimize existing Snowflake queries and dbt models for speed and cost.
  • Contribute to advancing the team’s design methodology and engineering best practices.
  • Collaborate with BI engineers, data engineers, product managers and data analysts to assist with data-related technical issues, migrations, upgrades and infrastructure needs.
  • Stay up-to-date with the latest industry trends, tools, and best practices in analytics engineering to ensure our technology stack and methodologies remain current and competitive.

Experience & qualifications:

  • You have 3+ years working on data teams as either a data engineer, data analyst, or data scientist.
  • Strong programming skills using SQL, dbt. Experience with python is an asset.
  • Familiar with source control tools such as Git.
  • Solid understanding of database design, architectural principles and methodologies.
  • You have a strong background in engineering design principles with demonstrated ability to develop reusable and scalable solutions to complex problems.
  • You are entrepreneurial and show leadership potential to identify and fill gaps where needed.
  • Working cross-functionally is a way of life for you. You thrive in environments where you must bring different disciplines and points of view together, as well as balance competing priorities and deadlines.
  • Experience with projects relating to cloud modernization, data migration, data warehousing in enterprise space.
  • Ability to work independently, with attention to detail.
  • Strong decision-making skills, problem resolution, negotiation, and decision-making skills.
  • Effectively communicates technical actions and expectations to the appropriate partners.