DescriptionBKF is a multi-service infrastructure consulting firm providing civil engineering, construction management, environmental, planning, and surveying services across California, the Pacific Northwest, and beyond. With offices throughout California and the Portland area, BKF has served transportation, water resources, land development, government, and federal clients for over 110 years.
At BKF, you’ll find a unique opportunity to grow your career with intention. Our culture values professional autonomy, innovation, and meaningful collaboration across offices. We are proud to be recognized with the Great Place to Work certification for the second year in a row.
We’re seeking a Senior Data Analyst with experience in Power BI and Deltek Vantagepoint from the AEC industry. The ideal candidate will be based in California and open to creating reports, extracting data from vantagepoint, and developing BDM related graphics for business intelligence reporting strategy. - Key responsibilities are to provide ad hoc financial and operational reporting to support leadership, BD strategy, and business decisions.
Responsibilities
Business Performance Reporting & Analytics (30%)
- Prepare and distribute weekly backlog, NNWA, client management, pursuit/proposal management, pipeline and others reports and dashboards
- Create and implement a comprehensive program to produce and utilize Power BI dashboards throughout our BD/MarComs program
- Provide revenue, bookings, pipeline, and business performance by year, client, division, region, and other key metrics as needed
- Develop and maintain key client and division-level performance reports, including revenue, NNWA, and core client identification based on historical revenue.
- Provide ad hoc financial and operational reporting to support leadership, BD strategy, and business decisions.
- Develop customized reports, queries, and data analyses to address emerging business needs.
Vantagepoint CRM Data Management & Business Intelligence (30%)
- CRM system optimization, data integrity and intelligence, and reporting infrastructure
- Manage and maintain BDM-related Vantagepoint data, processes, and reporting functionality.
- Design and implement an AI-enabled competitor and opportunity tracking intelligence program
- Coordinate with BD Vice Presidents and other stakeholders to collect, organize, and maintain strategic business information within Vantagepoint rather than separate spreadsheets.
- Review and validate master service agreement (MSA), on-call, and related project records to support the MSA Hub.
- Maintain and update BD-related strategic information, reporting criteria, and dashboard functionality.
BD Processes, Procedures & Operational Support (20%)