Senior Business Intelligence Engineer

SBM Management Services; Sacramento (CA); On-site; USD 130,000 - 180,000; Full time

Job summary

SBM Management Services in Sacramento, CA seeks a Senior Business Intelligence Engineer to design, build, and maintain enterprise BI solutions across a complex data ecosystem. You will integrate Workday, UKG, JDE, data warehouses, cloud platforms, and APIs to deliver dashboards and reports that support data-driven decisions.

Responsibilities include creating dashboards for executives and operations, defining KPIs, ensuring data quality, and mentoring junior BI engineers and analysts.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or related field.
• 10+ years of professional experience in business intelligence, analytics, or data engineering roles, with progression.
• Proven experience delivering enterprise-scale BI solutions across multiple systems and data sources (Workday, UKG, JDE, data warehouses, cloud platforms, APIs).

Responsibilities

• Design, develop, and maintain enterprise BI dashboards and reports across HRIS, ERP, financial and operational systems.
• Translate business requirements into scalable reporting solutions and intuitive visualizations.
• Deliver clear dashboards for executives, operators, and analysts; establish KPIs and definitions.
• Validate data accuracy and consistency across systems; optimize performance.

Skills

Advanced SQL

Data Modeling

Data Visualization

ETL

Cloud data platforms

Education

Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or related field

Tools

Power BI

SQL Server

SSRS

SSAS

Workday

UKG

JDE

APIs

Job description

Title:

Senior Business Intelligence Engineer

Job Description:

Job Overview

The Senior Business Intelligence Engineer is responsible for designing, building, and maintaining enterprise-grade business intelligence solutions across a complex and diverse data ecosystem. This role focuses on analyzing, integrating, modeling, and visualizing data from multiple internal and external sources—including Workday, UKG, JD Edwards (JDE), enterprise data warehouses, cloud-based data platforms, and third-party API connectors to deliver clear, accurate, and user-friendly dashboards and reports that support data-driven decision-making across the organization.

Roles & Responsibilities

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Other duties may be assigned.

Business Intelligence & Reporting

• Design, develop, and maintain enterprise BI dashboards and reports using data from HRIS, ERP, financial, operational, and analytical systems.

• Translate business requirements into scalable, high-quality reporting solutions and intuitive visualizations.

• Deliver clear, concise, and user-friendly dashboards for executive, operational, and analytical audiences.

• Establish and maintain standardized KPIs, metrics, and reporting definitions across reporting platforms.

Data Integration & Modeling

• Extract, transform, and model data from on-premises and cloud-based data warehouses as well as third-party APIs and connectors.

• Partner with data engineering and integration teams to ensure reliable, accurate, and trusted datasets.

• Design semantic layers and reporting models optimized for performance, usability, and scalability.

• Validate data accuracy, completeness, and consistency across systems.

SQL & Technical Development

• Write, optimize, and maintain complex SQL queries across large and diverse datasets.

• Perform query tuning and performance optimization to support scalable analytics solutions.

BI Platforms & Tools

• Build and support solutions using Microsoft BI technologies including Power BI, SQL Server, SSRS, and SSAS, as well as other reporting tools as required.

• Support governed self-service BI while maintaining role-based security and data quality standards.

Documentation & Collaboration

• Create and maintain clear documentation for dashboards, reports, data models, and metric definitions.

• Communicate insights through written reports, visualizations, and presentations tailored to technical and non-technical stakeholders.

• Provide technical guidance and mentoring to junior BI engineers and analysts.

Key Performance Indicators (KPIs) - 3/2026

• Dashboard adoption and satisfaction by business stakeholders.

• On-time delivery of high-quality dashboards and reports.

• Reliable, accurate, and trusted datasets across Workday, UKG, JDE, data warehouses, and API sources.

• Optimized query and dashboard performance (fast refresh and responsive visuals).

• Well-documented metrics, definitions, and report catalog for self-service enablement.

Qualification

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Other duties, responsibilities and activities may change or be assigned at any time with or without notice.

Education & Experience

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or related field (or equivalent experience).

• 10+ years of professional experience in business intelligence, analytics, or data engineering roles, with demonstrated progression in responsibility and scope.

• Proven experience delivering enterprise-scale BI solutions across multiple systems and data sources (e.g., Workday, UKG, JDE, data warehouses, cloud platforms, and APIs).

Knowledge, Skills & Abilities

• Advanced SQL expertise including complex joins, window functions, and performance tuning.