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. They are seeking a Sr. Business Analyst to facilitate financial modeling and data-driven strategic decision-making, working cross-functionally with various departments to support leadership decisions and Mergers & Acquisitions ambitions.

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