Sr. Business Analyst, Corporate Strategy & Analytics

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 Analyst that will partner with key stakeholders to facilitate, financial modeling and data-driven, strategic decision-making across ERMCO. A successful candidate will be a driven individual who loves helping people across the organization. This role will work cross-functionally with operations, sales, quality, safety, human resources, IT, and engineering to develop the insights needed to make important decisions. The role will have a high level of exposure to senior leadership, and the work will have a direct impact on ERMCO’s Mergers & Acquisitions ambition and on supporting leadership decisions. The candidate must be a Microsoft Excel financial modeling ninja and a Microsoft Power BI guru with an eye for creating dashboards! This is a remote role in the following states: FL, GA, IL, KS, NC, NE, SD, TN, TX, WI, WY. Relocation is available. Responsibilities Financial Analysis M&A/ Corporate Development Performing financial statement analysis and other quantitative and qualitative assessments Reviewing confidential Information memoranda, board of directors’ presentations and financial models to develop an understanding of the company being analyzed Market research including general economic conditions, market condition and trends, acquisitions and divestitures Participating in developing and refinement of 5-yr. Long Range P&L Forecasts including P&L, Balance Sheet, Cash Flow Statements Build detailed joint venture and partnership models, including capital contribution structures, profit-sharing waterfalls, and scenario-based return analyses Strategic initiatives Construct internal project-level Net Present Value (NPV) and Internal Rate of Return (IRR) models to support capital investment decisions, greenfield/brownfield facility evaluations, and capacity expansion business cases. Prepare comprehensive business cases with clearly defined assumptions, sensitivity analyses, and risk-adjusted return profiles to support executive and board-level decision-making. Business Intelligence Dashboards Design, develop, maintain scaled, automated, user-friendly systems, reports and dashboards that will support our leaders Define key metrics/KPIs in collaboration with business stakeholders Drive cross-functional reporting by building dashboards, self-service tools, and reports to analyze and present data Support ad-hoc reporting requests and identify ways to improve scalability and enable self-service drilldowns within the Power BI tool Analytics tooling Develop and optimize semantic data models within Power BI, including DAX measures, calculated columns, and relationships across multiple data sources to ensure accurate and performant reporting Research and source external data inputs to support and enhance analytics tools, ensuring data quality, relevance, and usability for business insights and reporting Connect to and integrate diverse data sources (ERP systems, Excel workbooks, SQL databases, cloud-based platforms) using Power Query to build robust and automated data pipelines Qualifications Minimum Qualifications Bachelor’s Degree in a quantitative discipline (e.g., Finance, Accounting, Statistics, Mathematics, Data Science, Analytics, or similar) 3+ years of experience in Financial Modeling including DCF, acquisition valuations, LBO, JV Modeling, project NPV/IRR, business casing, sensitivity analysis, due diligence support 3+ years of experience in Business Intelligence, Data Analytics, or related quantitative functions 3+ years of experience in performing data analysis on Microsoft Excel using various functions Knowledge and direct experience using business intelligence reporting tools – specifically Microsoft Power BI, DAX/Power Query and Data Modeling 2+ years of SQL - Experience with relational databases and knowledge of query tools Preferred Qualifications Experience in strategy consulting, financial analyst, business intelligence analyst Join ERMCO and TRANSFORM your career! Job Locations US