Back to jobs
tags.new

Data and Business Intelligence Analyst

San Francisco

Job Title: Data and Business Intelligence Analyst

Who We Are:

Cahill Contractors is a majority family- and woman-owned general contractor that specializes in the construction of multi-family residential, education, hospitality, and other commercial projects. With offices in San Francisco, Oakland, and San Jose, Cahill works throughout the San Francisco Bay Area. Now in its fourth generation of family leadership, Cahill has been building lasting relationships and quality structures with integrity since 1911. Cahill serves as a trusted partner to our clients, committed to their success from early in preconstruction through construction and beyond. Our employees take tremendous pride in their work and are consistently guided by Cahill’s five core values: Safety, Integrity, Commitment, Collaboration, and Continuous Improvement. Cahill is an Equal Opportunity Employer.

Position Summary:

The Data & BI Analyst is responsible for keeping Cahill’s data accurate, organized, and usable, and for building the queries, reports, and Power BI dashboards that sit on top of it. This individual maintains the tables, pipelines, and integrations that feed our data warehouse, checks that the numbers match the systems they came from, and turns that data into reporting our project, preconstruction, and accounting teams can trust.

This is an early-career role with room to grow. It works alongside our Operations Team and uses AI tools every day to work faster and smarter.  The ideal candidate is detail-oriented, curious about how our systems store information, and comfortable explaining technical work to non-technical teammates.

Responsibilities include:

Data Warehouse & Infrastructure

  • Maintain Cahill’s data warehouse utilizing the 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).

Process Improvement & Innovation

  • Work cross-departmentally with Operations, Preconstruction, Field, Safety, Quality Control, and Accounting teams to identify process bottlenecks and opportunities where AI and automation could streamline workflows.
  • Document and share lessons learned, success stories, and measurable impact of implemented solutions.

Dashboards & Reporting

  • Design and build interactive dashboards using Power BI (or similar tools) to provide real-time insights into project performance, financial metrics, scheduling, safety, and other key business indicators.
  • Partner with stakeholders to define KPIs and reporting requirements that drive informed decision-making.
  • Maintain and enhance existing reports and dashboards as business needs evolve.

AI Agents & Automation

  • Design and deploy internal AI agents and automation tools to streamline repetitive tasks and improve operational efficiency across departments.
  • Develop custom AI solutions (e.g., document analysis, predictive analytics, natural language interfaces) tailored to Cahill’s construction workflows.
  • Integrate AI tools with existing platforms such as project management software, scheduling tools, and communication systems.
  • Continuously iterate on deployed solutions based on user feedback and evolving business needs.

AI Software Evaluation & Strategy

  • Research, evaluate, and recommend third-party AI software and platforms for potential adoption across the organization.
  • Stay current with emerging AI technologies, industry trends, and best practices relevant to the construction sector.
  • Assist with the development and maintenance of an AI roadmap aligned with Cahill’s strategic goals and Continuous Improvement initiatives.

Training & Support

  • Provide hands-on training and ongoing support to all departments and employees on the effective use of AI tools and data resources.
  • Develop training materials, guides, and best-practice documentation tailored to varying levels of technical proficiency.
  • Serve as one of the go-to resource for AI-related questions, troubleshooting, and adoption support across the company.
  • Champion a data-literate culture by promoting awareness of how data and AI can enhance day-to-day work.

Desired Skills and Experience: 

  • 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 (joins, filtering, aggregation, basic data validation).
  • Experience building reports or dashboards in Power BI, Tableau, or a comparable tool, including data modeling, DAX, publishing, and refresh management. Crystal Reports a plus.
  • Familiarity with Microsoft data tools (Fabric, Azure) preferred.
  • Experience with construction, accounting, ERP, scheduling, or field operations data (e.g., Viewpoint Vista, Procore, Primavera) helpful.
  • Quick learner and adaptable problem-solver with strong interpersonal skills, able to work cross-functionally, juggle multiple priorities, and handle confidential information with discretion.

Physical Requirements:   
The physical requirements described herein are representative of those that must be met by the employee, with or without reasonable accommodation, to perform the essential functions of this job successfully. While performing the duties of this job, the employee occasionally works in an office or hybrid setting. The employee is required to work in compliance with company safety policies, procedures, and applicable laws. This position will be regularly required to: 

  • Repetitively use hand motions for keyboard use and physical use of vision to read computer monitors and paper documents. 
  • Regularly use hands to operate standard office equipment (personal computer, phone, printer, etc.) 
  • See with close vision, distance vision, color vision, peripheral vision, depth perception, and have the ability to adjust focus. 
  • Sit at a desk for prolonged periods of time working on a computer. 
  • Talk and hear at normal levels. The noise level in the office work environment is usually low to moderate. 
  • Must be able to lift up to 15 pounds at times, and up to 30 pounds occasionally.

What Can Cahill Offer You?

  • Employment - This is a full-time position located in downtown San Francisco. This role is hybrid, with a minimum of 3 days in the office.  In addition to a competitive salary, we offer an annual discretionary performance-based bonus. #LI-hybrid
  • Healthcare Benefits - We provide coverage options with a PPO plan, an HMO plan, including Kaiser. Cahill covers 100% of monthly premiums for employee medical/dental/vision coverage for HMO and PPO plans. Multiple options are available for spouse/partner and family coverage.  Additionally, we offer a Medical FSA option.
  • Retirement - Our 401(k) plan includes significant employer matching and an annual discretionary contribution. We also offer financial advisors to help you plan for your future.
  • Time Off - We understand the importance of balancing work and personal life. Our flexible PTO package allows you to recharge and take care of life's demands.  The position starts with 5 days of PTO already earned and will accrue 3 additional weeks of PTO in the first year.
  • Volunteer Time Off - We provide paid time-off for volunteering, so our team members can make a meaningful impact to the communities we serve.
  • Wellness Program Cahill's Wellness Program supports physical, mental, financial, and community well-being with an annual wellness stipend, plus free resources and training.

The base annual salary for this exempt role is targeted between $100,000 - $120,000.

Please view our Privacy Notice (https://cahill-sf.com/privacy-statement/).

Cahill is an Equal Opportunity Employer. Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.

Create a Job Alert

Interested in building your career at Cahill Contractors? Get future opportunities sent straight to your email.

Apply for this job

*

indicates a required field

Phone
Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter

Accepted file types: pdf, doc, docx, txt, rtf


Education

Select...
Select...

Select...
Select...

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Cahill Contractors’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...