Power BI Architect

Job in Irvine, Orange County, California, 92713, USA

Listing for: Diverse Lynx

Full Time position
Listed on 2026-06-01

Job specializations:

IT/Tech
Data Engineer, Data Analyst, Data Warehousing, Business Systems/ Tech Analyst

Salary/Wage Range or Industry Benchmark: 130000 - 150000 USD Yearly USD 130000.00 150000.00 YEAR

Job Title: Power BI Architect
Location: Irvine, CA
Duration:
Fulltime

Skills: Data Modeling
Salary: 130K - 150K/Year

Roles and Responsibilities:

Must Have Technical/Functional Skills

Design BI platforms, data models, and reporting layers that fit the business needs.
Create systems to store, process, and analyze the organization s data.
Build BI solutions that support both current and future data needs.
Develop both logical and physical data warehouse designs, including schemas and partitions.
Build dimensional models using star and snowflake schema techniques.
Design and maintain ETL/ELT pipelines, including CDC and data flow processes.
Work closely with data engineers to ensure ETL processes align with the BI architecture.
Define standards for KPIs, metrics, naming, and dashboard design.
Maintain metadata, documentation, and data lineage to ensure accuracy and proper governance.
Implement data security and role based access controls within BI systems.
Create reporting specifications and support tools like SSRS, Business Objects, and Power BI.
Enable self service analytics by providing governed datasets and semantic layers.
Standardize dashboards and reporting formats across business teams.
Improve BI performance across queries, ETL jobs, and system configurations.
Review BI environments (DEV, QA, PROD) and recommend improvements.
Guide and mentor BI developers and junior team members on best practices.
Provide technical support to BI and analytics teams when needed.
Work with business stakeholders to turn requirements into BI solutions.
Communicate effectively with stakeholders to understand requirements, provide updates, and ensure alignment throughout the project.

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.