Senior BI Analyst, Corporate Strategy & Analytics (Remote)

Pioneer Transformers; United States; Remote; USD 90,000 - 130,000; Full time

Job summary

ERMCO is seeking a Sr. Business Intelligence Analyst to build executive dashboards and partner with stakeholders for data-driven decisions. The role involves cross-functional collaboration across Finance, Sales, Manufacturing, Operations, IT, HR, Legal, and Leadership.

The candidate will develop scalable analytics solutions, govern KPIs, and drive self-service reporting using Power BI and Excel. Remote within specified US states with relocation support offered.

Qualifications

• Bachelor’s Degree in relevant discipline (e.g., Data Analytics, Data Science, Statistics, Industrial Engineering or similar).
• 5+ years of experience in Business Intelligence building out executive level dashboards.
• 5+ years of experience in performing data analysis in Microsoft Excel using various functions.
• Advanced experience in Microsoft Power BI and Excel.

Responsibilities

• Design, develop, and maintain scalable analytics solutions, dashboards, and reports to support executive decision-making.
• Define, standardize, and continuously refine key business metrics and KPIs with functional leaders to ensure enterprise-wide consistency.
• Drive cross-functional reporting and insights through dashboards, self-service analytics tools, and data visualizations that enable faster, data-driven decision-making.
• Support ad hoc reporting and analytical requests while identifying opportunities to improve scalability, automation, and self-service capabilities within Power BI.
• Develop and optimize semantic data models in Power BI, including DAX measures, calculated columns, hierarchies, and relationships, to ensure accurate and reliable reporting.
• Research, acquire, and integrate external data sources to enhance internal analytics capabilities and provide greater business context and insight.
• Connect and integrate data from ERP systems, CRM platforms, manufacturing systems, SQL databases, spreadsheets, cloud applications, and third-party sources through robust, automated data pipelines.
• Define and maintain enterprise-wide data definitions, KPI calculations, business rules, and master data standards to ensure consistency across reporting platforms and business systems.
• Monitor and improve data quality through governance processes, data validation rules, exception reporting, and root-cause analysis.
• Participate in initiatives to improve master data management across enterprise systems, including customers, products, suppliers, materials, chart of accounts, and other critical master data domains.

Skills

Power BI

Excel

Data analysis

Education

Bachelor's Degree in relevant discipline

Job description

ERMCO is seeking a Sr. Business Intelligence Analyst to build executive dashboards and partner with stakeholders for data-driven decisions. The role involves cross-functional collaboration across Finance, Sales, Manufacturing, Operations, IT, HR, Legal, and Leadership.

The candidate will develop scalable analytics solutions, govern KPIs, and drive self-service reporting using Power BI and Excel. Remote within specified US states with relocation support offered.