> Markdown version of [/jobs/ext/551706-business-intelligence-analyst-specialist](https://www.wearedevelopers.com/jobs/ext/551706-business-intelligence-analyst-specialist). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Business Intelligence Analyst/Specialist - **Company:** Barnhill Contracting Company - **Location:** Rocky Mount, NC, United States - **Experience:** Starter - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Application Programming Interfaces (APIs), Artificial Intelligence, Data Analysis, Spreadsheets, Information Systems, Data Governance, Data Integration, Extract Transform Load (ETL), Data Security, Relational Databases, Query Languages, Human Resources Information System (HRIS), Excel Formulas, Data Intelligence, PostgreSQL, Project Management Software, Performance Tuning, Power BI, Data Streaming, Systems Integration, Tableau (Software), Snowflake, Powerquery, Microsoft Fabric, Information Technology, Data Analytics, Data Management, Restful APIs, Azure Synapse Analytics, Api Management, Workday, Databricks - **Published:** June 13, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=4390f39b40949cf2 ## About the Role Do you have experience in Systems integration?, Do you have a Bachelor's degree?, * Bachelor's degree in Business, Finance, Information Systems, Computer Science, or a related field - or an equivalent combination of work and experience (both levels). * 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 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 - aware of star/snowflake concepts and ready 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 a superintendent, a controller, or an executive; a trusted advisor. Preferred Skills: * Experience in construction, engineering, or another project-based industry. * Familiarity with Spectrum (Viewpoint), Workday, Procore, or similar ERP/HRIS/project management platforms. * Experience with Microsoft Fabric (our analytics platform of record); hands-on knowledge of Snowflake, Databricks, Azure Synapse, or other modern cloud data platforms transfers directly and is equally valued. * Understanding of construction concepts - job cost, GMP, subcontractor billing, equipment management, and payroll across multiple unions and wage templates. * Experience standing up role-based security and data access patterns. * Background in data flow automation or business workflow automation - replacing manual, spreadsheet-driven processes with automated, data-driven solutions. * Familiarity with AI-assisted analytics tooling (e.g., Copilot, natural language query tools) and a realistic view of where it adds value today. ## Description 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 - and identifies where manual processes can be replaced with data-driven automation that gives people back their time. The ideal candidate pairs technical capability with genuine curiosity about the business, strong customer-service instincts, and the ability to partner across divisions. This is posted at two levels that share the same mission; the difference is depth, independence, and scope of ownership, with a clear, supported path from Analyst to Specialist. The Analyst is an emerging BI professional - technically capable, eager to learn the business, and ready to own reporting work end-to-end with guidance from the VP of IT and the BI Developer. The Specialist is an experienced practitioner who operates independently across the full lifecycle - requirements, data modeling, development, governance, and stakeholder enablement - and serves as a trusted partner to leadership and a force-multiplier for the BI Developer. A typical day might include meeting with stakeholders to scope a reporting request, building or refining a dashboard, writing queries against a relational database, validating data accuracy before publishing, or partnering with the BI Developer on a data integration. This position is multi-faceted, with executive sponsorship and a leadership team ready to invest in the work. Job Duties & Responsibilities: Stakeholder Partnership & Requirements: * Analyst - Meet with stakeholders to understand reporting requests; translate them into well-scoped requirements, follow up promptly, and keep people informed. * Specialist - Own the stakeholder relationship end-to-end across multiple departments; anticipate needs, drive adoption, and influence software-selection decisions before they are signed. Development, Reporting & Automation: * Analyst - Build dashboards and reports using enterprise BI tools against existing curated data sources; write relational database queries (PostgreSQL) for analysis and ad-hoc requests; contribute to automated data workflows and integrations under the developer's guidance. * Specialist - Design purpose-built data sources and lead dashboard development across the company; partner with the BI Developer on warehouse design, ETL, and API integrations; identify and build workflow automation solutions that replace manual, repetitive data processes with governed, data-driven alternatives. Data Governance & Maintenance: * Analyst - Follow data governance standards, document your work, and help maintain role-based security assignments; validate data accuracy before publishing. * Specialist - Establish and evolve governance standards; own role-based security templates by department, division, and function; 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 the trusted data sources that power self-serve reporting for the building and civil groups; coach power users into greater data fluency. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Destigmatizing the Workplace: Building Real Inclusion](https://www.wearedevelopers.com/videos/1492-destigmatizing-the-workplace-building-real-inclusion) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [From Global Capability Centers to AI-Powered Command Centers](https://www.wearedevelopers.com/videos/100096-from-global-capability-centers-to-ai-powered-command-centers) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Why Upskilling And Reskilling is Important For Developers](https://www.wearedevelopers.com/magazine/428-why-upskilling-and-reskilling-is-important-for-developers) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)