Data Analyst at Midwest Scrap Management Inc

Description

POSITION OVERVIEW

The Data Analyst will be responsible for providing insightful analysis though data collection, structuring and design, validation and reporting to support decision-making processes within the organization. Proficiency in business intelligence tools and strong analytical skills are essential for this role. 

KEY RESPONSIBILITIES 

Data Analysis and Business Intelligence 

· Utilize business intelligence tools and software to extract, analyze, and visualize data for operations, financial reporting and decision-making purposes. 

· Identify trends, patterns, and opportunities through data analysis to support business growth and operational efficiency. 

· Develop and maintain financial models, databases, and systems to ensure accurate and reliable reporting. 

Financial Planning and Analysis

· Conduct financial analysis and performance evaluation of the company's operations, including revenue, costs, and profitability. 

· Develop financial models, forecasts, and projections to support strategic planning initiatives. 

· Collaborate with cross-functional teams to gather relevant financial data and provide recommendations for improving financial performance. 

· Develop and monitor key performance indicators (KPIs) and provide insights into variances, trends, and potential risks or opportunities. 

Budgeting and Forecasting

· Assist in the development and preparation of annual budgets and periodic forecasts. 

· Analyze actual financial results against budgeted and forecasted figures, identifying, and explaining key variances. 

· Provide support and guidance to department managers in the budgeting and forecasting process. 

· Make recommendations for cost control and optimization based on financial analysis. 

Reporting and Presentation

· Prepare comprehensive reports, presentations, and dashboards for management and key stakeholders. 

· Summarize complex information into clear and concise reports, highlighting key findings and actionable insights. 

· Communicate results, analysis, and recommendations effectively to all stakeholders. 

Continuous Improvement

· Stay updated on industry trends, regulations, tools, and best practices in data design, financial analysis and reporting. 

· Identify process improvements and implement streamlined methodologies to enhance efficiency and accuracy in financial analysis. 

· Create and implement detective controls, monitoring controls and exception reporting using databases, data warehouses and other systems. Other duties as assigned from time to time.

Requirements

Education

· Bachelor’s degree in computer information systems, computer science, data science, finance, accounting, or a related field. 

Experience and Skills

· Experience in data analysis, financial planning and analysis or accounting. 

· Strong analytical skills with the ability to gather, interpret, and analyze complex financial data. 

· Proficiency in data architecture, design, collection, validation and modeling. 

· Experience working with SQL, Python, VBA, and other languages, business intelligence tools, such as Tableau, Power BI, Power Query, and Microsoft Azure, Microsoft Fabric or similar software. 

· Advanced knowledge of Microsoft Excel and other MS Office applications. 

Key Competencies

· Excellent written and verbal communication skills with the ability to present information effectively. 

· Ability to work independently as well as collaboratively in a team environment. 

· Strong problem-solving skills and the ability to think strategically. 

· Detail-oriented with a focus on accuracy and documentation, with a commitment to meeting deadlines.

· Ability to express ideas clearly and concisely using appropriate mediums (for example, face-to-face, e-mail, and presentations), listen effectively, demonstrate understanding, and clarify meaning for others.

· Ability to analyze, define, diagnose, and resolve problems based on sound logic and rationale.

· Ability to interact cooperatively and collaboratively with others as a team, including those holding divergent and/or opposing views and goals.

· Is always courteous and professional to team members both inside and outside of the Company.

· Highly organized and professional.

· Ability to learn quickly and adapt easily to change.

· Work well with others in a fast-paced, non-stop environment.

· Flexibility to changing work conditions, assignments, and schedules.

SAFETY & PHYSICAL REQUIREMENTS 

· Strictly adhere to all Health, Safety, and Environmental standards.

· Follow all safety guidelines and protocol, including wearing all PPE. 

· Adhere to all local, state, OSHA, and environmental regulations. 

· Walk and stand for extended periods of time; walk and stand on uneven surfaces; ascend and descend multiple stairs.

· Communicate by speech and hear audible warning signals.

· Visual acuity is needed for computer utilization and operational visits.

· Be able to lift, carry, push, pull, or otherwise move objects of fifty pounds or more.

 Additional Information

· Full-time, exempt position

· In-office role, located in Kansas City, MO

· Travel: 0-10% or as needed

NOTE: The above statements describe the general nature and level of work being performed by people assigned to this job and are not intended to be an exhaustive list of all responsibilities, duties, and skills required. This job description does not constitute a contract of employment, and the company may exercise its employment-at-will rights at any time.