BUSINESS INTELLIGENCE ANALYST

ADP, Inc.; Winston-Salem (NC); On-site; USD 70,000 - 100,000; Full time

Benefits offered by this job

Medical Insurance

Vision Insurance

401(k) matching

PTO

Life Insurance

Short Term Disability

Job summary

Blum is seeking a Business Intelligence Analyst to design and maintain reporting and dashboards across project teams and corporate functions. The role focuses on turning data from ERP, project management, and document systems into actionable insights while automating repetitive tasks.

You will own the data warehouse end-to-end, implement data quality checks, and collaborate with stakeholders to deliver reliable, scalable BI solutions across the organization.

Qualifications

• Bachelor's degree or equivalent combination of education and experience.
• 2+ years in building BI reporting in a production environment.
• Experience publishing reporting on a major BI platform including query and calculation layers.
• Proficiency writing queries against relational databases (joins, aggregations, window functions).
• Design of dimensional data models (fact and dimension tables) and version-controlled SQL transformations.
• Knowledge of row-level security and data model design on a BI platform.
• Ability to build automated workflows including approval routing.
• Advanced spreadsheet skills and ability to gather requirements from non-technical stakeholders.
• Ability to manage concurrent requests and communicate status.
• Ability to explain technical work to a non-technical audience.

Responsibilities

• Design, build and maintain reporting and dashboards for project teams and corporate departments.
• Maintain the published reporting portfolio with refresh schedules and access management.
• Build data models that enable self-service analysis for end users.
• Apply brand standards to reports and client-facing deliverables.
• Implement row-level security so users see appropriate regions and measures.
• Ensure reports render correctly on phones and tablets.
• Design, build, test and maintain automated workflows replacing manual data entry.
• Convert form/spreadsheet workflows to web-based processes with approvals and audit history.
• Document automation with process maps and owners.

Education

Bachelor's degree in information systems, computer science, data analytics, business, engineering, construction management or a related field, or an equivalent combination of education and experience

Tools

SQL

dbt

Power Platform

Power Automate

Power Apps

SQL Server

Trimble Spectrum

Procore API

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

BUSINESS INTELLIGENCE ANALYST

Summary

The Business Intelligence Analyst builds and maintains the reporting, dashboards and automated workflows the company runs on. This role turns data held across the company's operating and financial systems into reporting leadership can act on, and converts manual processes into automated workflows that remove repeated handling.

The work is platform agnostic by design. The person in this seat is expected to hold the concepts and the principles, and to apply them on whichever platforms the company is using at the time.

Essential Duties and Responsibilities

Reporting & Analytics

• Design, build and maintain reporting and dashboards for project teams and corporate departments, from a defined specification agreed before development begins.
• Maintain the published reporting portfolio, including refresh schedules, access management and retirement of reports no longer in use.
• Build data models that let business users answer their own follow-up questions without submitting a new request.
• Apply company brand standards to every published report and client-facing deliverable.
• Implement row-level security so that each user sees only the regions, projects and measures appropriate to their role.
• Ensure every published report renders correctly on a phone or tablet for field use.

Process Automation

• Design, build, test and maintain automated workflows that replace manual data entry and routing across the company.
• Convert existing form-based and spreadsheet-based intake processes into web-based workflows with proper approval routing, notification and audit history.
• Document every automation with a process map, a named business owner and a defined failure and escalation path.
• Monitor deployed workflows, resolve failures and maintain version control as the systems they depend on change.
• Build automations on the company's low-code workflow platform where it fits and in code where it does not, and record which approach each automation uses and why.

Data Integration & Quality

