Analytics Engineer

Purple Wave Auction is a leader in the equipment auction industry focused on construction, agricultural, fleet, and government equipment. The Analytics Engineer will build and maintain reliable, tested, documented data models that support reporting, self-service analytics, and data-driven decision-making. The role partners with data engineers, analysts, data scientists, and business stakeholders to establish trusted metrics and datasets.

Responsibilities:

• Design, build, and maintain dimensional and analytical data models using dbt (data build tool)
• Transform raw and staged data into clean, well-structured datasets optimized for analysis and reporting
• Define and codify core business logic, metrics, and definitions in a central, version-controlled modeling layer
• Develop and enforce modeling conventions (naming, structure, materialization strategies) to ensure consistency across the project
• Write and maintain robust data tests (schema, freshness, custom) to catch issues before they reach consumers
• Monitor data pipeline health and model freshness, triaging and resolving failures promptly
• Collaborate with data engineers to improve source data reliability and establish data contracts where appropriate
• Proactively identify data quality gaps and build validation layers to ensure accuracy, completeness, and consistency
• Maintain thorough, up-to-date documentation for all models, sources, and metrics within the dbt project
• Contribute to a governed semantic layer that provides consistent metric definitions across BI tools and stakeholders
• Support data cataloging efforts so business users can discover, understand, and trust the data they consume
• Partner with stakeholders to define and document data ownership, lineage, and access policies
• Partner with analysts and business stakeholders to understand reporting needs and translate them into scalable data models
• Enable self-service analytics by building intuitive, well-documented datasets that reduce ad-hoc data requests
• Support the creation of dashboards and reports in BI tools (e.g., Tableau, Power BI) by ensuring a reliable and performant data layer
• Collaborate with data scientists to prepare and curate feature datasets for statistical models and machine learning workflows
• Design and maintain analytical dashboards as necessary
• Manage the dbt project using version control (Git), including branching strategies, pull requests, and peer code review
• Build and maintain CI/CD pipelines for automated testing and deployment of data models
• Optimize model performance through materialization strategies, incremental builds, and query tuning within the cloud data platform
• Evaluate and recommend tools, packages, and patterns that improve team velocity and model quality
• Undertake additional assigned duties as requested

Requirements:

• High school diploma or GED required
• 2+ years of experience in analytics engineering, data analytics, or data engineering roles
• Proficiency with dbt (dbt Core or dbt Cloud) and strong SQL skills
• Experience with modern cloud data platforms (e.g., Databricks, Snowflake, BigQuery, Redshift)
• Solid understanding of dimensional modeling, data warehousing concepts, and ELT patterns
• Working knowledge of version control (Git) and CI/CD workflows
• Familiarity with at least one BI tool (e.g., Tableau, Power BI, Looker)
• Strong communication skills with the ability to translate business requirements into technical data models
• Exposure to semantic layers, metrics frameworks, or data cataloging tools is highly preferred
• A collaborative mindset and comfort working across technical and non-technical teams
• Applicants must be either a U.S. Citizen or eligible to work in the U.S
• This position is remote work eligible within the United States
• Potential for 10% travel, should the need arise
• Prolonged periods sitting at a desk and working on a computer
• Must be able to lift up to 15 pounds at times
• Experience with Python is a plus but not required
• Spanish speaking bi-lingual candidates are encouraged to apply