Analytics Engineer

Description
Purple Wave is seeking a skilled and curious Analytics Engineer to join our growing data organization. Reporting to the Business Intelligence Manager, this role sits at the intersection of data engineering and analytics, ensuring that raw data is transformed into clean, tested, well-documented datasets that the entire company can trust and use. This is a remote-eligible individual contributor role responsible for building and maintaining the modeling layer that powers reporting, self-service analytics, and data-driven decision-making across the business.
The Analytics Engineer owns the transformation layer between raw ingested data and the curated, business-ready datasets consumed by analysts, stakeholders, and downstream applications. Applying software engineering best practices — version control, testing, documentation, and CI/CD — to the analytics workflow, this role ensures that data models are reliable, performant, and easy to understand. The Analytics Engineer partners closely with data engineers, analysts, data scientists, and business stakeholders to translate business logic into modular, maintainable data models and to establish a single source of truth for key metrics and dimensions.
Responsibilities
Data Modeling & Transformation
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.
Data Quality & Testing
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.
Documentation & Governance
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.
Analytics Enablement & Collaboration
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.
Engineering Best Practices
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.
Supervisory Responsibilities
None.
Qualifications
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.
Experience with Python is a plus but not required.
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.
Spanish speaking bi-lingual candidates are encouraged to apply.
Candidates may be requested to complete position specific skills assessments.
Applicants must be either a U.S. Citizen or eligible to work in the U.S.
Requires the ability to satisfactorily complete a background check.
Working Settings
Full-time Salaried Exempt, not eligible for overtime.
Office hours are 8am-5pm, Monday through Friday, Central Time zone, additional hours may be required depending on priorities.
This position is remote work eligible within the United States. Please be aware: the first week of employment includes mandatory in-person training. Remote start arrangements are not available.
Also mandatory: One week a year of in-person training with the department.
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.
Compensation
The salary varies based on experience and qualifications, but typically ranges from $80,200 to $110,400 per year.
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.
About Purple Wave
Visit us at: PurpleWave.com
Purple Wave Auction is a leader in the equipment auction industry focusing on construction, ag, fleet, and government equipment. We are a data-driven, quickly changing and evolving, growing organization. Our focus is on marketing the assets we sell for our customers to find the highest quality bidders for the best recoveries for our sellers. We strive to make this transaction Straight, Simple, and Sold. We live daily by our core values of trust, team, care, and passion to be the place people want to work and our customers want to return to for their equipment buying and selling needs for their businesses.
Purple Wave Auction is the largest no-reserve Internet auction company in the Midwest.
We have over 300 employees, nearly doubling in size in the last three years.
We have a robust tech team and continue to invest in progressive techniques to enhance our services.
While working at Purple Wave, you will have the opportunity to help our mission of being the easiest, most straightforward place to buy and sell used equipment.
Purple Wave empowers its employees to solve problems effectively in a family-run business culture.
We provide opportunities for continued education as you grow your career with tuition reimbursement. We have a generous benefits package in one of the fastest-growing companies in the area.
Purple Wave is looking for an enthusiastic person to join our growing team to support our customers as we bring our values of Trust, Team, Care and Passion to them.
Purple Wave Auction Core Values
TRUST: We are trustworthy…Our business depends upon our integrity and our customer’s ability to trust Purple Wave and its people: to enforce a fair, transparent unreserved auction marketplace; to safeguard their bidding information; to give a full effort on behalf of their asset(s); We are transparent, accountable and fair.
TEAM: WE ARE A TEAM…We respect, support, appreciate and inspire each other; We communicate and follow-through; We need each other. We do our best work when we work together.
CARE: WE CARE…We care for our customers. We look out for their best interests. We work hard for them. We “go the extra mile”.
PASSION: WE ARE PASSIONATE…We are positive, we are enthusiastic, we take pride in our work, we own our responsibilities and we deliver; When we see problems, we fix them. We learn from our mistakes. We improve ourselves and Purple Wave every day; We belie

Work arrangement
Yes