Name:
Data Engineer
Location: Irvine, CA
Job Posting Location - City, State:
Irvine, CA
Work Type:
Full-time
Department:
Information Technology

Description & Requirements

Come join our family at In-N-Out Burger! 

We have an excellent opportunity for a full-time Data Engineer in the I.T. department in our Irvine, CA office. This person will work closely with many teams in the company, including Database Administration, Software Development, and Business Intelligence to support and implement reporting and analytics used by In-N-Out Burger.

*This position is full-time in-office only.

General Responsibilities:
Design and construct data architectures and integrations/pipelines that align with business requirements.
Collaborates and creates data sets for analytics and business team members that assist them in building data visualizations and increasing data accessibility and fostering data-driven decision making across the organization.
Identify ways to improve data reliability, efficiency automation, and quality
Builds out new API integrations to support continuing increases in data volume and complexity.
Assemble large, complex data sets that meet functional / non-functional business requirements.
Implements processes and systems to monitor data quality, ensuring production data is always accurate and available for key stakeholders and business processes that depend on it.
Performs data analysis required to troubleshoot data related issues and assist in the resolution of data issues.
Works closely with a team of frontend and backend engineers, product managers, and analysts and help develop strategy for long term data platform architecture
History of manipulating, processing and extracting value from large disconnected datasets.
Monitor performance of data flow systems, with the ability to tune SQL systems for optimum performance.
Provide support and guidance to our application developers for SQL and PL/SQL performance tuning and data flow.
Maintain confidentiality of all sensitive data.

Work Schedule + Benefits:

Full-time, Exempt
Office Hours: Hours will vary but typically work Mon-Fri, 8:00 am-5:00 pm
Some overtime will be required 
Dental, Vision, Life Insurance, FSA’s, 401(k)/Profit Sharing Plan, Adoption Assistance, Education Reimbursement, Supplemental Health Plans and Pet Insurance

Qualifications:
Bachelor’s degree in Computer Science, Information Systems, Analytics or related field is required
Minimum 3+ years’ experience in a Data Engineering role using Oracle databases
Proficient in SQL, PL/SQL, and TSQL
Moderate understanding in database performance troubleshooting/tuning, skillful in SQL execution plan and tuning
Experience building and optimizing ‘big data’ data pipelines, architectures and data sets.
Strong analytic skills
Familiar with creating semantic layers and data lakes
Build processes supporting data transformation from our Oracle database running custom software to our Data Warehouse
Working knowledge of message queuing, stream processing
Data Warehouse development and modeling
Experience with using Powershell, Bash or other scripting languages
Experience supporting and working with cross-functional teams in a dynamic environment
Ability to manage multiple projects and priorities
Strong verbal and written communication skills 
Highly motivated and enjoys working through and solving complex problems
Extremely detail oriented and passionate about work quality 
Proactive self-starter; action oriented 
Ability to independently and reliably manage a heavy work load in a fast-paced environment
Additional Preferred Skills:
Oracle Cloud – OIC, ATP, ADW, OAC
Oracle Golden Gate
ETL tools

ABOUT In-N-Out Burger

In-N-Out Burger was founded in 1948 by Harry and Esther Snyder in Baldwin Park, California, and remains privately owned and operated. Under the direction of the Snyder family, the company has opened restaurants throughout California, Nevada, Arizona, Utah, Texas, Oregon and Colorado. In-N-Out Burger’s menu has remained the same since 1948, and we have maintained a simple philosophy – serve only the highest quality product, prepare it in a clean and sparkling environment, and serve it in a warm and friendly manner. We have built a reputation for fresh, made-to-order foods prepared and served by friendly, well trained Associates.

In-N-Out Burger offers a competitive salary and comprehensive benefit package. We are an Equal Opportunity Employer by choice. Should there be a need, In-N-Out Burger will provide a reasonable accommodation to complete the interview process upon request.