Data Engineer

About Amys

At Amys Kitchenweremore than just a food companywerea 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.

Werecommitted 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 Amyswerenot just serving meals;wereserving up a taste of goodness one delicious dish at a time.

Perksare as delicious as our meals!

Comprehensive health plans with Medical Dental and Visioncoverage plus Flexible Spending health support with Modern Health to nourish your and your familysmentalwell-being.401(k) Retirement Plan with employer match and Financial Wellness support at no costto 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. Amys 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: $97600 - $146400

*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 organizations 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 sourcesfor 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 Amys 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 foradministration 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 Amys 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 Amys Petaluma office to be in the office three days per week. Employees that live greater than 50 miles from Amys Petaluma office are exempt from the 3 days per week mandate but must visit the Petaluma office on a regular cadence.