Salary : $105,000~$125,000/y, DOE

Work Location: Irvine, CA

**Korean Bilingual Required**

The Power BI Reporting Engineer is responsible for designing, developing, maintaining, and optimizing enterprise business intelligence and reporting solutions using Microsoft Power BI. This role transforms business requirements into interactive dashboards, reports, and analytical solutions that support strategic and operational decision-making across MPA and affiliated organizations.

The engineer will work closely with business users, data engineers, database administrators, and IT teams to ensure reporting solutions are accurate, scalable, secure, and aligned with business objectives.

Key Responsibilities

Report & Dashboard Development

· Design, develop, and maintain Power BI reports and dashboards.

· Create interactive visualizations, scorecards, and executive dashboards.

· Develop reusable report templates and visualization standards.

· Optimize report performance and user experience.

· Support enterprise reporting initiatives across departments.

Data Modeling & Analytics

· Design and maintain Power BI semantic models.

· Develop star schema and dimensional models for reporting.

· Create DAX measures, calculations, KPIs, and business logic.

· Implement row-level security (RLS) and data access controls.

· Support self-service BI and governed analytics solutions.

Business Requirements & User Support

· Gather and analyze reporting requirements from business stakeholders.

· Convert business processes and KPIs into reporting solutions.

· Conduct user acceptance testing (UAT).

· Provide end-user training and documentation.

· Serve as a liaison between business teams and technical teams.

Power BI Platform Administration

Reporting Governance & Standards

· Establish reporting standards and dashboard design guidelines.

· Ensure consistency of KPIs and business definitions.

· Maintain metadata and report inventory documentation.

· Support enterprise data governance initiatives.

· Reduce duplication of reports and datasets.

Monitoring & Support

· Monitor report usage, adoption, and performance.

· Troubleshoot report failures and refresh issues.

· Resolve production incidents and root causes.

· Support business users and executive stakeholders.

· Maintain SLA and operational support standards.

· Complete tasks assigned by management.

Data Modeling & Analytics

· DAX (Data Analysis Expressions)

· Power Query (M Language)

· Data Modeling

· Semantic Models

· Star Schema / Dimensional Modeling

· KPI Design and Analytics

Data Sources & Databases

· Azure SQL Database

· MS Access

· SQL Server

· AS/400 DB2

· Azure Data Lake Storage Gen2

· Excel and CSV Data Sources

Query Languages

· SQL, T-SQL, DAX, Power Query (M)

Azure & Integration

· Azure Data Factory (ADF)

· Azure Data Lake Storage (ADLS)

· On-Premises Data Gateway

· Azure Active Directory (Entra ID)

Preferred Qualifications

· Bachelor's degree in Computer Science, Information Systems, Business Analytics, or related field.

· 5+ years of Business Intelligence or Reporting experience.

· 3+ years of Power BI development experience.

· Strong experience with DAX and data modeling.

· Experience building executive and operational dashboards.

· Experience working with Azure-based data platforms.

· Experience migrating reports from legacy reporting tools to Power BI.

· Experience supporting enterprise data warehouse (EDW) environments.

All your information will be kept confidential according to EEO guidelines.