Data and Business Intelligence Analyst

Cahill Contractors•San Francisco, CA
•$100,000 - $120,000•Hybrid

About The Position

The Data & BI Analyst keeps Cahill’s data accurate, organized, and usable and builds the queries, reports, and Power BI dashboards that rely on it. The role maintains the tables, pipelines, and integrations feeding the data warehouse, validates figures against their source systems, and delivers trusted reporting for project, preconstruction, and accounting teams. This is an early-career role working alongside the Operations Team, with regular use of AI tools and opportunities to grow. The ideal candidate is detail-oriented, curious about how systems store information, and able to explain technical work to non-technical colleagues. The analyst maintains and improves data warehouse infrastructure and governance, creates reporting and dashboards, and works cross-departmentally to find opportunities for process improvement through AI and automation. The role also designs and deploys internal AI agents and custom solutions, evaluates third-party AI platforms, contributes to an AI roadmap, and provides training and support to employees using AI tools and data resources. This is a full-time hybrid position based in downtown San Francisco, with a minimum of three days per week in the office. The role’s physical requirements include prolonged desk and computer work, repetitive keyboard and vision use, operating standard office equipment, normal speaking and hearing, and occasional lifting up to 30 pounds. The office environment is usually low to moderate in noise.

Requirements

  • Bachelor’s degree in Data Analytics, Information Systems, Computer Science, Business, Mathematics, or a related field, or equivalent practical experience.
  • 1–3 years of relevant experience, including internships, coursework, or comparable hands-on work.
  • Working knowledge of SQL and relational databases, including joins, filtering, aggregation, and basic data validation.
  • Experience building reports or dashboards in Power BI, Tableau, or a comparable tool, including data modeling, DAX, publishing, and refresh management.
  • Ability to work cross-functionally, manage multiple priorities, and handle confidential information with discretion.
  • Strong interpersonal skills and an adaptable, quick-learning, problem-solving approach.

Nice To Haves

  • Familiarity with Microsoft data tools such as Fabric and Azure.
  • Experience with construction, accounting, ERP, scheduling, or field operations data, such as Viewpoint Vista, Procore, or Primavera.
  • Experience with Crystal Reports.

Responsibilities

  • Maintain Cahill’s data warehouse using Kroo or similar connectors, ensuring data integrity, security, and accessibility.
  • Establish and enforce data governance standards, including naming conventions, documentation, and access controls.
  • Monitor data warehouse performance and optimize queries, storage, and infrastructure for reliability and speed.
  • Aggregate additional data sources into a data lake through Fabric or a similar tool.
  • Work with Operations, Preconstruction, Field, Safety, Quality Control, and Accounting teams to identify process bottlenecks and opportunities for AI and automation.
  • Document and share lessons learned, success stories, and the measurable impact of implemented solutions.
  • Design and build interactive Power BI or similar dashboards for project performance, financial metrics, scheduling, safety, and other business indicators.
  • Partner with stakeholders to define KPIs and reporting requirements.
  • Maintain and enhance reports and dashboards as business needs evolve.
  • Design and deploy internal AI agents and automation tools to streamline repetitive tasks and improve operational efficiency.
  • Develop custom AI solutions, such as document analysis, predictive analytics, and natural-language interfaces, tailored to construction workflows.
  • Integrate AI tools with existing platforms, including project management software, scheduling tools, and communication systems.
  • Iterate on deployed solutions based on user feedback and changing business needs.
  • Research, evaluate, and recommend third-party AI software and platforms.
  • Stay current with AI technologies, industry trends, and best practices relevant to construction.
  • Assist with developing and maintaining an AI roadmap aligned with Cahill’s strategic goals and Continuous Improvement initiatives.
  • Provide hands-on training and ongoing support to employees and departments on AI tools and data resources.
  • Develop training materials, guides, and best-practice documentation for varying levels of technical proficiency.
  • Provide AI-related troubleshooting and adoption support across the company.
  • Promote data literacy and awareness of how data and AI can improve day-to-day work.

Benefits

  • Annual discretionary performance-based bonus.
  • PPO and HMO medical plans, including Kaiser; Cahill covers 100% of monthly employee medical, dental, and vision premiums for HMO and PPO plans.
  • Spouse/partner and family coverage options.
  • Medical FSA option.
  • 401(k) plan with significant employer matching and an annual discretionary contribution.
  • Financial advisors to help employees plan for the future.
  • Flexible PTO; the position starts with 5 days of PTO already earned and accrues 3 additional weeks during the first year.
  • Paid time off for volunteering.
  • Wellness program with an annual wellness stipend, free resources, and training.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service