Power BI Analyst II
Nikkiso Clean Energy & Industrial Gases · Santa Ana, CA · 3 wk ago
On-siteAnalyst$55k–$70k/yrFull-time
Responsibilities
- Data Analysis & Operational Insights
- Analyze data from sales, manufacturing, engineering, financials, and supply chain systems to identify trends and improvement opportunities.
- Perform root cause analysis on operational issues (e.g., delivery delays, cost overruns, profitability losses, etc.).
- Support global entities in the development of local KPIs that will allow them to forecast, plan to meet existing backlog, and support the development of project dashboards.
- Deliver actionable recommendations to improve KPIs such as throughput, margins, utilization, and on-time delivery.
- Business Intelligence & Strategy
- Develop and maintain standardized KPI dashboards aligned with Cryogenic Pumps and Expanders operational and business objectives.
- Partner with stakeholders across engineering, operations, finance, and leadership to define reporting and analytics needs.
- Enable self-service BI by creating intuitive, scalable datasets and reports.
- Ensure consistency of metrics across all global locations (e.g., revenue, backlog, delivery, quality, etc.).
- Translate complex data into clear business narratives and executive-level insights.
- Support strategic initiatives in the cryogenic pumps and expanders through data analysis.
- Power BI Development
- Design and develop interactive dashboards and reports in Power BI for: Manufacturing performance, Project tracking & analytics, Financial reporting, Sales and backlog.
- B uild and maintain robust data models and semantic layers.
- Develop advanced DAX calculations and functional unit KPIs.
- Use Power Query (M) to transform and prepare data.
- Optimize performance for large datasets and enterprise reporting.
- Data Integration & Management
- Extract and integrate data from systems such as: ERP systems (e.g., Encompix, MAAS500, Manfact or similar), Manufacturing systems (MES), Service and field data systems, SQL databases and cloud platforms, SharePoint, excel files, etc.
- Collaborate with IT and local entities to collect data from multiple teams to improve data pipelines and data quality.
- Ensure data accuracy, consistency, and reliability across reports.
- Governance & Quality
- Implement data governance standards and security controls (e.g., row-level security).
- Maintain documentation for data models, KPIs, and reporting logic.
- Ensure compliance with internal data standards and audit requirements.
Qualifications
- Bachelor’s degree in Data Analytics, Engineering, Information Systems, or related field.
- 5+ years of experience in Power BI, data analysis, or business intelligence.
- Strong proficiency in: Power BI (Desktop & Service), DAX and Power Query, SQL.
- Experience analyzing operational or manufacturing data, sales data, and financial data.
- Strong understanding of business processes, KPIs, and performance metrics.
- Ability to work cross-functionally with technical and non-technical stakeholders.