Business Intelligence Analyst​/Specialist

Business Intelligence Analyst / Specialist

The Business Intelligence Analyst / Specialist is the face of a new BI function that Barnhill Contracting is building from the ground up. This role turns data from Spectrum, Workday, Procore, and other source systems into the reports, dashboards, automated data flows, and curated data sets that move the business forward, while identifying where manual processes can be replaced with data‑driven automation to free up time for teams.

• Stakeholder Partnership & Requirements
  • Analyst:
    Meet with stakeholders, translate reporting requests into clear, scoping requirements, follow up promptly, and keep all parties informed.
  • Specialist:
    Own the stakeholder relationship end‑to‑end across multiple departments, anticipate needs, drive adoption, and influence software‑selection decisions before signing.
• Development, Reporting & Automation
  • Analyst:
    Build dashboards and reports with enterprise BI tools using existing curated data sources, write relational database queries (PostgreSQL) for analysis and ad‑hoc requests, and contribute to automated data workflows and integrations under guidance.
  • Specialist:
    Design purpose‑built data sources, lead dashboard development company‑wide, partner on warehouse design, ETL, and API integrations, and create workflow automation solutions that replace manual data processes.
• Data Governance & Maintenance
  • Analyst:
    Follow data governance standards, document work, assist with role‑based security assignments, and validate data accuracy before publishing.
  • Specialist:
    Establish and evolve governance standards, own role‑based security templates by department, define the source of truth for each data domain, and keep pipelines healthy.
• Self‑Serve Enablement
  • Analyst:
    Support power users by answering questions and helping them reach the right data source.
  • Specialist:
    Build and curate trusted data sources for self‑serve reporting, and coach users into greater data fluency.

• Bachelor’s degree in Business, Finance, Information Systems, Computer Science, or equivalent experience.
• Years of experience
  • Analyst: 1–3 years in BI, reporting, data analysis, or business analysis.
  • Specialist: 3+ years building production BI solutions end to end.
• Query language
  • Analyst:
    Comfortable writing basic queries against a relational database and willing to learn optimization.
  • Specialist:
    Strong query authoring and tuning (joins, CTEs, window functions, performance tuning).
• BI & reporting tools
  • Analyst:
    Hands‑on experience with a BI visualization tool (e.g., Power BI, Tableau) in a learning or supporting capacity.
  • Specialist:
    Production experience building, publishing, and maintaining dashboards in one or more enterprise BI tools.
• Data modeling
  • Analyst:
    Knowledge of star/snowflake concepts and willingness to learn.
  • Specialist:
    Builds curated fact/dimension data sets independently.
• Integration
  • Analyst:
    Familiar with the concept of API and ERP integrations.
  • Specialist:
    Experience pulling data from ERPs and HRIS via direct connection or REST API.
• Excel
  • Analyst:
    Power user (pivots and complex formulas).
  • Specialist:
    Power user plus data connections and Power Query.
• Communication
  • Analyst:
    Clear, professional, and customer‑service oriented.
  • Specialist:
    Adjusts style for superintendents, controllers, or executives; trusted advisor.

• Experience in construction, engineering, or another project‑based industry.
• Familiarity with Spectrum (Viewpoint), Workday, Procore, or similar ERP/HRIS/project management platforms.
• Hands‑on knowledge of Microsoft Fabric, Snowflake, Databricks, Azure Synapse, or other modern cloud data platforms.
• Understanding of construction concepts such as job cost, GMP, subcontractor billing, equipment management, and payroll across multiple unions and wage templates.
• Experience establishing role‑based security and data access patterns.
• Background in data flow automation or business workflow automation.
• Familiarity with AI‑assisted analytics tooling (e.g., Copilot, natural language query tools) and realistic assessment of its current value.

• Commitment – individual ownership to achieve team success.
• Family – sense of…