Analytics Engineer

Summary

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

Skills

• 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

Qualifications

Must Haves

• 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

Nice to Haves

• Experience with Python is a plus but not required
• Spanish speaking bi-lingual candidates are encouraged to apply

Benefits

• Monthly Bonus Program - determined by the Company’s monthly revenue result and are paid on a “percent to plan” payout formula (90% = $300, 100% = $600, 110% = $900, 120% = $1,200).
• Monthly phone stipend in accordance with the Company’s cell phone policy, currently $120/month.
• Health insurance, Dental insurance, and Vision insurance.
• 401(k) plan with an employer match up to 4% starting the first day of employment.
• Company-paid Life Insurance with options for supplemental coverage.
• Fully paid Short-Term Disability provided by the Company.
• 3 Weeks of PTO annually (details shared during onboarding).
• Employee Stock Purchase Program (ESPP) - Eligible to purchase company stock at a discount after 90 days of employment, with enrollment opportunities each May and November.
• This position is remote work eligible within the United States.
• We provide opportunities for continued education as you grow your career with tuition reimbursement.