About Amy’s 

At Amy’s Kitchen, we're more than just a food company—we're a family-owned, proudly independent organic, and vegetarian food company on a mission. As a Certified B Corporation®, our purpose is clear: to make it simple and enjoyable for everyone to eat well. 

We're committed to crafting authentic, mouthwatering dishes using only the finest organic ingredients sourced with care. From farm to table, we ensure top-notch quality in every bite, making healthy eating accessible and convenient for all. At Amy’s, we're not just serving meals; we're serving up a taste of goodness, one delicious dish at a time. 

Perks are as delicious as our meals! 

Comprehensive health plans with Medical, Dental, and Vision coverage, plus Flexible Spending Accounts. Mental health support with Modern Health to nourish your and your family’s mental well-being. 401(k) Retirement Plan with employer match and Financial Wellness support at no cost to plan for the future. Referral Rewards and Scholarship Program to celebrate and invest in our teams. Tuition Reimbursement Program to fuel your educational pursuits. Paid parental leave for new parents. Paid Time Off for vacations and sick days, with 9 paid US Holidays annually to savor those special moments. Amy's product discount reimbursement to keep your pantry stocked, plus remote gym discounts to keep you moving and grooving! Join us and indulge in a career where the benefits are as fulfilling as our food! 

Compensation range: $97,600 - $146,400

*This range is for the San Francisco Bay area; other locations may be subject to a lower range.

The Application Engineer is responsible for developing, integrating, and maintaining data applications, pipelines, and processes across platforms such as Azure Data Factory, Azure Synapse, Databricks, SQL, Power BI, and Oracle BI tools. They collaborate with business analysts, internal customers, and developers to clarify requirements, design solutions, and implement features, reports, and dashboards. The role involves creating workflows that ingest, clean, and transform data from multiple sources, ensuring reliable, timely, and analytics-ready datasets. Additionally, the Data Engineer supports and administers assigned applications and ETL/ELT processes, while ensuring the organization’s data foundation is secure, efficient, and scalable to meet the needs of analysts, data scientists, and business stakeholders.

ESSENTIAL RESPONSIBILITIES (Includes, but are not limited to the following):

Design and Development 

• Design, build, maintain, and improve custom data processes and pipelines using ETL/ELT processes to collect, process, aggregate, and transform data from various sources for both batch and real-time processing to meet business requirements.
• Analyze business requirements and use cases and translate them into technical solution designs. 
• Employ industry standard design patterns and company practices.

Testing 

• Write groups of tests that exercise multiple requirements scenarios
• Suggest and document user acceptance testing and facilitate the process and training of testers. Perform acceptance testing as appropriate.
• Configure and manage test automation

Support, Debugging & Problem Solving 

• Perform support for escalated support issues.
• Troubleshoot data application, process, and pipeline issues by reviewing code, analyzing data, reviewing logs, and tracing code execution through multiple functions, modules, or applications. Perform root-cause-analysis of problems.  
• Propose and implement most bug fixes or changes to correct assigned issues. Assist in creating more complex solutions to issues found. 

Software Development Life Cycle (SDLC)

• Participate in development planning, project management, and agile (ex: SCRUM) activities. Estimate assigned work, help to plan sprints and releases, and demonstrate completed work. 

Revision Control & Release Management

• Manage revision control for owned projects. Manage release branches. Prepare deployment artifacts or packages and perform deployments and migration. 
• Perform refreshes and clones of supporting application and data environments per established procedures. 

Administration

• Identify and perform day-to-day administrative tasks in supported application and data platforms and development tooling. Support end-user administrators and IT services team. 

It is the responsibility of all employees to uphold the mission of the Amy’s Food Safety and Quality Policy.  This includes following all Food Safety and Sustainability programs and participating in all required training.  

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education

• Four-year degree in CS or related field (or equivalent experience), or an equivalent combination of education and/or experience that demonstrates the required qualifications and skills.

Experience

• 2-5 years of experience in data engineering and analytics, with demonstrated expertise in both batch and near-real-time data processing

Technical Knowledge and Skills

Fundamental Skills

• Experience with project management and delivery methodologies.  
• Knowledge of report building tools and concepts.  
• Excellent verbal and written communication skills.
• Ability to stay organized amidst multiple time demands.  

