Data Engineer
Pizza Hut · Irvine, CA · 3 wk ago
HybridInformation Technology$34.47–$38.46/hrFull-time
About the role
The Habit Burger team is building industry leading technology for both staff and restaurant guests. Customers love using our highly rated app and website for ordering. Restaurant managers use our applications to manage schedules, inventory, and finances.
Responsibilities
- 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
- 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
Requirements
- 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
Qualifications
- 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
Skills
- Programming languages such as Python
- ETL concepts and processes
- Data modeling and normalization
- Database performance tuning techniques
- Visualization tools such as DOMO, Power BI, and Tableau
- IDEs such as Visual Studio, Snowflake, and others
- SSIS, SSRS, and SSAS
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
- Grossly generous parental leave
- Onsite Childcare through Bright Horizons
- Additional Perks
- 401(k) benefit plan with a 6% matching contribution
- Access to LinkedIn Learning