Senior BI Architect: Power BI, Fabric & Oracle ERP

Talentify; Hillsboro (OR); On-site; USD 104,000 - 156,000; Full time

Job summary

Onto Innovation is a leader in advanced analytics and data engineering, seeking a seasoned Data Analyst to design enterprise-level data models, dashboards, and governance frameworks across Power BI and Microsoft Fabric. The role emphasizes translating business processes into scalable analytics and partnering with Finance, Supply Chain, and other functions to define KPIs.

You will work with Oracle ERP R12 and Fusion data structures, building semantic models and highly available datasets to

Qualifications

• 7–10+ years of experience in data analytics and data modeling.
• Strong expertise in Microsoft Power BI (DAX, Power Query, semantic modeling).
• Hands-on Microsoft Fabric experience (Lakehouse, Data Engineering, Data Factory, OneLake).
• Solid SQL skills with large, complex datasets.
• Experience with Oracle ERP R12 and/or Oracle Fusion data structures.
• Understanding data warehousing concepts, dimensional modeling, and star schema.

Responsibilities

• Design, develop, and maintain enterprise-level data models.
• Build dashboards and semantic models using Power BI.
• Leverage Microsoft Fabric capabilities to build scalable analytics solutions.
• Develop DAX measures and dataflows to create governed data assets.
• Translate business processes into robust analytical data models.
• Partner with stakeholders to define KPIs and data logic.
• Ensure data quality and governance across Fabric and Power BI assets.
• Optimize SQL queries and ETL for performance.
• Support ad-hoc analytics and resolve data issues.

Skills

Data analytics

Data modeling

Power BI

SQL

Communication

Education

Bachelor’s degree in CS/IS/Data Analytics

Tools

Microsoft Fabric

Oracle ERP R12/Fusion

Job description

Onto Innovation is a leader in advanced analytics and data engineering, seeking a seasoned Data Analyst to design enterprise-level data models, dashboards, and governance frameworks across Power BI and Microsoft Fabric. The role emphasizes translating business processes into scalable analytics and partnering with Finance, Supply Chain, and other functions to define KPIs.

You will work with Oracle ERP R12 and Fusion data structures, building semantic models and highly available datasets to