Business Intelligence Engineer — Irvine, CA

FJYbgx atAH is currently partnering with an enterprise sized company within the technology sector that is looking to hire a Business Intelligence Engineer. The primary responsibility of the BI Engineer is to design, develop, and optimize enterprise reporting, analytics, and data engineering solutions. This role is responsible for building and maintaining scalable data pipelines, integrating and transforming data from multiple sources, developing robust data models, and creating impactful dashboards and visualizations using Microsoft Power BI. The BI Engineer partners with business stakeholders to deliver actionable insights while ensuring data quality, performance, governance, and accessibility across the organization. This position is full time with full benefits and 4 days onsite in the Irvine area.

ESSENTIAL FUNCTIONS:

• Design, develop, and maintain scalable data pipelines and ETL/ELT processes to support enterprise reporting and analytics.

• Build, optimize, and manage data warehouses, data marts, and semantic data models.

• Develop and maintain interactive dashboards, reports, and visualizations using Microsoft Power BI.

• Integrate and pull data from ERP, CRM, Operation and cloud data sources.

• Collaborate with business stakeholders to gather requirements and translate them into reporting and analytical solutions.

• Create and manage Power BI datasets, measures, KPIs, and data models to support self-service analytics.

• Optimize SQL queries, data pipelines, and reporting performance for scalability and reliability.

• Monitor, troubleshoot, and resolve data integration, transformation, and reporting issues.

• Support data governance initiatives, metadata management, and documentation of data assets.

• Develop and enforce BI best practices, standards, and reporting governance frameworks.

• Stay current with emerging data engineering, analytics, and visualization technologies to continuously improve the BI environment.

QUALIFICATIONS:

• Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field.

• 4+ years of experience in data engineering, BI or similar role

• Python (data processing / ETL development)

• SQL (advanced querying, data modeling)

• Proven experience building end-to-end data pipelines

• Strong understanding of data modeling concepts

• Experience working with large datasets and distributed data systems

• Ability to work cross-functionally and communicate with non-technical stakeholders

• Power BI excel plugin, PowerPivot, and formulas

• Passion for Data Stewardship.

• Strong knowledge of ETL.

• Advanced SQL skills.

• Experience in designing and developing reporting and advanced analytics solutions.

• Excellent communication skills.

Other: This position is full time/ permanent placement with full benefits such as Medical, Dental, Vision, 401k and more!