Business Data Analyst

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 bachelors degree in business information systems or arelated 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 its 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.

Whats 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.

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 ESAs 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 abilityor unable to usethe online application system and need an alternative method for applying you may contact our Human Resources Department via email: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. (EOEM/V/F/D)