Engineer II, Analytics

Pilot Company is an industry-leading network of travel centers with more than 30,000 team members and over 750 retail and fueling locations in 44 states and six Canadian provinces. Our energy and logistics division serves as a top supplier of fuel, employing one of the largest tanker fleets and providing critical services to oil operations in our nation's busiest basins. Pilot Company supports a growing portfolio of brands with expertise in supply chain and retail operations, logistics and transportation, technology and digital innovation, construction, maintenance, human resources, finance, sales and marketing.

Founded in 1958 by Jim A. Haslam II and currently led by CEO Adam Wright, our founding values, people-first culture and commitment to giving back remains true to us today. Whether we are serving guests, a fellow team member, or a trucking company, we are dedicated to fueling people and keeping North America moving.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, protected veteran status or any other characteristic protected under applicable federal, state, or local law.

Military encouraged to apply.

The purpose of this job is to design, test, and implement new and/or improve existing features into Data & AI data products. 

1. Research, design, build, test, and track new descriptive and predictive applications for Data & AI that deliver impact to the organization.
2. Assist in forming business strategy through exploratory data analysis and business understanding.
3. Integrate data from disparate sources (internal and external) into data products that are consumed by business stakeholders
4. Create and maintain architecture and systems documentation for analytical products developed by Data & AI
5. Create and maintain data product source code in a source control repository (GitHub)
6. Identify opportunities for improvement in data quality, which leads to performance and accuracy improvements in Data & AI data products
7. Consult on and execute opportunities for process automation
8. Implement data structures using best practices for data modeling and visualization
9. Identify opportunities for improvements to data quality to optimize data product performance
10. Establish Data & AI Data best practices and build data products that provide single-source-of-truth foundational accuracy
11. Continually improve ongoing data pipelines and simplify self-service support for busines stakeholders and Business Analysts
12. Participate in Data and Analytics Governance best practices by documenting data structures, pipelines, and outputs across the entire organization
13. Model behaviors that support the company’s common purpose; ensure guests and team members are supported at the highest level
14. Ensure all activities are in compliance with rules, regulations, policies, and procedures
15. Drive discussion with senior leaders to generate insights
16. Complete other duties as assigned

• Bachelor's degree in mathematics, computer science, engineering, or other quantitative discipline required, Master’s degree preferred
• Minimum 3 years' experience in analytics/engineering or related industries preferred
• Expertise in SQL
• Experience working with Cloud Data Warehouse technology such as Databricks preferred
• Experience working in source control tools, such as GitHub
• Experience in R or Python
• Experience in Shiny/Streamlit applications preferred
• Experience in Tableau preferred
• Experience with Microsoft Office required
• Excellent written and verbal communication skills
• Ability to prioritize, execute tasks and meet deadlines
• Attention to detail and follow-up skills
• Problem solving and critical thinking skills
• Ability to take initiative, work independently and as part of a team
• Ability to handle sensitive and confidential information ethically and responsibly

• Less than 5% travel required 
• General office work requires sitting or standing for long periods of time
• Able to work evenings and odd hours as needed
• This position requires candidates to be legally authorized to work in the United States without employer sponsorship