Lead Data Engineer

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

We take immense pride in furnishing clients with a range of options, including monthly 4x4 Crew Cab Work Trucks, Utility Reel and Pole Trailers, Equipment Trailers, and Equipment Rentals. Our quest is to find exceptional individuals who align with our dedication to maintaining superior work standards while prioritizing our customers' needs and ensuring optimal team productivity. If you are someone who possesses a strong work ethic and a relentless drive and thrives in collaborative environments, we eagerly await your connection!

Please keep reading...

We encourage you to apply if you believe you have the skills, experience, and passion for the role, even if you don't meet every single requirement listed. We value diversity of thought and experience, and we believe that a variety of perspectives will help us to better serve our customers and community.

The Lead Data Engineer will architect and manage our enterprise data warehouse & business intelligence BI data modeling, supporting our business intelligence BI team's ability to deliver impactful analytics solutions. This role will lead the design and implementation of robust data pipelines, oversee extract, transform and load (ETL) processes, and drive technological innovation in our data platform. The ideal candidate will combine deep technical expertise with strategic and dynamic thinking to build scalable data architecture that enables advanced analytics, predictive modeling, and automated reporting capabilities across the organization.  

The Lead Data Engineer will also partner with IT security to implement robust data governance frameworks and ensure compliance with data privacy regulations. As a technical leader, this position will mentor junior engineers and establish coding standards and best practices for the entire data engineering team. 

LOCATION

Hybrid/Remote – Fort Wayne, IN; 5% travel may be required.

COMPENSATION

This position has a competitive compensation package that combines salary base pay plus the potential for profit sharing paid quarterly after 1 year of employment.

• Data Architecture 
• Lead the architecture, design, and implementation of a centralized data warehouse to consolidate data from various sources. 
• Define and maintain the data model architecture, ensuring it supports analytical needs and business requirements. 
• Collaborate with cross-functional teams to identify and integrate relevant data sources into the warehouse

• Data Orchestration 
• Develop and optimize efficient ELT pipelines to ingest large volumes of structured and unstructured data into the data warehouse. 
• Ensure that ELT jobs run efficiently and without error, using best practices for data pipeline management. 
• Monitor data workflows to ensure data integrity, identify bottlenecks, and implement improvements as needed. 

• Build and Optimize Advanced Data Model for BI 
• Design and implement advanced data models (e.g., star schema, snowflake schema) to support complex business intelligence queries. 
• Build predictive models and business logic layers to generate actionable insights for business stakeholders. 
• Work with business intelligence (BI) and analytics teams to refine models and ensure alignment with business goals. 

• Performance Tuning and Scalability 
• Optimize data warehouse performance to ensure fast query times, high availability, and scalability. 
• Tune SQL queries, indexes, and ETL processes for optimal performance in a production environment. 
• Continuously improve data pipeline efficiency and performance as the data warehouse grows and evolves. 

• Data Quality, Governance, and Compliance 
• Implement data quality checks, monitoring, and automated validation procedures to ensure data accuracy and reliability. 
• Define and enforce data governance standards for consistency, accessibility, and security of sensitive data. 
• Collaborate with data governance and compliance teams to ensure that data management practices align with organizational policies and regulatory requirements. 

• Leadership, Mentorship, and Collaboration 
• Lead and mentor a team of data engineers, providing guidance on best practices, coding standards, and problem-solving. 
• Act as the primary point of contact for data engineering initiatives, collaborating with stakeholders to define technical requirements. 
• Advocate for a culture of continuous learning, driving innovation and technical excellence within the team. 

• MUST HAVE 
• Bachelor's degree in computer science, data engineering, or related field.  
• 8 years of data engineering experience, including 3 years in seniora senior development role. 
• Expert-level knowledge of data warehouse technologies such as Snowflake, Redshift and/or Azure cloud services (Data Factory, Functions, Synapse).  
• Advanced experience with modern iPaaS platforms (Mulesoft, Fivetran) and Python development. 
• Proven expertise in real-time data streaming and distributed systems.  
• Strong background in data modeling (DBT) and governance frameworks.  
• Experience with version control, CI/CD practices, and infrastructure as code.  
• Expertise in performance tuning and optimization of large-scale data systems. 
• Experience building BI infrastructure from the ground floor. 
• Strong communication skills and ability to work with cross-functional teams. 

• NICE TO HAVE 
• Prior experience in the manufacturing, industrial or rental industries. 

EMPLOYEE BENEFITS

Wellness Program: Experience our on-site CrossFit-style gym, complete with a dedicated full-time personal trainer. Engage in group classes, virtual personal training sessions, training program development, and nutrition coaching programs offered.

Employee Perks: Enjoy a range of benefits including PTR Swag and a Uniform/Boot Allowance. Explore our on-site Micro-Markets for a variety of snack choices. Avail discounts on Phone Services, Supplier Vehicles, Mobile Detailing, and Tool & Equipment purchases, among other offerings.

Profit Sharing Program: Join our Profit Sharing Program, a direct involvement in PTR's triumphs, with the potential for quarterly financial rewards based on the company's profitability.

Comprehensive Benefits: Embrace a holistic benefits package that commences on your very first day at PTR. This encompassing package incorporates competitive remuneration, outstanding healthcare (including mental health and virtual healthcare), dental, and vision coverage. Additionally, enjoy generous paid time off, 401(k) matching, and coverage for life, accidental death, and disability. Engage in continuous learning and development opportunities and more.

Structured Training & Feedback: Our partnership with the Predictive Index ensures that we provide optimal support and understanding of our team members' motivations. Customized training, coaching, and feedback are regular features. Performance and attitude evaluations are conducted every 6 months, emphasizing growth.

Culture & Connection: Just as we cultivate personalized relationships with our customers, we foster the same approach within our team. A tech-forward workplace nurtures a highly collaborative culture, aligned with our core values. We promote inclusivity through Employee Resource Groups (ERGs), PTR Field Days, PTR Text Alerts, the Extra Mile recognition program, and numerous other initiatives.

Premier Truck Rental Is an Equal Opportunity Employer 

Our unwavering commitment involves consistently expanding our inclusive team, encompassing a wide array of backgrounds, viewpoints, and talents. Our ethos staunchly opposes any form of discrimination, embracing individuals without regard to race, religion, color, national origin, gender (including aspects of pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, protected veteran status, disability status, or any other legally safeguarded attributes.

If you require support or accommodation due to a disability, please feel free to reach out to us at careers@rentptr.com. We are here to assist.