Sr. Business Intelligence Analyst, Corp Strategy & Analytics

ERMCO is seeking a Senior Business Intelligence Analyst to build executive intelligence reporting and support data-driven decisions across the organization. The role partners with leaders across multiple functions to develop dashboards, improve analytics, and provide insights that inform leadership decisions.

Responsibilities:

• Design, develop, and maintain scalable, automated, and user-friendly analytics solutions, dashboards, and reports to support executive decision-making
• Define, standardize, and continuously refine key business metrics and KPIs in partnership 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

Requirements:

• 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