Pioneer Transformers logo

Sr. Business Analyst, Corporate Strategy & Analytics

Pioneer Transformers

United StatesRemoteFull-timeNo compensation foundPosted 2mo agoVerified open 4 days ago

Most applications go out cold — see where you stand first. No sign-up to start.

At a glance

Compensation
No compensation found
Location
United StatesRemote
Schedule
Full-time
Work Authorization
Not specified

Requirements

Credentials this posting asks for.

Bachelor's degree

Job overview

Pioneer Transformers is hiring a Sr. Business Analyst, Corporate Strategy & Analytics. The Sr. Business Analyst, Corporate Strategy & Analytics will partner with stakeholders to facilitate financial modeling and data-driven strategic decision-making across ERMCO. This role involves cross-functional collaboration with various departments, high exposure to senior leadership, and direct impact on Mergers & Acquisitions ambitions and leadership decisions. The successful candidate will be proficient in Microsoft Excel financial modeling and Microsoft Power BI dashboard creation.

Key focus areas include Perform financial statement analysis and other quantitative and qualitative assessments, Review confidential information memoranda, board presentations, and financial models, and Conduct market research including general economic conditions, market conditions, and trends.

Successful candidates bring Bachelor’s Degree In Quantitative Discipline, 3+ Years Financial Modeling Experience, and 3+ Years Business Intelligence Experience. Important skills include Microsoft Excel Financial Modeling, Power BI, Financial Statement Analysis, Quantitative Assessment, Market Research, and P&L Forecasts. Preferred (not required): Strategy Consulting, Financial Analyst, and Business Intelligence Analyst.

Skills & qualifications

RequiredNice to have

Skills

Microsoft Excel Financial ModelingPower BIFinancial Statement AnalysisQuantitative AssessmentMarket ResearchP&L ForecastsBalance Sheet ForecastsCash Flow Statement ForecastsJoint Venture ModelingPartnership ModelsCapital Contribution StructuresProfit-Sharing WaterfallsScenario-Based Return AnalysesNet Present Value (NPV) ModelsInternal Rate of Return (IRR) ModelsBusiness Case PreparationSensitivity AnalysesRisk-Adjusted Return ProfilesDashboard DesignDashboard DevelopmentDashboard MaintenanceKey Metrics/KPIs DefinitionCross-Functional ReportingAd-Hoc ReportingSelf-Service DrilldownsSemantic Data ModelsDAX MeasuresCalculated ColumnsData RelationshipsExternal Data SourcingData QualityPower QuerySQLRelational DatabasesQuery ToolsStrategy ConsultingFinancial AnalystBusiness Intelligence Analyst

Qualifications

Bachelor's Degree in a Quantitative Discipline3+ Years Financial Modeling Experience3+ Years Business Intelligence Experience3+ Years Data Analysis on Microsoft Excel Experience2+ Years SQL Experience

Benefits

Relocation Assistance

Full job description

Sr. Business Analyst, Corporate Strategy & Analytics ID 2026-6547 Category Business and Financial Operations - Business Operations Specialists Position Type Full-Time 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 Options Apply Apply Share Submit a Referral Refer Sorry the Share function is not working properly at this moment. Please refresh the page and try again later. Share on your newsfeed Application FAQs Software Powered by iCIMS www.icims.com

You've read the whole posting — now see how you match it.

Sr. Business Analyst, Corporate Strategy & Analytics | Olive Jobs