Senior Business Intelligence Engineer

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

Benefits offered by this job

Benefits package

Job summary

SBM Management Services seeks a Senior Business Intelligence Engineer to design, build, and maintain enterprise BI dashboards and reports. You will integrate data from Workday, UKG, JDE, and data warehouses to deliver accurate, user-friendly visuals for leaders and analysts.

You will translate business requirements into scalable BI solutions, optimize data models, and collaborate with data engineering to ensure trusted data. Strong SQL and Microsoft BI experience are required.

Qualifications

• 10+ years of professional BI, analytics, or data engineering experience.
• Experience delivering enterprise-scale BI solutions across multiple data sources.
• Advanced SQL with complex joins, window functions, and performance tuning.
• Strong proficiency with Microsoft BI tools (Power BI, SSRS, SSAS, SQL Server).
• Ability to translate complex concepts into clear dashboards and reports.

Responsibilities

• Design, develop, and maintain enterprise BI dashboards and reports from HRIS, ERP, financial, and operational systems.
• Translate business requirements into scalable reporting solutions and intuitive visualizations.
• Deliver clear dashboards for executive, operational, and analytical audiences.
• Establish and maintain KPIs, metrics, and definitions across platforms.
• Collaborate with data engineering to ensure trusted datasets and data quality.

Skills

Advanced SQL

Data modeling

Dashboard design

Mentoring

Education

Bachelor’s degree in Computer Science or related field

Tools

Power BI

SQL Server

SSRS

SSAS

Workday/UKG connectors

Job description

Title:Senior Business Intelligence EngineerJob Description:Job OverviewThe 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 & ResponsibilitiesTo perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Other duties may be assigned.Business Intelligence & ReportingDesign, 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 & ModelingExtract, 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 DevelopmentWrite, optimize, and maintain complex SQL queries across large and diverse datasets.Perform query tuning and performance optimization to support scalable analytics solutions.BI Platforms & ToolsBuild 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 & CollaborationCreate 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/2026Dashboard 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.QualificationTo 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 & ExperienceBachelor’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 & AbilitiesAdvanced SQL expertise including complex joins, window functions, and performance tuning.Strong experience with Microsoft BI tools (Power BI, SSRS, SSAS, SQL Server) and modern reporting platforms.Ability to translate complex technical and analytical concepts into clear, user-friendly dashboards and reports.Effective communication abilities across technical and non-technical stakeholders.Supervisory ResponsibilitiesThis position does not have direct supervisory responsibilities. May provide mentorship and technical guidance to BI analysts and engineers.Physical Demands & Work EnvironmentThe physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is regularly required to sit, use hands to finger, handle, or feel, and communicate with others. The work environment is typically a professional office setting with a low noise levelBenefits:SBM offers comprehensive benefit packages. For information about SBM's benefits, please visit SBM's website at:www.sbmmanagement.com/careers Careers – SBMSBM Management Services, LP and its affiliates are proud to be equal opportunity workplaces. We are committed to equal employment opportunity regardless of race, sex, color, ancestry, religion, national origin, sexual orientation, citizenship, age, marital status, disability, gender identity, Veteran status, or other legally protected status.