Sr. Business Intelligence Analyst, Corporate Strategy & Analytics

GridBridge, Inc.; Northern (KY); Hybrid; USD 95,000 - 140,000; Full time

Job summary

ERMCO is seeking a Sr. Business Intelligence Analyst to build executive dashboards and partner with leaders across Finance, Sales, Manufacturing, and IT to enable data-driven decisions. The role offers remote work within designated US states and relocation assistance.

The ideal candidate will drive scalable analytics, refine KPIs, and deliver self-service insights using Power BI and Excel, impacting senior leadership decisions.

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 scalable analytics solutions, dashboards, and reports for executive decisions.
• Define KPIs with leaders to ensure enterprise-wide consistency.
• Drive cross-functional reporting and self-service analytics using dashboards.
• Support ad hoc reporting and automate Power BI capabilities.
• Develop semantic models in Power BI with DAX measures and relationships.
• Integrate external data sources to enrich analytics.
• Connect data from ERP, CRM, manufacturing systems, and SQL databases.
• Define enterprise data definitions and master data standards.
• Monitor data quality via governance and validation rules.
• Participate in master data management initiatives across orgs.

Skills

Executive dashboards

Data analysis

Power BI

Education

Bachelor’s Degree in relevant discipline

Tools

Power BI

Excel

Job description

Overview

About ERMCO

Electric Research and Manufacturing Cooperative, Inc. (ERMCO) is the leading manufacturer of distribution transformers and engineered electrical solutions, serving electric utilities, Original Equipment Manufacturers (OEMs), and industrial customers across North America. Headquartered in Dyersburg, Tenn., ERMCO delivers reliable, high-quality products that power homes, businesses, and communities across North America.With commitments to safety, operational excellence, and continuous improvement, ERMCO is at the forefront of supporting grid modernization and energy transition. Our vertically integrated operations, customer-focused culture, and investment in people and technology make ERMCO the Most Valued Partner for delivering resilient, sustainable power infrastructure for the future.

Job Summary

We have an opening for a Sr. Business Intelligence Analyst that will engage in build out of executive intelligence reporting and partner with key stakeholders to facilitate data-driven decisions across ERMCO. A successful candidate will be a driven individual who enjoys understanding the story behind the data and working with leaders across the organization to uncover insights. This role will work cross-functionally with Finance, Sales, Manufacturing, Operations, IT, Human Resources, Legal and the Chief of Staff teams to gather data and develop dashboards that support important decisions. The role will have a high level of exposure to senior leadership, and the work will have a direct impact in supporting leadership decisions.

This role is remote within the following states: AZ, FL, GA, IL, KS, MI, MA, NC, NE, SD, TN, TX, WI, and WY.

Candidates may reside in or relocate to any of these states. Relocation assistance will be provided.

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.

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

Let’s Build the Future Together

At ERMCO, your ideas matter, your growth is supported, and your impact is real. Whether you’re building on early career experience or launching your professional journey, you’ll have the opportunity to learn, contribute, and grow in a manufacturing environment that values innovation and collaboration.

Join ERMCO and TRANSFORM your career!

Job Locations

US