Business Data Analyst

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