Senior DBA and Data Engineer (4064)

$140,500 - $207,000/Yr

Amyris - Oakland, CA

Full-time - Mid Level

Oakland, CA

Chemical Manufacturing

About the position

Amyris has developed an industry-leading platform for designing and building synthetic organisms. Our technology is being used today to make clean beauty products, bio-based renewable chemicals, and even vaccine ingredients. The Data Engineering team at Amyris supports a suite of custom applications using various state-of-the-art data technologies that make this cutting-edge science possible. Being on the Data Engineering team is all about learning and sharing experiences using the technologies that will make the difference for the company. The Senior DBA and Data Engineer will be primarily responsible for working with the Data team to participate in achieving the vision of the Data framework. The ideal candidate will come in with knowledge in multiple cloud and database technologies to hit the ground running from a technology perspective. This role would be working on architecture design, engineering, security, and resiliency for all the Data environments we have at Amyris. The Senior DBA and Data Engineer will help develop governance around APIs and API management, keeping in mind the HA/DR needs while also understanding the needs of the company and satisfying various stakeholders. The team uses a wide range of technologies and frameworks, always applying the best tool for the job at hand, making this a fantastic opportunity for you to expand your existing skill set.

Responsibilities

• Manage and engineer existing Postgres and MSSQL environments.
• Be the point of contact for the manufacturing department at Amyris and gather requirements to create and manage new projects on multiple cloud providers including GCP.
• Work independently on projects ranging from simple to complex, including executive level ad hoc analysis and integration of new data into a complex reporting system.
• Ensure proper protocols exist to monitor, capture, audit, and alert for deviations, supporting quick and timely resolution.
• Document all data, business rule, and metric changes for the team and for executives/management and power users.
• Mentor juniors in the team to help them with technical onboarding and growth.
• Spend about 5-10% of the time researching new Data products to stay updated in the field.
• Work with various stakeholders to understand their asks and provide a well-thought-out solution.
• Develop and document strategy for POCs and onboarding of new products into Amyris data framework.
• Help develop API strategy for Amyris, working with stakeholders and Data team leadership.
• Document API architecture at Amyris, including upstream and downstream systems to have a full view of the design and data flow.
• Work closely with internal stakeholders and hold periodic meetings to ensure alignment with the business direction.

Requirements

• Bachelor's Degree or higher in Computer Science, Information Technology, or related field and 5+ years of work experience as a data engineer; or a Master's degree with 3+ years of experience; or a PhD with 1+ years of experience.
• Proven experience as a data engineer with data technologies for on-prem and Cloud environments, specifically GCP.
• Proven experience using Postgres and MSSQL.
• Experience in SQL/No-SQL is required.
• Experience managing and prioritizing multiple projects simultaneously.
• Experience with API creation and management skills, at least on GCP.
• Experience with hybrid (cloud/on-premises) data topologies.
• Experience with data analysis and problem-solving skills to handle project delivery with minimal managerial intervention.
• Experience building and maintaining strong relationships with business users, software developers, and other cross-functional co-workers.
• Experience translating between technical and non-technical stakeholders.
• Experience designing data lake and data warehouse architectures using modern cloud solutions.
• Hands-on experience implementing data transformation (ETL/ELT, etc.) best practices at scale, preferably using modern cloud solutions.
• Experience with SQL and database architecture.
• Experience with both open source and off-the-shelf technologies.
• Experience with communicating across various levels, both written and verbally.

Nice-to-haves

• Professional related certifications a plus.
• Experience with AWS and Azure would be beneficial.
• Experience with other cloud providers is a plus.
• Experience in Python and Java are preferred.

Benefits

• Access to robust healthcare
• Mental wellness benefits
• Family leave
• Discounted fitness memberships
• Flexible paid time off
• 17 paid holidays
• 10 paid sick days
• 3 volunteer days
• Bereavement leave