Senior Analytics Engineer

PTR Premier Truck Rental; Detroit (MI); On-site; USD 100,000 - 150,000; Full time

Benefits offered by this job

Profit sharing after year 1

Comprehensive benefits

On-site gym & wellness

Job summary

Premier Truck Rental (PTR) is seeking a Senior Analytics Engineer to lead the transformation layer powering PTR's analytics. You will build dbt models, Sigma datasets, and semantic structures while collaborating with Data Engineering, Data Architecture, and the BI team to deliver scalable, governed data assets.

This onsite role in Fort Wayne, IN offers base salary plus quarterly profit sharing after one year, and opportunities to mentor engineers and raise data quality standards across the

Qualifications

• Bachelor’s degree in computer science, Analytics, or a related field.
• 5+ years of analytics engineering, data engineering, or ELT/data modeling, with senior ownership of a transformation layer.
• Advanced, production-level expertise with dbt for building, testing, and documenting models.
• Strong SQL proficiency for performance-tuned querying and transformation.
• Deep experience with a modern cloud data warehouse (Snowflake strongly preferred).
• Proven expertise in dimensional/data modeling and semantic-layer design.
• Experience with Fivetran and workflow orchestration tools like Astronomer.
• Hands-on experience with version control and CI/CD for data workflows.
• Demonstrated ability to mentor engineers and lead design/code reviews.
• Strong communication and collaboration across technical and non-technical stakeholders.

Responsibilities

• Design and build the core dbt models and Sigma datasets/semantic models used across PTR.
• Own enterprise shared dimensions (customer, GL, time, territory, etc.).
• Tune Snowflake performance and optimize SQL transformations.
• Establish testing, documentation, and data quality standards in dbt.
• Mentor Analytics Engineer I and junior engineers on modeling patterns and conventions.
• Partner with BI analysts to translate dashboard requirements into robust datasets.
• Maintain clear documentation of models and transformation logic with CI/CD practices.
• Identify opportunities to automate processes and reduce technical debt.

Skills

SQL proficiency

Data modeling

Mentoring

Data governance

Stakeholder collaboration

Analytical mindset

Education

Bachelor’s degree in CS/Analytics

Tools

dbt

Snowflake

Fivetran

Sigma

Astronomer

CI/CD

Version control

Job description

Are you in search of a company that resonates with your proactive spirit and entrepreneurial mindset? Your search ends here with Premier Truck Rental!

Company Overview

At Premier Truck Rental (PTR), we provide customized commercial fleet rentals nationwide, helping businesses get the right trucks and equipment to get the job done. Headquartered in Fort Wayne, Indiana, PTR is a family‑owned company built on a foundation of integrity, innovation, and exceptional service. We serve a wide range of industries—including construction, utilities, and infrastructure—by delivering high‑quality, ready‑to‑work trucks and trailers tailored to each customer’s needs. At PTR, we don’t just rent trucks—we partner with our customers to drive efficiency and success on every job site.

POSITION SUMMARY

As a Senior Analytics Engineer, you will serve as the technical leader responsible for building and maintaining the transformation and semantic layer that powers enterprise‑wide analytics at PTR. Leveraging our modern data stack—including Fivetran, Snowflake, dbt, and Sigma—you will tackle complex data modeling challenges, establish scalable data models, and build trusted, high‑performance datasets that drive business decision‑making.

Working closely with Data Engineering, Data Architecture, and the BI team, you will translate business requirements into governed, reusable data models while defining best practices for modeling, testing, documentation, and data quality. As the technical expert for the dbt and Sigma ecosystem, you will mentor other engineers, promote engineering excellence, and ensure the analytics layer is reliable, scalable, and easy to consume.

This role bridges the gap between data engineering and business intelligence. Your primary focus is delivering clean, trusted, and well‑governed datasets that enable the BI team to create impactful dashboards and insights across the organization.

LOCATION

Onsite in Fort Wayne, IN

PTR is prioritizing candidates located in or willing to relocate to the Fort Wayne, IN market. However, exceptional remote candidates whose experience strongly aligns with the requirements of the role may be considered on a case‑by‑case basis.

COMPENSATION

This position offers a competitive compensation package, benchmarked to regional market standards. It consists of a base salary plus the opportunity for quarterly profit sharing after one year of employment.

RESPONSIBILITIES

