Steel and Pipe Supply Company, Inc.
Financial Analyst
Steel and Pipe Supply Company, Inc., Manhattan, Kansas, United States, 66506
Manhattan, KS
The Financial Analyst provides timely, relevant and accurate reporting and analysis of business results. The position identifies, develops and analyzes key drivers, metrics and modeling to support decision-making and progress tracking.
Primary Responsibilities
Provides timely, relevant and accurate reporting and analysis of business results
Utilizes systems (SAP, QlikView, Power BI, Adaptive) to consolidate and report actuals vs comparison periods and/or forecast Reconciles financial reports to source systems Identifies, develops and analyzes key drivers and metrics to support decision-making and progress tracking Suggets and drives process improvement related to reporting and analysis
Manage the execution and delivery of the financial plan and forecast
Coordinates with businesses and corporate departments on forecast development Utilizes financial systems to consolidate and report on forecasts Analyzes key drivers of forecasted results vs prior periods and projections Suggets and drives process improvement related to the forecast process
Performs ad hoc modeling and analysis
Proactively reviews and analyzes information related to business KPI’s for variance from normal trends Leverage ERP and reporting systems to accelerate speed to insights Gathers, analyzes and summarizes data related to various business proposals Monitors and reports relevant industry data and peer comparisons Develops and maintains various financial models to support the strategic planning process
Performs reporting and analysis functions for the State Steel Business Unit
Ensure State Steel financial reporting is in alignment with SPSCI standards. Learn and navigate the MetalTraq ERP system and its financial data connections. Research and resolve financial, inventory, and operational inquiries within the appropriate system of record. Act as a key tester and resource during the ERP transition from MetalTraq to SAP. Work cross-functionally to support accurate and consistent reporting throughout system changes.
Physical & Work Requirements
Requires ability to perform primary job responsibilities while spending long periods of time at a computer Complete a structured 1–2 year training program in Manhattan, Kansas 50% travel years 1-2, 0-25 % travel post training dependent upon location Bachelor’s degree in finance or accounting, or equivalent work experience 2-5 years of financial reporting, planning and analysis experience Experience utilizing and developing BI reporting and planning tools High attention to detail Strong numerical ability – use numbers as a basis in reasoning and problem solving Learning agility – ability to learn, adapt, and relearn in changing situations Problem solving skills – find solutions to difficult or complex issues where the answer is not always clear Critical thinking – actively engage with information and situations to make smart decisions Ability to learn new software and program applications Ability to prioritize in a time-sensitive environment Excellent written and verbal communication skills Advanced skills in Microsoft Office (primarily Excel) Preferred Background Experience
SAP (end user) Microsoft Fabric and/or Power BI Planning software (i.e., Adaptive Planning) We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law. EEO/AA Minorities/Female/Disabilities/Veterans Qualifications
Skills
Behaviors
Motivations Education
Experience
Licenses & Certifications
Equal Opportunity Employer. This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.
#J-18808-Ljbffr
Provides timely, relevant and accurate reporting and analysis of business results
Utilizes systems (SAP, QlikView, Power BI, Adaptive) to consolidate and report actuals vs comparison periods and/or forecast Reconciles financial reports to source systems Identifies, develops and analyzes key drivers and metrics to support decision-making and progress tracking Suggets and drives process improvement related to reporting and analysis
Manage the execution and delivery of the financial plan and forecast
Coordinates with businesses and corporate departments on forecast development Utilizes financial systems to consolidate and report on forecasts Analyzes key drivers of forecasted results vs prior periods and projections Suggets and drives process improvement related to the forecast process
Performs ad hoc modeling and analysis
Proactively reviews and analyzes information related to business KPI’s for variance from normal trends Leverage ERP and reporting systems to accelerate speed to insights Gathers, analyzes and summarizes data related to various business proposals Monitors and reports relevant industry data and peer comparisons Develops and maintains various financial models to support the strategic planning process
Performs reporting and analysis functions for the State Steel Business Unit
Ensure State Steel financial reporting is in alignment with SPSCI standards. Learn and navigate the MetalTraq ERP system and its financial data connections. Research and resolve financial, inventory, and operational inquiries within the appropriate system of record. Act as a key tester and resource during the ERP transition from MetalTraq to SAP. Work cross-functionally to support accurate and consistent reporting throughout system changes.
Physical & Work Requirements
Requires ability to perform primary job responsibilities while spending long periods of time at a computer Complete a structured 1–2 year training program in Manhattan, Kansas 50% travel years 1-2, 0-25 % travel post training dependent upon location Bachelor’s degree in finance or accounting, or equivalent work experience 2-5 years of financial reporting, planning and analysis experience Experience utilizing and developing BI reporting and planning tools High attention to detail Strong numerical ability – use numbers as a basis in reasoning and problem solving Learning agility – ability to learn, adapt, and relearn in changing situations Problem solving skills – find solutions to difficult or complex issues where the answer is not always clear Critical thinking – actively engage with information and situations to make smart decisions Ability to learn new software and program applications Ability to prioritize in a time-sensitive environment Excellent written and verbal communication skills Advanced skills in Microsoft Office (primarily Excel) Preferred Background Experience
SAP (end user) Microsoft Fabric and/or Power BI Planning software (i.e., Adaptive Planning) We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law. EEO/AA Minorities/Female/Disabilities/Veterans Qualifications
Skills
Behaviors
Motivations Education
Experience
Licenses & Certifications
Equal Opportunity Employer. This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.
#J-18808-Ljbffr