Data Engineer

Location Requirement: Hybrid onsite in Irvine, CA Our dynamic Habit Burger team is building industry leading technology for our staff and restaurant guests. Customers love using our highly rated app and website for their ordering needs. Our restaurant managers use our applications to manage employee schedules, inventory, and the financials of their business. We also seamlessly integrate with several 3rd party delivery services such as DoorDash, Grubhub and UberEats. We are seeking a Data Engineer to become part of our dynamic data team. In this role, you will work in a hands-on technical role on a team focused on delivering the best experience to our internal restaurant staff and our customers. Develop and maintain stored procedures, triggers, and other database objects Participate in the development of reports and integration with other systems Perform database testing and debugging Participate in code reviews Document database design, architecture, and processes Implement and maintain database security measures Ensure data security, data integrity, and data quality Monitor database performance and resolve issues as necessary Transition efficiently between various tasks such as high priority requests and ongoing projects. Collaborate with other developers, stakeholders, and end-users to understand requirements and provide solutions that meet business needs Architect, develop, and manage scalable, reliable data pipelines A BS in Computer Science or equivalent experience 2-4 years designing, developing, and maintaining a database Proficiency in MSSQL (T-SQL, Stored Procs) or equivalent Working knowledge of at least one database management system (e.g., Oracle, MySQL, Microsoft SQL Server) Familiarity with database design principles and techniques, including data modeling and normalization Understanding of database performance tuning techniques, including indexing and query optimization Prior knowledge of ETL concepts and processes, including data transformation, and data loading. Some experience with at least one ETL tool a plus. Flexible working in a variety of IDEs such as visual studio, snowflake, and others Exposure to visualization tools such as DOMO, Power BI and Tableau is desirable, with DOMO experience preferred Experience with SSIS, SSRS, and SSAS is a plus Knowledge of programming languages such as Python is a plus Awareness of laws surrounding data and data privacy Strong problem-solving skills and attention to detail Strong work ethic and willingness to learn Good communication and collaboration Salary Range: $34.47 to $38.46 hourly + bonus eligibility. This is the expected salary range for this position. Ultimately, in determining pay, we'll consider the successful candidate’s location, experience, and other job-related factors. At Yum! Brands and at The Habit Restaurants, LLC, one of our core values is to Believe in ALL People. This means seeing the value in everyone and unlocking their full potential to be their best self. The Habit Restaurants, LLC is proud to be an equal opportunity employer and is committed to equity, inclusion, and belonging for all dimensions of diversity. We do not discriminate based on race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, disability status, age, or any other protected characteristic. We are committed to working with and providing reasonable accommodation to applicants with disabilities or special needs. US Job Seekers/Employees - Click here to view the “Know Your Rights” poster and supplement and the Pay Transparency Policy Statement. Employment eligibility to work with Yum! in the U.S. is required as the company will not pursue visa sponsorship for this position. BENEFITS Competitive base pay with benefits including: Up to 4 weeks of vacation per year plus additional sick days Hybrid work schedule and year-round flex day Friday Up to 10 Paid Holidays + 1 Floating holidays The company provided Recharge Days to unplug and reenergize Competitive bonus program for eligible roles Recognition-based culture. FAMILY BENEFITS: Comprehensive medical, dental, and vision benefits including prescription drug benefits & 100% preventative care starting on Day 1 Healthcare and dependent care flexible spending accounts Employee Assistance Program available to all employees and their dependents Generous parental leave Onsite Childcare through Bright Horizons ADDITIONAL PERKS: 401(k) benefit plan with a 6% matching contribution Up to 2 Paid Days to Volunteer for any non-profit or charitable organization important to you Access to LinkedIn Learning