About Us:
Trolley Hospitality Companies is comprised of catering, restaurant, vending, and corporate dining divisions spanning from Charlottesville to the Hampton Roads area. We were awarded one of the Top Workplaces by the Richmond Times-Dispatch three years running and have consistently been voted one of Richmond's top caterers by Style Weekly and Virginia Living Magazine as well as named 'Operator of the Year' by the National Automatic Merchandising Association.
We understand that our success is driven by the dedication and passion of our employees and together we are committed to fulfilling our purpose of delivering happiness to our customers, our community, and our employees. We hope you will join us!
Our Values - The Trolley Way:
-
No excuses
-
Do the right thing
-
Can-do attitude
-
Always growing
Help first
- -be part of the solution
Transparency and honesty
- -no BS
Please visit our website at www.trolleyhouseva.com to learn more!
About You:
-
You can visualize how to organize processes for best efficiency
-
Taming data overload is your superpower
-
You have a passion for understanding needs and using technology to deliver value
-
You have a strong knowledge of best practices
-
You understand the importance of meeting deadlines and commitments
-
You take pride in consistent and timely communication with your team
- You like being exceptionally good at what you do
-
You are willing to own your mistakes and learn from them
How You Will Make An Impact:
Trolley is committed to utilizing data and technology to make good business decisions. As we continue to grow, we are looking for a Data Analytics Engineer with a strong focus on automation to streamline our data processes and enhance efficiency. Here are some of the things you will be doing:
-
Data Lakehouse Management: Lead the development and maintenance of our data lakehouse, leveraging your expertise in Microsoft Fabric.
-
SQL Proficiency: Write custom SQL queries, focusing on T-SQL and Spark SQL to create views in the lakehouse.
-
API Integration: Evaluate and integrate various web APIs to enhance lakehouse capabilities and ensure seamless data flow.
-
Advanced Automation: Develop automated systems for data retrieval, processing, and integration from diverse sources, including APIs and ERP systems.
-
Data Translation and Parsing: Use Python or PySpark for data translation and parsing, ensuring data integrity.
-
SaaS Platform Support: Provide user support across various SaaS platforms, optimizing the user experience.
-
Data Governance: Assist in developing and enforcing data governance policies to ensure compliance and data quality.
-
Report Creation and Data Analytics: Utilize Power BI to create insightful reports, supporting informed decision-making.
-
Team Collaboration: Work effectively within a team, showcasing strong communication skills and a collaborative spirit. Act as a backup for data and IT issues when team members are unavailable, liaising with our outsourced IT provider as needed.
What You Bring to the Table:
-
Bachelor's or Master's degree in Computer Science, Data Science, Engineering, or a related field
-
Proven experience in data engineering, with a focus on data warehouses and Microsoft Fabric
-
Proficiency in SQL and T-SQL for writing custom queries and creating views
-
Experience with Python or PySpark for data translation and parsing
-
Experience in supporting SaaS platforms like HubSpot, Total Party Planner, VendSys, Quickbooks, and iSolved
-
Knowledge of data governance principles
-
Competency in Power BI for reporting and data analysis
-
Excellent communication skills for effective teamwork
-
Familiarity with online ordering platforms and supplier data management preferred
-
Basic IT knowledge, particularly in troubleshooting and understanding IT-related challenges, a plus (resolution is managed through an outsourced IT provider)
The Good Stuff:
-
Starting salary of $85k-$92k a year
- Paid holidays and PTO
-
Medical, Dental, and Vision insurance plans available
-
401(k) retirement plan and company match after 1 year of employment
-
Company paid Life and Short Term Disability insurance
-
Free lunch provided daily in the breakroom
-
Discounts at all Trolley House Hospitality companies including catering services and vending items in our warehouse