Senior Business Intelligence Analyst

Jobtailor; California (MO); On-site; USD 120,000 - 160,000; Full time

Job summary

Jobtailor seeks a senior data analytics professional to design enterprise data models, build Power BI dashboards, and leverage Microsoft Fabric for scalable analytics across Finance and Supply Chain.

The role requires 7–10+ years of experience, strong SQL, Oracle ERP knowledge, and excellent communication to translate business needs into robust solutions. You will ensure data quality, governance, and performance while collaborating with cross-functional teams.

Qualifications

• Bachelor’s degree in CS/IS/Data Analytics or related field (or equivalent).
• 7–10+ years in data analytics and data modeling.
• Strong Power BI expertise (DAX, Power Query, semantic modeling, dashboards).
• Hands-on with Microsoft Fabric (Lakehouse, Data Factory, OneLake).
• Solid SQL skills with large, complex datasets.
• Experience designing data models for Oracle ERP R12 and/or Oracle Fusion.
• Understanding data warehousing concepts, dimensional modeling, and star schemas.
• Excellent communication to translate business needs into technical solutions.

Responsibilities

• Design, develop, maintain enterprise-level data models to support analytics, reporting, and integration needs
• Build high-quality dashboards, semantic models, and datasets using Microsoft Power BI
• Leverage Microsoft Fabric capabilities to build scalable analytics solutions
• Develop DAX measures, Power Query transformations, and dataflows to create governed, reusable data assets
• Understand and interpret Oracle E-Business Suite (R12) and Oracle Fusion Cloud ERP data structures, tables, and reporting layers
• Translate business processes from Finance, Supply Chain, and other functions into robust analytical data models
• Partner with cross-functional stakeholders to define KPIs, metrics, and data logic
• Ensure high levels of data quality, integrity, and governance across Fabric and Power BI assets
• Optimize SQL queries, ETL logic, and BI models for performance and scalability
• Support ad-hoc analytics and resolve data issues as they arise

Skills

Data analytics

Data modeling

SQL

Communication

Education

Bachelor’s degree in CS/IS/Data Analytics or related field

Tools

Microsoft Fabric

Power BI

Oracle ERP R12 / Oracle Fusion

Lakehouse

Data Factory

OneLake

Job description

Responsibilities

• Design, develop, maintain enterprise‑level data models to support analytics, reporting, and integration needs
• Build high‑quality dashboards, semantic models, and datasets using Microsoft Power BI
• Leverage Microsoft Fabric capabilities—including Lakehouse, Dataflows Gen2, Pipelines, Semantic Models, and Notebooks—to build scalable modern analytics solutions
• Develop DAX measures, Power Query transformations, and dataflows to create governed, reusable data assets
• Understand and interpret Oracle E‑Business Suite (R12) and Oracle Fusion Cloud ERP data structures, tables, and reporting layers
• Translate business processes from Finance, Supply Chain, and other functions into robust analytical data models
• Partner with cross‑functional stakeholders to define KPIs, metrics, and data logic
• Ensure high levels of data quality, integrity, and governance across Fabric and Power BI assets
• Optimize SQL queries, ETL logic, and BI models for performance and scalability
• Support ad‑hoc analytics and resolve data issues as they arise

Requirements

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or related field (or equivalent work experience)
• 7–10+ years of experience in data analytics and data modeling
• Strong expertise in Microsoft Power BI (DAX, Power Query, semantic modeling, dashboard design)
• Hands‑on experience working with Microsoft Fabric (Lakehouse, Data Engineering, Data Factory, OneLake)
• Solid SQL skills and experience working with large, complex datasets
• Deep practical experience designing data models with Oracle ERP R12 and/or Oracle Fusion will be highly desirable skill
• Understanding data warehousing concepts, dimensional modeling, and star schema design
• Excellent communication skills with the ability to translate business needs into technical solutions.