"Staff Business Systems Analyst (Joint Genome Institute)"

Berkeley Lab's LBNL Joint Genome Institute (JGI) has an opening for a Staff Business Systems Analyst to play a critical role in transforming raw scientific outputs into high-value, AI-ready data assets that directly support JGI's mission.

In this exciting role, you will contribute to the development and maintenance of a robust Data Lakehouse, leading ongoing integration efforts to ensure scientific data is well-structured, accessible, and optimized for use by domain scientists and downstream AI applications. This position will analyze complex business and data management challenges and will design automated, cost-effective solutions to address them.

The JGI's mission is to provide the global research community with access to the most advanced integrative genome science capabilities in support of the DOEs research mission to solve the world's evolving energy and environmental challenges. The JGI supports projects in genome sequencing, synthesis, transcriptomics, metabolomics, and natural products in plants, fungi, algae, and microorganisms. This position is headquartered on the Lab's main site at the Integrative Genomics Building (IGB) (Virtual Tour).

This position has an anticipated start date of March 1, 2026.

Why join Berkeley Lab?

We invest in our employees by offering a total rewards package you can count on:

• Exceptional health and retirement benefits, including pension or 401K-style plans
• A culture where you'll belong - we are invested in our teams!
• In addition to accruing vacation and sick time, we also have a Winter Holiday Shutdown every year.
• Parental bonding leave (for both mothers and fathers)
• Pet insurance

What You Will Do:

• Analyze and evaluate complex business problems and design automated system solutions.
• Provide technical expertise in identifying, evaluating, and developing cost-effective systems and procedures that meet user requirements.
• Lead the design and implementation of data integration processes for the JGI's Data Lakehouse, ensuring large scientific datasets are structured for efficient querying and analysis.
• Design, build, and maintain fault-tolerant, scalable, and efficient ETL/ELT data pipelines to ingest, transform, and load genomic data and associated metadata into the Data Lakehouse.
• Plan and perform unit, integration, and acceptance testing.
• Create system specifications aligned with business requirements.
• Provide consultation and guidance to domain scientists and other users on the use of automated systems.
• Collaborate closely with cross-functional teams to resolve business and system-related issues.

What Is Required:

• A Bachelor's Degree (or equivalent knowledge/training) in Computer Science, Data Engineering, or a related technical field and a minimum of 8 years of demonstrated experience structuring large-scale datasets for efficient use in Data Lakehouse environments, leveraging technologies such as Parquet, Iceberg, Dremio, Spark, or similar lakehouse and data warehousing platforms or an equivalent combination of education and experience.
• Demonstrated proficiency with modern Extract, Transform, Load (ETL) and Extract, Load, Transform (ELT) tools and frameworks.
• Strong scripting skills in data engineering languages, including Python (Pandas, Polars, etc) and advanced SQL for data manipulation and performance optimization.
• Strong analytical skills including the ability to identify problems, troubleshoot, and demonstrate good judgement in selecting methods and techniques for obtaining solutions.
• Excellent oral and written communication skills, including experience organizing and presenting technical information to varying audiences.
• Demonstrated interpersonal skills including experience collaborating with an interdisciplinary research team.

Desired Qualifications:

• A Master's Degree (or equivalent knowledge/training) in Computer Science, Data Engineering, or a related technical field.
• Experience with Data Lakehouse technologies like Dremio or Spark.
• Domain knowledge of genomics data.

Additional Information:

• Application Date: Priority consideration will be given to candidates who apply with a resume and cover letter by January 12, 2026. Applications will be accepted until the job posting is removed.
• Appointment Type: This is a full time, exempt from overtime pay (monthly paid), 2 year (benefits eligible), Term appointment with the possibility of extension or conversion to Career appointment based upon satisfactory job performance, continuing availability of funds, and ongoing operational needs.
• Salary Range: This position has a budgeted salary range of $139,440 - $174,312 annually, which fits within the full salary range of $139,440 - $235,308 annually for job code C71.3. It is not typical for an individual to be offered a salary at or near the top of the range for a position. Salary will be commensurate with the final candidate's qualification and experience, including skills, knowledge, relevant education, certifications, and aligned with the internal peer group.
• Background Check: This position is subject to a background check. Any convictions will be evaluated to determine if they directly relate to the responsibilities and requirements of the position. Having a conviction history will not automatically disqualify an applicant from being considered for employment.
• Work Modality: This position will be performed onsite at Lawrence Berkeley National Lab located at 1 Cyclotron Road, Berkeley, CA 94720. Work schedules are dependent on business needs. A REAL ID or other acceptable form of identification is required to access Berkeley Lab sites (for more information click here).
• Relocation Assistance: This position is eligible for relocation assistance.
• Work Authorization: Applicants must be legally authorized to work in the United States. Berkeley Lab does not provide visa sponsorship for this position.

Want to learn more about working at Berkeley Lab? Please visit: careers.lbl.gov