Analytics Engineer

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.

‌