Senior Analytics Engineer
About the role
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.
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
- 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.
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.
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.
Employee Benefits
- 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.
- Exclusive Employee Perks: Enjoy a variety of additional benefits designed to make life a little easier and more enjoyable.
- Performance Incentives: Certain roles offer commission structures, bonuses, or profit-sharing opportunities based on performance.
- Comprehensive Benefits: Premium healthcare coverage (medical, dental, vision, mental health & virtual healthcare), 401(k) matching and long-term financial planning support, paid time off, life, accidental death, and disability coverage, ongoing learning and development opportunities.
Benefits
- 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
Culture & Connection
- 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.