Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

Tailor your resume to this BUSINESS INTELLIGENCE ANALYST role.

Rezi rewrites your resume against Frank L Blum Construction Co's job description. Free.

Resume score gauge reading 58 out of 100

Don't guess if your resume is good enough.

See how it scores against the BUSINESS INTELLIGENCE ANALYST posting at Frank L Blum Construction Co — free, in seconds.

About the Role

The Business Intelligence Analyst builds and maintains reporting, dashboards, and automated workflows. This role transforms company data into actionable insights for leadership and converts manual processes into automated workflows.

Responsibilities

Design, build, and maintain reporting and dashboards for project teams and corporate departments.
Maintain the published reporting portfolio, including refresh schedules, access management, and report retirement.
Build data models to enable business users to answer follow-up questions independently.
Apply company brand standards to all published reports and client-facing deliverables.
Implement row-level security to ensure users see only relevant data.
Ensure all published reports render correctly on mobile devices.
Design, build, test, and maintain automated workflows to replace manual data entry and routing.
Convert existing form-based and spreadsheet-based intake processes into web-based workflows with approval routing, notification, and audit history.
Document all automations with a process map, business owner, and failure/escalation path.
Monitor deployed workflows, resolve failures, and maintain version control.
Build automations on the company's low-code platform or in code, documenting the approach and rationale.
Write and maintain queries against the company data warehouse and connected systems.
Maintain data pipelines feeding the reporting environment from operating, financial, and document systems.
Own the reporting data warehouse end-to-end, including ingestion, data modeling, refresh schedules, backups, access control, and documentation.
Own the master-data crosswalk for project, vendor, and cost-code identifiers across operating systems, resolving conflicts at the source.
Run automated data quality tests on pipelines and publish a monthly data-quality scorecard.
Run data quality checks and investigate/resolve discrepancies between source systems and reports.
Maintain documentation of data definitions to ensure consistent measure interpretation.
Manage requests through the departmental intake process, accurately scope them, and commit to realistic delivery dates.
Escalate competing priorities instead of absorbing them.
Train end users on delivered solutions and produce reference materials.
Present findings and recommendations to project teams and department leaders in plain language.
Measure and report the usage of all published reports, retiring or rebuilding unused reports.
Work to a development plan covering data modeling, query performance, automation reliability, and domain knowledge.
Undertake progressively larger scope as capability is demonstrated.
Stay current on company platforms and their future direction.
Maintain confidentiality of financial, personnel, and client information.
Perform other duties and special projects as assigned.

Requirements

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 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 build version-controlled, tested SQL transformations.
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.
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 proactively.
Ability to explain technical work to a non-technical audience.
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 include close and distance vision.
Ability to repetitiously use hands and fingers to handle or feel and to manipulate keys on a keyboard.
Maintain confidentiality of financial, personnel and client information encountered in the course of the work.
Professional appearance and demeanor required.

Skills

Business Intelligence
Reporting
Dashboards
Automated Workflows
Data Modeling
Row-level Security
SQL
Query Writing
Joins
Aggregation
Window Functions
Dimensional Data Models
Fact Tables
Dimension Tables
SQL Transformations
Version Control
Testing
Spreadsheet Skills
Requirements Gathering
Stakeholder Communication
Technical Explanation
Process Automation
Low-code Platform
Data Integration
Data Quality
Data Warehouse Management
Master Data Management
Data Pipeline Maintenance
Data Definitions
Project Management
API Integration
Analytics Engineering
dbt
SQL Server Fundamentals
Scheduled Jobs
Backups
Access Control
Query Performance Tuning
Indexing
Execution Plan Analysis
Error Handling
Logging
Failure Alerting
Construction Industry Reporting
Project Management Systems Reporting
ERP Systems Reporting
Trimble Spectrum
Procore API
Egnyte API
BuildingConnected
Microsoft Power Platform
Power Automate
Power Apps
Construction Financial Reporting
Percentage-of-completion Accounting
Work-in-progress Schedules
Over and Under Billings
Backlog Management
Margin Fade Analysis

Location

Company offices
Active job sites

Work Type

Full-time
Onsite
Travel between offices or job sites as required

Experience Level

Two or more years of experience
Advanced capability development

Education Level

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.

Benefits

Medical Insurance
Dental Insurance
Vision Insurance
401(k) matching
PTO
Life Insurance
Short Term Disability
Gym Reimbursement

About the Company

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.
This position has no direct reports.

Equal Opportunity

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.