Analytics Engineer

Theuniversityunion; United States; Remote; USD 80,000 - 110,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

401(k) with employer match

Stock Purchase Program

3 weeks PTO annually

Tuition reimbursement

Cell phone stipend $120/month

Job summary

Purple Wave Auction is seeking an Analytics Engineer to join our data organization. This role blends data engineering and analytics to transform raw data into clean, well-documented datasets powering reporting and self-service analytics across the business.

You will design dimensional models using dbt, implement data quality tests, and collaborate with data engineers, analysts, and stakeholders to create a single source of truth for metrics and dimensions.

Qualifications

• High school diploma or GED required.
• 2+ years of experience in analytics engineering, data analytics, or data engineering.
• Proficiency with dbt and strong SQL.
• Experience with cloud data platforms (Databricks, Snowflake, BigQuery, Redshift).
• Solid understanding of dimensional modeling, data warehousing concepts, and ELT patterns.
• Working knowledge of Git and CI/CD workflows.
• Familiarity with BI tools (Tableau, Power BI, Looker).
• Strong communication skills to translate business requirements into data models.
• Spanish speaking candidates encouraged; background check required.

Responsibilities

• Design, build, and maintain dimensional models using dbt.
• Transform raw data into clean, structured datasets for analysis.
• Define core metrics and business logic in a centralized modeling layer.
• Enforce modeling conventions for consistency across the project.
• Write data tests, monitor pipeline health, and triage issues.
• Collaborate with data engineers to improve data reliability and contracts.
• Maintain documentation and governance for models, sources, and metrics.
• Support BI dashboards in Tableau/Power BI and analytics workflows.
• Version control the dbt project with Git and manage CI/CD pipelines.

Skills

SQL

Data analytics

Spanish language

Education

High school diploma or GED

Tools

dbt

Git

Tableau

Power BI

Looker

Databricks

Snowflake

BigQuery

Redshift

Python

Job description

• Job Category Information Technology, Quality Assurance, Project Management
• Industry Machinery Manufacturing, IT Services and IT Consulting, Software Development
• Employee Type Full-Time Exempt
• Required Degree High school
• Travel 10%
• Manage Others No

• Name Talent Acquisition/Human Resources
• Phone [phone]

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.

TheAnalytics 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.

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.

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.

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 believe Purple Wave can be the best marketplace for used equipment and we are committed to make it happen.

Equal Opportunity Employer

Equal Opportunity is a Purple Wave, Inc. policy. It is our practice to select the best-qualified candidate for each position in the organization. No employee of the Company will discriminate against an applicant for employment or a fellow employee because of race, creed, color, religion, sex, national origin, ancestry, age, or other physical or mental disability, military or veteran status.

Notice of Background Check

As a condition of your employment, you will be required to sign the Company’s Authorization for Background Check, and to provide the Company with documents establishing your identity and right to work in the United States.