• Write and maintain queries against the company data warehouse and the systems connected to it.
• Maintain the data pipelines that feed the reporting environment from the company's operating, financial and document systems.
• Own the reporting data warehouse end to end: ingestion from the ERP, project management , document and bidding systems; the dimensional data model; refresh schedules; backups; access control; and the documentation of each.
• Own the master-data crosswalk for project, vendor and cost-code identifiers across the operating systems. Detect and resolve identifier conflicts at the source rather than patching them in a report.
• Run automated data quality tests on every pipeline and publish a monthly data-quality scorecard to the Director.
• Run data quality checks, and investigate and resolve discrepancies between a source system and a published report.
• Maintain documentation of data definitions so that a given measure means the same thing in every report that uses it.

Partnership & Delivery

• Take requests through the departmental intake process, scope them accurately and commit to realistic delivery dates.
• Escalate competing priorities rather than absorbing them.
• Train end users on what is delivered to them and produce short reference material, so that adoption does not depend on repeat one-on-one support.
• Present findings and recommendations to project teams and department leaders in plain language.
• Measure and report usage of every published report. A report with no use in 90 days is retired or rebuilt, not left running.

Development & Growth

• Work to a development plan agreed with the Director covering data modeling, query performance, automation reliability and construction domain knowledge.
• Take on progressively larger scope as capability is demonstrated.
• Stay current on the platforms the company uses and on the direction those platforms are moving.

General

• Maintain confidentiality of financial, personnel and client information encountered in the course of the work.
• Perform other duties and special projects as assigned.

Qualification Requirements

The required list is the working foundation a candidate must hold on day one. The preferred list is capability that is welcome on arrival and will otherwise be developed in the role.

Required

• Bachelor's degree in information systems, computer science, data analytics, business, engineering, construction management or a related field, or an equivalent combination of education and experience.
• Two or more years of experience building business intelligence reporting in a production environment.
• Demonstrated ability to build and publish reporting independently on a major business intelligence platform, including the query and calculation layers.
• Working proficiency writing queries against a relational database, including joins, aggregation and window functions.
• Demonstrated ability to design dimensional data models (fact and dimension tables) and to build version-controlled, tested SQL transformations on top of them.
• Working knowledge of row-level security and data model design on a business intelligence platform.
• Demonstrated ability to build working automated workflows, including approval routing.
• Advanced spreadsheet skills, and the ability to gather requirements directly from non-technical stakeholders and translate them into a defined scope.
• Ability to manage several concurrent requests and communicate status without being asked.
• Ability to explain technical work to a non-technical audience.

Preferred, not required

• Advanced calculation work, row-level security and data model design on a business intelligence platform.
• Query performance tuning, indexing and execution plan analysis.
• Error handling in production automations: structured retry, logging and failure alerting.
• Experience reporting against or integrating construction, project management or enterprise resource planning systems.
• Prior experience in construction, engineering, architecture or another project-based industry. Candidates from other industries are encouraged to apply.
• Working knowledge of construction financial reporting: percentage-of-completion accounting, work-in-progress schedules, over and under billings, backlog and margin fade.
• Experience with Trimble Spectrum (Data Exchange / App Xchange), the Procore API, the Egnyte API, BuildingConnected or Microsoft Power Platform (Power Automate, Power Apps).
• Experience with analytics engineering tooling (dbt or equivalent) and SQL Server fundamentals: scheduled jobs, backups, access control and query performance.

Physical Demands

• Regularly required to sit or stand and walk for extended periods of time, with the occasional ability to stoop or kneel.
• Must occasionally lift and/or move up to 50 pounds.
• Vision abilities for this position include close vision as well as distance vision.
• Ability to repetitiously use hands and fingers to handle or feel and to manipulate keys on a keyboard.

Comments

• This position supports all company offices and active job sites.
• Employees may be required to travel between Blum's offices or to active job sites as required.
• Candidates will be asked to walk through examples of their own work during the technical interview.
• This position has no direct reports.
• Candidates will be asked to walk through a data model they designed and explain how a measure in it was defined, tested and secured.
• Professional appearance and demeanor required for this position.
• Medical Insurance
• Vision Insurance
• 401(k) matching
• PTO
• Life Insurance
• Short Term Disability

NOTE: Reasonable accommodations may be made to enable individuals with disabilities