Data and Business Intelligence Analyst

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

About The Position

Cahill Contractors is seeking an early-career Data and Business Intelligence Analyst to maintain accurate, organized, and accessible company data and build the queries, reports, and Power BI dashboards used by project, preconstruction, and accounting teams. The role maintains data warehouse tables, pipelines, and integrations, verifies data against source systems, and creates trusted reporting. It works alongside the Operations Team and uses AI tools to improve efficiency. The ideal candidate is detail-oriented, curious about how systems store information, and comfortable explaining technical work to non-technical colleagues. The analyst will maintain data infrastructure and governance; create dashboards and reporting; identify opportunities for process improvement and automation; design and deploy internal AI agents and custom AI solutions; evaluate third-party AI tools; and support company-wide adoption through training and troubleshooting. The position collaborates with Operations, Preconstruction, Field, Safety, Quality Control, and Accounting teams. This is a full-time, hybrid role based in downtown San Francisco, with a minimum of three days in the office. The role requires regular computer and office-equipment use, prolonged desk work, normal talking and hearing, and occasional lifting of 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.
  • Strong interpersonal skills and ability to work cross-functionally, manage multiple priorities, and handle confidential information with discretion.
  • Ability to repetitively use hand motions and vision to work with keyboards, computer monitors, and paper documents.
  • Ability to operate standard office equipment, including a personal computer, phone, and printer.
  • Close, distance, color, peripheral, and depth vision, and ability to adjust focus.
  • Ability to sit at a desk for prolonged periods while working on a computer.
  • Ability to talk and hear at normal levels.
  • Ability to lift up to 15 pounds at times and up to 30 pounds occasionally.

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.
  • Crystal Reports experience.
  • Quick-learning, adaptable problem-solving approach.

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 similar tools.
  • Work cross-departmentally to identify process bottlenecks and opportunities for AI and automation.
  • Document and share lessons learned, success stories, and measurable impacts of implemented solutions.
  • Design and build interactive dashboards using Power BI or similar tools to provide insights into 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, for construction workflows.
  • Integrate AI tools with project management software, scheduling tools, and communication systems.
  • Iterate on deployed AI solutions based on user feedback and changing business needs.
  • Research, evaluate, and recommend third-party AI software and platforms.
  • Stay current with emerging AI technologies, industry trends, and construction-sector best practices.
  • Assist with development and maintenance of an AI roadmap aligned with Cahill’s strategic goals and Continuous Improvement initiatives.
  • Provide hands-on training and ongoing support to employees on AI tools and data resources.
  • Develop training materials, guides, and best-practice documentation for varying levels of technical proficiency.
  • Serve as a resource for AI questions, troubleshooting, and adoption support.
  • Promote data literacy and awareness of how data and AI can improve day-to-day work.
  • Comply with company safety policies, procedures, and applicable laws.

Benefits

  • Annual discretionary performance-based bonus.
  • Medical, dental, and vision coverage options, including PPO, HMO, and Kaiser plans; Cahill covers 100% of monthly employee 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.
  • Access to financial advisors.
  • Flexible PTO package, starting with 5 days already earned and accruing 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