Data and Business Intelligence Analyst
Quick Summary
Data Warehouse & Infrastructure Maintain Cahill’s data warehouse utilizing the Kroo (or similar) connectors, ensuring data integrity, security, and accessibility.
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.
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
~1 min read- 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).
- 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.
- 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.
- 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.
- 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.
- 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.
Requirements
~2 min read- 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.
- 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.
- 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.
Location & Eligibility
About this job
- Pay per year
- $100,000–$120,000 a year
- 9% below the $121,000 median for Business Intelligence Analyst jobs on Jobera (47 salaries).
- Who can apply
- United States
- Posted
- Today
Listing Details
- Posted
- November 16, 2026
- First seen
- November 16, 2026
- Last seen
- November 16, 2026
Posting Health
- Days active
- 0
- Repost count
- 0
- Trust Level
- 71%
- Scored at
- November 16, 2026
Signal breakdown
4 other jobs at
View all →Browse Similar Jobs
Stay ahead of the market
Get the latest job openings, salary trends, and hiring insights delivered to your inbox every week.
No spam. Unsubscribe at any time.