Sr. Business Analyst, Corporate Strategy & Analytics

ERMCO is the leading manufacturer of distribution transformers and engineered electrical solutions, serving electric utilities and industrial customers across North America. The Sr. Business Analyst will partner with key stakeholders to facilitate financial modeling and data-driven strategic decision-making, working cross-functionally to develop insights that impact Mergers & Acquisitions and support leadership decisions.

Responsibilities:

• 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
• 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
• 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
• 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

Requirements:

• 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
• Experience in strategy consulting, financial analyst, business intelligence analyst