Jr. ETL Data Engineer - Sports & Entertainment
AramarkJob Description
About Data Science Group
The Data Science division is the epicenter of business intelligence, uncovering impactful insights that put Aramark clients in the sports and entertainment industry ahead of the curve. Using leading-edge technology and analytics, Data Science synthesizes operational and consumer data to optimize strategies that enhance the guest hospitality experience and blaze a trail for innovation. Through continuous expansion of analytical capabilities and a comprehensive method of understanding the industry at large, Data Science harnesses the power of data as the most strategic asset in maximizing value for consumers, operators, and businesses alike.
Job Responsibilities
Essential Duties:
• Utilize their experience in database administration, database performing tuning to manage databases withing our current environment
• Monitor, analyze, and enhance ETL processes
• Provide recommendations for architecture changes, standard maintenance routines, and provide details for creating redundancy in the SQL environment.
• Responsible for day-to-day support, troubleshooting, performing required updates to SQL, and participation on project teams.
• Provide hands-on operational support to databases
• Configure and maintain database servers and processes, including monitoring of system health and performance
• Identify performance issues and carry out Performance Tuning
• Work with various industry leading data warehouse components (databases in Snowflake, Oracle, SQL), ETL tools like Snaplogic, BI/reporting tools like Qliksense, PowerBI)
• Deploy new databases\database servers as needed
• Refines and automates regular processes, tracks issues, and documents changes
• Shares technical expertise, providing technical mentorship and cross-training to other peers and team members
Qualifications
Required Qualifications:
• 1-3 years of related database experience
• Bachelor’s Degree in Computer Science, a related field or equivalent experience required
• Experience working in a cloud environment (Snowflake, AWS) required
• Experience with JSON based data sources required
• Experience in monitoring, troubleshooting, and maintaining SQL Server databases
• Proficiency in warehousing architecture techniques, including ODS and EDW.
• Experience with automation of advanced analytical languages (R, python)
• Familiarity with database migration tools like AWS DMS
• Experience reading and transforming unstructured data sources a plus
• Experience with writing transform scripts to move data into a new data model
• Excellent communication skills, both written and verbal
• Demonstrated ability to work well independently and as a member of a team
About Aramark
Our Mission
Rooted in service and united by our purpose, we strive to do great things for each other, our partners, our communities, and our planet.
At Aramark, we believe that every employee should enjoy equal employment opportunity and be free to participate in all aspects of the company. We do not discriminate on the basis of race, color, religion, national origin, age, sex, gender, pregnancy, disability, sexual orientation, gender identity, genetic information, military status, protected veteran status or other characteristics protected by applicable law.
About Aramark
The people of Aramark proudly serve millions of guests every day through food, facilities, and uniform services in 19 countries around the world. Rooted in service and united by our purpose, we strive to do great things for each other, our partners, our communities, and our planet. We believe a career should develop your talents, fuel your passions, and empower your professional growth. So, no matter what you're pursuing - a new challenge, a sense of belonging, or just a great place to work - our focus is helping you reach your full potential. Learn more about working here at http://www.aramarkcareers.com or connect with us on Facebook, Instagram and Twitter.