Back to jobs

Business Data Analyst

Oakland, California, United States; San Francisco, California, United States

Environmental Science Associates (ESA) is a 100% employee-owned environmental consulting firm. We plan, design, permit, mitigate, and restore for projects across our communities, infrastructure systems, open spaces, and wildlands. We are 50 years strong in 21 offices across California, the Pacific Northwest, and the Southeastern United States.

ESA seeks a highly motivated Business Data Analyst to join our talented team. The Business Data Analyst can be located in the Northern CA region (San Francisco or Oakland, CA) and work remotely. The ideal candidate shall perform various analytical work, collect operational data, reconcile transactions, interpret financial and statistical data, and create new and modified reports related to the economic status of the company and statistical reviews of departments, projects, or other related operational items. This position can be hybrid (2) days per week in the office, preferably in San Francisco, CA. 

Who You Are 

  • You are an effective team player and collaborator who is savvy with Excel, PowerPoint, and various data collection and reporting software.
  • You have a minimum of 1-3 years of relevant experience in a professional consulting environment designing, creating, and maintaining databases, spreadsheets, and other reporting systems.
  • A bachelor's degree in business, information systems, or a related field, or an additional 4 years of experience in lieu of a degree. 
  • High level of technical proficiency with data collection and reporting software.
  • Advanced experience with Excel.
  • Exposure to data visualization tools, preferably Power BI, is preferred.
  • Exposure to an Enterprise Resource Planning tool, such as Deltek VantagePoint, preferred.
  • Exposure to Adaptive is helpful.
  • Strong analytical, problem-solving, and organizational skills is a must.
  • Ability to work with all staff levels and handle multiple tasks in a fast-paced environment.
  • Ability to work independently with minimal guidance is critical.
  • Functional knowledge of general accounting concepts, terminology, and financial reporting.
  • High degree of accuracy and attention to detail.
  • Have a good understanding of the basic functions and financial terminology necessary to create meaningful reports that accurately convey financial information and can provide routine data analytics, financial performance analysis, data collection and report writing.
  • Ability to connect the dots at a strategic level while completing day-to-day tasks in a fast-paced environment, often with little oversight, while maintaining a commitment to quality.
  • Experience working in a consulting environment where it's fast-paced and quick to pivot from one project to another.
  • Experience working in the AEC industry is a plus.
  • Must pass an excel case study test as part of the hiring process.
  • Knowledge of SQL is a plus.

What You Will Do for ESA

  • Develop, publish, and maintain weekly and monthly financial reporting, with a focus on KPI targeting and trending analysis to the COO, Business Intelligence Manager and Regional Directors.
  • Provide technical support to audit data integrity, maintain user-level databases for ad-hoc projects, and prepare queries and reports.
  • Maintain intuitive, simple, and meaningful performance dashboards, or assemble data into tables and other formats to inform decision making.
  • Provide meaningful metrics and data to assist departments and programs in preparing annual budgets and forecasts as well as identifying areas for continual improvement.
  • Identify patterns and prepare presentations of results in the most effective and appropriate display for the intended audience.
  • Validate data for problem identification and significance across multiple reports and data sources.
  • Demonstrate initiative and creativity to build on existing systems to address new reporting needs.
  • Assist with and perform ad-hoc reporting as required or other projects as assigned.
  • Manage the communication channel for Vantagepoint users and answer questions accordingly.
  • Understanding the business model and collaborating with various different business entities to be able to answer questions from employees and guide them through the process.
  • Manage the communication channel for Vantagepoint users and answer questions accordingly.
  • Understanding the business model and collaborating with various different business entities to be able to answer questions from employees and guide them through the process.

 

What’s Special About ESA

Joining ESA means becoming part of a close-knit team of environmental professionals who contribute to outstanding projects, improve environmental stewardship, and advance a more sustainable and resilient future for our communities and wild places.

At ESA, we provide benefits such as medical, dental, and vision insurance (paid at 70% for you AND your family), annual allocations of company share through our ESOP, a 401(k) plan with company match, and paid vacation, sick leave, and holidays, to name a few.

We also provide specific programs whether you want to further your technical expertise, sharpen your business acumen, or help lead the next generation of employee-owners. We want to support you in reaching your career goals through tuition reimbursement, professional development bonuses, and attendance at conferences.

ESA has established multiple pay ranges tailored to the economic factors in the geographies in which ESA staff reside. For this position, the range is approximately as listed based on our anticipated hiring locations as noted in the above job details. Actual compensation is determined by several factors including but not limited to an individual’s related experience, education, skills, and the city in which the applicant lives.  

CA Pay Transparency Clause

$88,215 - $108,000 USD

Who We Are 

We are a 100% employee-owned environmental consulting firm who values diversity and inclusion and celebrate the differences that make each of us unique. Our culture is built on mutual respect, recognizing that our variety of backgrounds, experiences, and perspectives leads to better solutions, which fosters our continued success for our employee-owners and clients. 

In accordance with ESA’s duty and responsibility to provide and maintain a safe workplace that is free of known hazards and to minimize the exposure to potential hazards, any employee who works from an ESA office or conducts any other in-person ESA work-related activity is required to submit their proof of vaccination status or have received an approved exemption and accommodation in states which this applies. 

If you are an applicant with a disability that requires a reasonable accommodation to complete any part of the application process or are limited in the ability—or unable to use—the online application system and need an alternative method for applying, you may contact our Human Resources Department via email: humanresources@esassoc.com for assistance.

 Please include the following in your message so we can promptly address your request:

  • Full name
  • The best method to contact you (phone number and/or email address)
  • Title of Job Position Applied
  • Description of your accommodation request

 

ESA is an Equal Opportunity Employer, committed to a diverse and inclusive work environment. (EOE M/V/F/D) 

 

 

Create a Job Alert

Interested in building your career at Environmental Science Associates? Get future opportunities sent straight to your email.

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter

Accepted file types: pdf, doc, docx, txt, rtf

Select...
Select...
Select...
Select...
Select...
Select...
Select...
Select...
Select...

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Environmental Science Associates’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.