Business Analyst

Skokie, IL - USA

Monthly Salary: Not Disclosed

Posted on: 25-10-2025

Vacancies: 1 Vacancy

Job Summary

Wells Lamont LLC

As a part of the global industrial organization Marmon Holdingswhich is backed by Berkshire Hathawayyoull be doing things that matter leading at every level and winning a better way. Were committed to making a positive impact on the world providing you with diverse learning and working opportunities and fostering a culture where everyones empowered to be their best.

Position Overview

The Business Analyst supports the Finance department with data-driven insights financial analysis and reporting that drive strategic decisions while equally focusing on automation. This role reduces manual effort by automating recurring finance processes with Python scripting and builds reliable governed Power BI dashboards and reports. Partnering closely with Controllers and cross-functional teams the Business Analyst ensures accurate timely delivery of information and continuously strengthens the robustness of our financial procedures.

Essential Duties and Responsibilities

Analytics Projects

Analyze product customer and sales data including:
SKU Count
Inflation Trends
Product / Style Ranking
80/20 Analysis and Quartile Segmentations
Tariff Analysis
Fulfill custom reporting requests as needed by leadership

Financial and Sales Reporting

Prepare and reconcile reports such as Sales vs GL AR vs Sales and Profitability Scorecards.
Maintain and update the Apprise Profitability Scorecard.
Generate Customer Profitability Reports and Sales Reports segmented by customer product and sales representative.
Develop Financial Reporting Packages for senior management review.

Planning Forecasting and Budgeting

Collaborate with finance team members on Forecasting Budgeting and Cost Maintenance efforts.
Support the development and maintenance of Proforma Templates.

Qualifications

3 years of experience in data analysis financial reporting or business intelligence.
Degree in Mathematics Computer Science Information Systems or related fields
Basic or indeterminate knowledge in Accounting/Finance
High proficiency in Python Power BI Excel SQL and related analytic tools.
- SQL: Able to write queries that join multiple tables apply filters and perform aggregations. Comfortable using SQL to retrieve and validate data for financial analysis and reporting.
- Python: Capable of writing scripts to automate routine tasks or process data files.
- Power BI: Able to connect various data sources; understands data modeling through table relationships and foundational DAX for reporting insights.
- Version Control (GitHub): Experience using Git/GitHub for branching pull requests and code reviews; comfortable with basic CI/CD concepts.
Familiarity with financial systems such as OneStream.
Excellent problem-solving and communication skills with a high attention to detail.
Ability to independently manage multiple priorities in a dynamic environment.
Experience in Retail or Finance industries is a plus.

Pay Range:

74640.00 - 111960.00

We offer a comprehensive benefits package that may include medical dental vision 401k matching and more!

Following receipt of a conditional offer of employment candidates will be required to complete additional job-related screening processes as permitted or required by applicable law.

We are an equal opportunity employer and all applicants will be considered for employment without attention to their membership in any protected class. If you require any reasonable accommodation to complete your application or any part of the recruiting process please email your request to and please be sure to include the title and the location of the position for which you are applying.

Required Experience:

Wells Lamont LLCAs a part of the global industrial organization Marmon Holdingswhich is backed by Berkshire Hathawayyoull be doing things that matter leading at every level and winning a better way. Were committed to making a positive impact on the world providing you with diverse learning and worki...