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