• Core Modeling & Semantic Layer: Design and build the core dbt models and Sigma datasets/semantic models the business relies on, applying dimensional modeling standards and software engineering best practices (modularity, version control, code review).
• Enterprise Shared Dimensions: Own the enterprise shared dimensions — customer hierarchy, GL hierarchy, time dimensions, fiscal calendars, territory mappings, and other conformed dimensions used across Finance, Commercial, and Fleet/Ops.
• Performance & Optimization: Tune model and warehouse performance in Snowflake; optimize SQL transformations and manage compute/cost efficiency as data volume grows.
• Testing, Quality & Observability: Establish and enforce testing and documentation standards in dbt; partner with the team on data quality and observability practices to ensure trust in all published data assets.
• Mentorship & Standards: Mentor Analytics Engineer I / junior engineers, review their code, and set the modeling patterns and conventions others follow (naming, layering, environment strategy).
• BI Partnership: Partner directly with the BI analyst team to translate dashboard and reporting requirements into robust dataset designs that enable reliable self‑service analytics.
• Documentation & Versioning: Maintain clear documentation of models, datasets, and transformation logic using version control and CI/CD practices so BI Analysts can self‑serve.
• Continuous Improvement: Identify opportunities to automate manual processes, reduce technical debt, and improve the scalability and reliability of the analytics layer.

REQUIREMENTS

MUST HAVE

• Bachelor’s degree in computer science, Analytics, or a related field (or equivalent work experience).
• 5+ years of experience in analytics engineering, data engineering, or ELT/data modeling, including demonstrated senior‑level ownership of a transformation layer.
• Advanced, production‑level expertise with dbt for building, testing, and documenting models.
• Strong SQL proficiency for performance‑tuned querying, transformation, and optimization.
• Deep experience with a modern cloud data warehouse (Snowflake strongly preferred).
• Proven expertise in dimensional/data model (star and snowflake schemas, conformed dimension, and SCDs) and semantic‑layer design.
• Experience with Fivetran (or similar ELT/ingestion tooling) and workflow orchestrations such as Astronomer.
• Hands‑on experience with version control and CI/CD practices for data workflows.
• Demonstrated ability to mentor engineers, lead design/code reviews, and set technical standards.
• Strong communication and collaboration skills across technical and non‑technical stakeholders.
• Ability to develop strong business acumen across multiple business units.

NICE TO HAVE

• Hands‑on experience with Sigma and semantic modeling.
• Experience with data observability tools.
• Python for scripting, automation, or light transformation logic.
• Understanding of data governance, metadata management, and data privacy/compliance standards.

Employee Benefits

At Premier Truck Rental (PTR), we invest in our people by offering competitive benefits, wellness programs, and growth opportunities designed to support you both professionally and personally.

Wellness & Fitness

Take advantage of our on‑site CrossFit‑style gym, featuring a full‑time personal trainer dedicated to helping you reach your fitness goals. Whether you're interested in group classes, virtual personal training, personalized workout plans, or nutrition coaching, we’ve got you covered.

Exclusive Employee Perks

• PTR Swag & Uniform/Boot Allowance
• On‑site Micro‑Markets stocked with snacks and essentials
• Discounts on phone plans, supplier vehicles, mobile detailing, tools, and equipment
• Additional partner and vendor discounts

Performance Incentives (Commissions, Bonuses & Profit Sharing)

At PTR, we believe in rewarding success. Certain roles offer commission structures, bonuses, or profit‑sharing opportunities based on performance. Incentive eligibility varies by position, so be sure to ask your recruiter about the compensation opportunities available for your role.

Comprehensive Benefits — Starting Day One

• Premium healthcare coverage (medical, dental, vision, mental health & virtual healthcare)
• 401(k) matching and long‑term financial planning support
• Paid time off so you can recharge
• Life, accidental death, and disability coverage
• Ongoing learning and development opportunities

Training, Growth & Recognition

We partner with the Predictive Index behavioral assessment tool, which helps identify natural behavioral drives such as dominance, extraversion, patience, and formality. This tool supports hiring decisions, team development, and employee engagement throughout the entire employee lifecycle.

Culture & Connection — More Than Just a Job

At PTR, we don’t just build relationships with our customers—we build them with each other. Our tech‑forward, highly collaborative culture is rooted in our core values.

Connect and engage through:

• PTR Field Days & Team Events
• The Extra Mile Recognition Program
• PTR Text Alerts & Open Communication

Employment Classification

Premier Truck Rental hires full‑time, part‑time, contractor, and intern positions, depending on business needs.

Benefits eligibility varies by employment classification. Contractors, interns, and part‑time employees are not eligible for the full‑time employee benefits package.

Equal Opportunity Employer

Premier Truck Rental is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law