Languages & Development 

• Utilizing SQL, PL/SQL, DAX, Power Query (M), and shell scripting, able to create and debug a wide array of data processes, pipelines, applications, and functionality. Fluent with most essential language capabilities and syntax in the data engineering space. Able to determine and utilize appropriate design patterns. 
• Hands-on experience with Azure Data Factory, Azure Synapse, Databricks, ETL/ELT tools, and related data processing and warehousing tools.
• Able to create builds and deployment processes according to company policy utilizing tools such as Azure DevOps and CI/CD pipelines. 

SQL and database skills 

• Able to create complex queries in SQL, PL/SQL, and Power Query (M) languages, including joins, conditional functions, sub-selects, and other more advanced patterns against Azure SQL and Oracle databases and ERP systems (Ex: EBS and OBIEE).
• Able to create and manage stored procedures, indexes, views, and transactions. Able to perform essential query performance debugging.  
• Strong understanding of data modeling, analytics, and reporting concepts, including databases, data warehousing, SQL, cloud services, integration strategies, and high availability/disaster recovery (HADR).

Scripting and Sysadmin 

• Able to write shell scripts using bash, power-shell, or similar tools. Very comfortable on the command-line for administration of Linux/Windows servers. Able manage basic services and settings (for example init scripts, registry, etc.)

Revision Control System (RCS)

• Comfortable with most functions of revision control systems such as Git, SVN, and Azure DevOps. Able to manage branches and tags.

Software Development Life Cycle (SDLC) 

• Able to lead the design, testing, and implementation phases of the SDLC in either waterfall or agile methodologies.

Knowledge of security protocols 

• Can evaluate and employ security concepts such as privileged services, transport encryption, certificates.  

Agile/Scrum & Project Management 

• Can describe fundamental agile principles and methodologies as well as other project management principles. Able to lead sprint planning sessions and other project and development activities for small to moderately complex projects. 

Professional Skills

• Time Management / Organizational Skills - Manage time and stay organized amidst multiple time demands.
• Listening and Communication Skill - Paraphrase to ensure understanding. Can explain the complex in clear terms.
• Writing Skills - Write organized, concise e-mails and other documents.
• Presentation Skills - Make effective presentations across IT and to other groups.
• Influencing Skills - Influence peers and customers via strong relationships and technical credibility. Rarely needs management assistance to influence laterally.
• Meeting Facilitation Skills - Manage effective meetings and facilitate group decisions.
• Company Knowledge - Understand Amy’s basic business model, including key cost drivers and ways IT can contribute to it.
• Industry Knowledge - Keep current with industry trends, best practices, and market leaders.
• Strategic Thinking - Anticipate cross-technology and cross-functional impact of decisions and actions.
• Problem Solving - Identify root causes of problems and make data-driven decisions on solutions.
• Customer Focus - Clarify internal customer expectations and regularly check in on performance against them.
• Drive for Results - Overcome obstacles he/she can manage and seek assistance for those he/she cannot.

CERTIFICATES, LICENSES, REGISTRATIONS 

Preferred but not Required: 

• Azure Data Engineer Associate
• Databricks Certified Data Engineer Associate/Professional
• Power BI Data Analyst Associate.

PHYSICAL DEMANDS

The employee is occasionally required to use hands to finger, handle, or feel; reach with hands and arms; climb or balance; and stoop, kneel, crouch, or crawl. The employee may occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, and color vision.

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

WORK ENVIRONMENT: 

Work is performed in an office environment where the physical demands require sitting for extended periods of time; frequent use of computers and standard office equipment; may work under stress of deadlines. Rarely, the employee may be exposed to risk of electrical shock, moving mechanical parts; high, precarious or enclosed places, fumes, dust or airborne particles, and extreme cold. The noise level in the work environment is usually light.

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

TRAVEL: 

This position requires occasional travel (<5%) for team and program activities.

REMOTE OR HYBRID WORK OPTION: 

This position requires employees that live within 50 miles of the Amy’s Petaluma office to be in the office three days per week.  Employees that live greater than 50 miles from Amy’s Petaluma office are exempt from the 3 days per week mandate but must visit the Petaluma office on a regular cadence.